![](/style/images/good.png)
![](/style/images/bad.png)
Github GitHub - pinterest/querybook: Querybook is a Big Data Querying UI, combin...
source link: https://github.com/pinterest/querybook
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Querybook
Querybook is a Big Data IDE that allows you to discover, create, and share data analyses, queries, and tables. Check out the full documentation & feature highlights here.
Features
Organize analyses with rich text, queries, and charts
Compose queries with autocompletion and hovering tooltip
Use scheduling + charting in DataDocs to build dashboards
Live query collaborations with others
Add additional documentation to your tables
Get lineage, sample queries, frequent user, search ranking based on past query runs
Getting started
Prerequisite
Please install Docker before trying out Querybook.
Quick setup
Pull this repo and run make
. Visit https://localhost:10001 when the build completes.
For more details on installation, click here
Configuration
For infrastructure configuration, click here For general configuration, click here
Supported Integrations
Query Engines
- Presto
- Druid
- Snowflake
- Big Query
- MySQL
- Sqlite
- PostgreSQL
- SQL Server
- Oracle
Authentication
- User/Password
- OAuth
- Google Cloud OAuth
Metastore
Can be used to fetch schema and table information for metadata enrichment.
- Hive Metastore
- Sqlalchemy
Result Storage
Use one of the following to store query results.
- Database (MySQL, Postgres, etc)
- Google Cloud Storage
- Local file
Result Export
Upload query results from Querybook to other tools for further analyses.
- Google Sheets Export
- Python export
Notification
Get notified upon completion of queries and DataDoc invitations via IM or email.
- Slack
User Interface
Query Editor
Charting
Scheduling
Lineage & Analytics
Contributing Back
See CONTRIBUTING.
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK