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
Hashes for harlequin_bigquery-1.0.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | f832fc92c8b66f5a73b6bd3b3a2d63f8afe864669bef93dab7bcb486903dbb89 |
|
MD5 | 9b7f43f10bdfc1b0cf8dca1b79d40e7b |
|
BLAKE2b-256 | 5feec04a75f24e82635e54bfd4edb6a71891e729cf304f0ac9c970acd33ff6cf |