harlequin-bigquery

This is a BigQuery adapter for Harlequin, a SQL IDE for the terminal.

This adapter will use Application Default Credentials to authenticate with BigQuery and run queries.

Configuration

This adapter supports the following options:

• project: The ID of the Google Cloud project to run Harlequin in. Defaults to whatever it can infer from the user's environment, i.e. gcloud config list project.
• location: The location used to run the catalog queries, which must be region-qualified. Defaults to US.

Required permissions

The user will need the permission to query both INFORMATION_SCHEMA.TABLES and INFORMATION_SCHEMA.COLUMNS to load the data catalog.

To query these views, you need the following Identity and Access Management (IAM) permissions:

• bigquery.tables.get
• bigquery.tables.list
• bigquery.routines.get
• bigquery.routines.list

Each of the following predefined IAM roles includes the necessary permissions:

• roles/bigquery.admin
• roles/bigquery.dataViewer
• roles/bigquery.metadataViewer

For more information about BigQuery permissions, see Access control with IAM.