Skip to content

Latest commit

 

History

History
31 lines (19 loc) · 1.48 KB

README.md

File metadata and controls

31 lines (19 loc) · 1.48 KB

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.