- Home
- SQL Query Tools
- Querybook
On the recordRead 3 Oct 202620 facts
Querybook
On the record
- Access controls
- Environment access can be configured as public, hidden, or shareable, with private environments managed through user access controls.querybook.org · read 3 Oct 2026
- AI features
- The optional AI Assistant plugin can generate and edit SQL from text prompts, fix failed SQL, suggest SQL completions, and search tables and queries in natural language when its vector store is enabled.querybook.org · read 2 Oct 2026
- API
- Users can create API access tokens and send them in the api-access-token request header for authentication.querybook.org · read 2 Oct 2026
- Audience
- The site describes Querybook as a tool for engineers and data scientists.querybook.org · read 3 Oct 2026
- Authentication
- Documented authentication options include username and password, OAuth including Google Cloud OAuth, and LDAP.querybook.org · read 3 Oct 2026
- Charts and scheduling
- Users can create charts in DataDocs and schedule automatic DataDoc updates at set intervals.querybook.org · read 3 Oct 2026
- Collaborative notebooks
- DataDocs combine rich text, queries, and charts, and support real-time collaboration.querybook.org · read 3 Oct 2026
- Deployment
- Querybook runs in Docker; the site describes a Docker Compose demo and production deployment options including Kubernetes.querybook.org · read 3 Oct 2026
- Exports and notifications
- Documented options include Google Sheets and Python exports, plus email and Slack notifications.querybook.org · read 2 Oct 2026
- Infrastructure requirements
- The architecture documentation lists a database, Redis, Elasticsearch, and remote storage as infrastructure components, with MySQL recommended for the database.querybook.org · read 3 Oct 2026
- Integrations
- Documented query engines include Presto, Hive, Druid, Snowflake, BigQuery, MySQL, SQLite, PostgreSQL, SQL Server, and Oracle.querybook.org · read 2 Oct 2026
- Notifications
- Query completion and DataDoc invitations can generate email or Slack notifications.querybook.org · read 3 Oct 2026
- Product
- Querybook is an open-source big data IDE for discovering, creating, and sharing data analyses, queries, and tables.querybook.org · read 3 Oct 2026
- Query analytics
- Querybook analyzes executed queries to provide lineage, example queries, frequent-user information, and search and autocomplete ranking.querybook.org · read 3 Oct 2026
- Query editor
- The query editor provides table-aware autocompletion, syntax highlighting, and table information on hover or click.querybook.org · read 3 Oct 2026
- Query engines
- Documented query engines include Presto, Hive, Druid, Snowflake, BigQuery, MySQL, SQLite, PostgreSQL, SQL Server, and Oracle.querybook.org · read 3 Oct 2026
- Result storage and export
- Query results can be stored in a database, S3, Google Cloud Storage, or local files, and exported to Google Sheets or Python.querybook.org · read 3 Oct 2026
- Scale guidance
- The setup guide describes single-machine setup for trying Querybook with fewer than five users and multi-machine setup for scaling to thousands.querybook.org · read 2 Oct 2026
