Bigquery

Bases: Spout

__init__(output, state, **kwargs)

Initialize the BigQuery class.

Parameters:

Name	Type	Description	Default
output	BatchOutput	An instance of the BatchOutput class for saving the data.	required
state	State	An instance of the State class for maintaining the state.	required
**kwargs		Additional keyword arguments.	{}

Using geniusrise to invoke via command line

genius BigQuery rise \
    batch \
        --output_s3_bucket my_bucket \
        --output_s3_folder s3/folder \
    none \
    fetch \
        --project_id my_project_id dataset_id=my_dataset table_id=my_table

Using geniusrise to invoke via YAML file

version: "1"
spouts:
    my_bigquery_spout:
        name: "BigQuery"
        method: "fetch"
        args:
            project_id: "my_project_id"
            dataset_id: "my_dataset"
            table_id: "my_table"
        output:
            type: "batch"
            args:
                bucket: "my_bucket"
                s3_folder: "s3/folder"

fetch(project_id, dataset_id, table_id)

📖 Fetch data from a BigQuery table and save it in batch.

Parameters:

Name	Type	Description	Default
project_id	str	The Google Cloud project ID.	required
dataset_id	str	The BigQuery dataset ID.	required
table_id	str	The BigQuery table ID.	required

Raises:

Type	Description
Exception	If unable to connect to the BigQuery server or execute the query.