Skip to main content

About Querybook

Querybook is a Big Data IDE that allows you to discover, create, and share data analyses, queries, and tables.

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

Supported Integrations#

Query Engines#

  • Presto
  • Hive
  • Druid
  • Snowflake
  • Big Query
  • MySQL
  • Sqlite
  • PostgreSQL
  • SQL Server
  • Oracle

Metastore#

Fetch schema and table information for data enrichment in Querybook.

  • Hive Metastore
  • Sqlalchemy

Authentication#

  • User/Password
  • OAuth
    • Google Cloud OAuth
  • LDAP

Result Storage#

Use one of the following to store query results.

  • Database (MySQL, Postgres, etc)
  • S3
  • 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.

  • Email
  • Slack
Last updated on by czgu