🗄️ Google BigQuery
Google BigQuery is a cloud-based data warehouse that uses SQL-like queries to extract insights from data stored in the cloud. After purchasing the database connector add-on, connect Google BigQuery to query your database directly from widgets on your AgencyAnalytics dashboards and reports.
Click here to read more about the database connector add-on and how to use database integration widgets.
🔌 Connect Google BigQuery
To avoid a failed connection or error when integrating Google BigQuery within an AgencyAnalytics campaign, the person connecting needs:
Google BigQuery Job User permissions for at least one project
Google BigQuery Data Viewer on the data you wish to query
If the above requirements are met, simply follow these steps to connect:
Open the Campaign where you'd like to connect Google BigQuery
Click Integrations (plug icon) on the left side menu
Search Google BigQuery in the upper right search box, then click the Google BigQuery card
Click the Connect New Account button in the bottom left
In the pop-up window, log into the Google account associated with the BigQuery database you would like to connect to, then follow the prompts in the connection window.
After authorizing the connection, you'll be brought back to the connection page, where you can select the correct account from those now available.
Once saved, Google BigQuery will be successfully connected! You can start adding BigQuery widgets to your reporting and query data right away.
AgencyAnalytics uses the same query editor as Google BigQuery to simplify your usage; you'll see a familiar estimate of how many bytes will be processed when your queries run.
💬 Need additional help?
If you have any questions, please contact our friendly support team by following these instructions! We're available 24/5 to help 😄