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 toUS
.
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
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
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
Algorithm | Hash digest | |
---|---|---|
SHA256 | b883d884ae11e8dee9aac298d86a33906efa588fa0aeedae9ec2b90713b8fbf6 |
|
MD5 | bf78c80de3f4559c3a3a0720c69ea175 |
|
BLAKE2b-256 | 0afffc76f5b8618753706aebfe4833b6825b6972326cb20a3f8f983af60e7e01 |
File details
Details for the file harlequin_bigquery-1.0.2-py3-none-any.whl
.
File metadata
- Download URL: harlequin_bigquery-1.0.2-py3-none-any.whl
- Upload date:
- Size: 9.1 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: poetry/1.7.1 CPython/3.10.0 Darwin/23.1.0
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | d6a1d47ddddbaa97590051fbda35f56731044d0c166c2f42de6f509b79187325 |
|
MD5 | 76361cccb61f2b0fbbd3fa6b83c4f358 |
|
BLAKE2b-256 | 36fcfe4ea5d7b25f454731ab0da63bf29b294bb87c417d5237d81572c3fb2cf9 |