How to connect BigQuery to ARIQ
Use this guide when an agency connects a client's BigQuery account, or when a business connects its own BigQuery account. The connection is saved on the open project.
Google OAuth — bigquery.readonlyWho connects BigQuery
The connection is saved on one project. An agency connects each client from that client's project. A business connecting its own account uses its own project. Both follow the same Connect button.
Sign in to ARIQ with your agency user. Open the client project, then connect that client's BigQuery account. The client does not need an ARIQ login. Use the BigQuery login that can already see that client's data.
Sign in to ARIQ, open your project, and connect the BigQuery account this business already uses. You approve access with that same account.
Connect it inside ARIQ
- 1Sign in to ARIQ.
- 2Open the project this account belongs to. Switch projects from the left sidebar if you manage more than one client.
- 3Open BigQuery from the workspace tabs, or go straight to the BigQuery page.
- 4Click Connect, then Sign in with BigQuery. ARIQ sends you to BigQuery. Sign in with the account that can see this client's data and allow access. You do not paste a password into ARIQ.
- 5Stay on that project and sync. The page shows live numbers only after this account is connected. Another client's project stays empty until you connect it there too.
On BigQuery, before you click Connect
Do this in the BigQuery account that belongs to the client, or in your own account if this project is your business. Then come back to ARIQ and click Connect.
Grant BigQuery read access
BigQuery consoleThe Google user needs BigQuery Data Viewer on the dataset you want to report.
Connect Google
On the BigQuery page, choose Connect and approve read-only BigQuery access.
Pick the project
Select the Google Cloud project and sync so warehouse metrics can be used in reports.
What shows up after the account is connected
Read warehouse tables the connected Google user can query in BigQuery.