Google BigQuery + Preset
Unlock the full potential of your BigQuery data warehouse with Preset's open analytics platform. Native connectivity, petabyte-scale performance, and 40+ visualization types for your cloud data.
Open analytics for your cloud data warehouse
Native BigQuery connectivity
Connect directly to BigQuery with OAuth or service account authentication. Query standard tables, partitioned tables, and external data sources seamlessly.
Petabyte-scale performance
BigQuery's serverless architecture handles massive datasets. Preset leverages BigQuery's speed for responsive dashboards even on large data.
40+ visualization types
Go beyond basic charts. Create geographic maps, pivot tables, funnels, Sankey diagrams, and more—all from your BigQuery data.
SQL Lab for exploration
Powerful SQL IDE with autocomplete, schema browser, and query history. Explore your BigQuery datasets and save queries as reusable assets.
Scheduled reports & alerts
Automate dashboard delivery via Slack or email. Set up alerts to notify teams when metrics cross thresholds.
Embedded analytics
Embed BigQuery-powered dashboards in your applications with our SDK. Row-level security for multi-tenant use cases.
Connect Preset to BigQuery in minutes
1. Choose your auth method
Use OAuth for quick personal access, or create a service account in your GCP project with BigQuery Data Viewer and Job User roles for production use.
2. Add the connection
In Preset, add a new BigQuery database connection. Sign in with Google OAuth or upload your service account JSON and specify your default project.
3. Start visualizing
Browse your BigQuery tables, create datasets, and build dashboards. Your cloud data warehouse is ready for self-serve analytics.
Learn More
Preset Docs: BigQuery Connection
Step-by-step guide to connecting Preset to Google BigQuery.
Learn more →BigQuery + Preset FAQ
Preset supports both OAuth and service account authentication. OAuth provides a quick personal connection using your Google account. For production environments, we recommend dedicated service accounts with minimal required permissions (BigQuery Data Viewer and Job User roles).
Yes. In Preset, you can add multiple BigQuery connections—useful for connecting different GCP projects or separating dev, staging, and production environments.
Preset caches query results to reduce BigQuery costs and improve dashboard performance. You can configure cache TTL per dataset. BigQuery also has its own query result caching for repeated queries.
Yes. You can query BigQuery ML models and their predictions through Preset's SQL Lab. Create datasets from ML model outputs and visualize predictions in dashboards.
Talk to the team to learn more
Fill out the form and we'll be in touch to discuss your needs.