BigQuery
Este conteúdo não está disponível em sua língua ainda.
Prepare access
Section titled “Prepare access”Have your Google Cloud project ID and a service account JSON key ready. The connection form calls for BigQuery Job User and BigQuery Data Viewer permissions for read-only analysis. Grant access to the datasets you intend to query. Optional GCP lineage discovery also requires Data Lineage Viewer.
Connect
Section titled “Connect”- Open Connections and select BigQuery.
- Enter the project ID and a recognizable display name.
- Supply the service account JSON in the connection form.
- Save the connection and wait for catalog synchronization.
- Open Catalog and check that your datasets and tables are visible.
Validate and troubleshoot
Section titled “Validate and troubleshoot”Ask a small question against a known table. If a table is missing, check dataset access and sync again. If discovery works but queries fail, check the service account’s permission to run query jobs as well as its access to the data.
BigQuery query execution can incur charges in your Google Cloud project. Start with a narrow date range and only the fields needed for the question.