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.2.tar.gz (8.2 kB view details)

Uploaded Source

Built Distribution

harlequin_bigquery-1.0.2-py3-none-any.whl (9.1 kB view details)

Uploaded Python 3

File details

Details for the file harlequin_bigquery-1.0.2.tar.gz.

File metadata

  • Download URL: harlequin_bigquery-1.0.2.tar.gz
  • Upload date:
  • Size: 8.2 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: poetry/1.7.1 CPython/3.10.0 Darwin/23.1.0

File hashes

Hashes for harlequin_bigquery-1.0.2.tar.gz
Algorithm Hash digest
SHA256 b883d884ae11e8dee9aac298d86a33906efa588fa0aeedae9ec2b90713b8fbf6
MD5 bf78c80de3f4559c3a3a0720c69ea175
BLAKE2b-256 0afffc76f5b8618753706aebfe4833b6825b6972326cb20a3f8f983af60e7e01

See more details on using hashes here.

File details

Details for the file harlequin_bigquery-1.0.2-py3-none-any.whl.

File metadata

File hashes

Hashes for harlequin_bigquery-1.0.2-py3-none-any.whl
Algorithm Hash digest
SHA256 d6a1d47ddddbaa97590051fbda35f56731044d0c166c2f42de6f509b79187325
MD5 76361cccb61f2b0fbbd3fa6b83c4f358
BLAKE2b-256 36fcfe4ea5d7b25f454731ab0da63bf29b294bb87c417d5237d81572c3fb2cf9

See more details on using hashes here.

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