camelAI connects directly to BigQuery—no dashboards needed. It speaks plain English and converts questions into optimized BigQuery SQL, handling complex data structures and nested arrays automatically. BigQuery's powerful columnar storage and serverless architecture means you can analyze petabytes of data without worrying about infrastructure. Just ask questions about user behavior, business metrics, or any dataset in your warehouse. camelAI generates BigQuery-optimized SQL, executes it efficiently, and returns results and visualizations in seconds.
Need real-time insights from your data warehouse? camelAI lets you save any query or visualization (we call these artifacts) into a dashboard. When you view a dashboard, each artifact automatically refreshes with the latest data from your BigQuery tables. BigQuery's smart caching and materialized views optimize performance, so you can have multiple dashboards tracking different aspects of your business without impacting costs. In just a few clicks, compile a snapshot of key metrics—like user engagement, data processing costs, or cross-region analytics—using live BigQuery data.
camelAI's report generation feature harnesses BigQuery's massive parallel processing capabilities—running multiple queries and exploring your data warehouse schema iteratively. Whether you're analyzing structured tables or nested JSON records, the AI can navigate complex data hierarchies to create comprehensive analyses. In about 10 minutes, you get a full report with visualizations, insights, and actionable recommendations, all powered by BigQuery's analytics engine. Perfect for exploratory analysis when you want the AI to dive deep into your data warehouse and uncover patterns you might have missed.
Yes, your app connections are secure. We use OAuth 2.0 when available or secure key authentication to authenticate and authorize access to your applications. Your data is encrypted in transit and at rest. If you revoke access to an app, the connection is immediately destroyed and we will no longer have access to that application.
camelAI's infrastructure is hosted on AWS. Data from applications is pulled only when necessary and limited to what you request in your prompt. It is stored in an EC2 cache for 5 minutes and then deleted. For more information, please see our Security Policy and our security blog post.
We use your BigQuery service account credentials to connect, executing only the specific queries you request. All credentials are encrypted at rest and in transit, and access can be revoked instantly from your settings. We recommend using a service account with read-only permissions for added security.
We only store queries temporarily (caching for up to 5 minutes) to fulfill your request. This helps optimize your BigQuery usage and costs while maintaining data freshness.
You can revoke service account access in your account settings or directly in your Google Cloud Console. This immediately terminates our ability to query your BigQuery datasets.
No. We do not train on any user data from BigQuery, and we have opted out of data sharing for training. You can read more about OpenAI's API policies here.
