Google BigQuery

BigQuery is a fully managed, serverless data warehouse that enables scalable analysis over petabytes of data.

ingestr supports BigQuery as both a source and destination.

URI format

The URI format for BigQuery is as follows:

bigquery://<project-name>?credentials_path=/path/to/service/account.json&location=<location>

URI parameters:

• project-name: the name of the project in which the dataset resides
• credentials_path: the path to the service account JSON file
• location: optional, the location of the dataset

The same URI structure can be used both for sources and destinations. You can read more about SQLAlchemy's BigQuery dialect here.