Connect your app to BigQuery
Connect your Google BigQuery warehouse to your Lovable app to run SQL queries and build analytics dashboards. You can authenticate instantly with your Google account or set up Workload Identity Federation without storing permanent keys.
Anyone who stores analytics or operational data in Google Cloud and wants to build dashboards, reports, or internal tools on top of it.
Do this, in order
- 1
Go to Connectors in Lovable and choose BigQuery, then click Connect.
This starts the integration setup in your workspace.
- 2
Give your connection a clear display name.
A clear label helps you and your teammates recognize this data source later.
- 3
Choose your authentication method by selecting 'Connect with Google' or 'Use your own credentials' for Workload Identity Federation.
Connect with Google is fastest for prototypes, while Workload Identity Federation is designed for team and production access.
- 4
Enter your Google Cloud project ID.
BigQuery needs to know which project executes and pays for your queries.
- 5
Configure who can use the connection under Sharing.
Connections are private by default unless you share them with specific members or your entire workspace.
- 6
Click Connect at the bottom and approve the access request in the Google sign-in pop-up.
This grants Lovable short-lived access tokens to run queries according to your Google account permissions.
Paste this into your project
Connect to our BigQuery database and build an executive metrics dashboard that displays weekly revenue and active signups from our analytics tables, including filters by region and date range.
Words decoded
- BigQuery
- Google Cloud's large-scale data warehouse for running fast search and analytics queries on massive datasets.
- SQL
- The standard language used to request, filter, and summarize data from structured database tables.
- Workload Identity Federation
- A secure Google setup that lets Lovable access your cloud resources using short-lived tokens instead of storing permanent passwords or secret keys.
- IAM
- Google Cloud's permission system that controls exactly which datasets an account is allowed to view, edit, or run jobs on.
Where people get stuck
- Your browser must allow pop-ups, or the Google sign-in window will not open to authorize the connection.
- Your Google account or service account must have the BigQuery Job User role on the query project, or every query will fail.
- BigQuery query and storage usage is billed directly to your Google Cloud billing account, not through Lovable.
- If your data lives in a different project than the one running your queries, you must refer to tables using their full path (like project.dataset.table).
- If setting up Workload Identity Federation manually, never leave Attribute conditions empty, or your pool could accept tokens from unauthorized accounts.
The short version, steps, decoder and prompt on this page are written automatically from Lovable's own documentation and can lag or misread it. The official page is always the authority.