Skip to main content
atoti_directquery_bigquery.ConnectionConfig(
    *,
    time_travel: bool = True,
    cache: bool = True,
    auto_multi_column_array_conversion: AutoMultiColumnArrayConversion | None = None,
    column_clustered_queries: ‘all’ | ‘feeding’ = 'feeding',
    feeding_query_timeout: Duration = datetime.timedelta(seconds=3600),
    lookup_mode: ‘allow’ | ‘warn’ | ‘deny’ = 'warn',
    max_sub_queries: Annotated[int, Field(gt=0)] = 500,
    query_timeout: Duration = datetime.timedelta(seconds=300),
    credentials: Path | None = None,
)
Config to connect to a BigQuery database.

Attributes

credentials

The path to the BigQuery credentials file. If None, the application default credentials will be used.

auto_multi_column_array_conversion

When not None, multi-column array conversion will be performed automatically.

cache

Whether to look for query results in the external database query cache.

column_clustered_queries

Control which queries will use clustering columns.

feeding_query_timeout

Timeout for queries performed on the external database during feeding phases. The feeding phases are:

lookup_mode

Whether lookup queries on the external database are allowed. Lookup can be very slow and expensive as the database may not enforce primary keys.

max_sub_queries

Maximum number of sub queries performed when splitting a query into multi-step queries.

query_timeout

Timeout for queries performed on the external database outside feeding phases.

time_travel

Whether to use time travel in queries.