Skip to main content

A Harlequin adapter for Google BigQuery.

Project description

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.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

harlequin_bigquery-1.0.0.tar.gz (11.9 kB view hashes)

Uploaded Source

Built Distribution

harlequin_bigquery-1.0.0-py3-none-any.whl (12.3 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page