atoti_directquery_bigquery.ConnectionConfig

final class atoti_directquery_bigquery.ConnectionConfig

Config to connect to a BigQuery database.

Example

>>> from atoti_directquery_bigquery import ConnectionConfig
>>> connection_config = ConnectionConfig()
>>> external_database = session.connect_to_external_database(connection_config)

auto_multi_column_array_conversion : AutoMultiColumnArrayConversion | None = None

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

cache : bool = True

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

column_clustered_queries : ‘all’ | ‘feeding’ = ‘feeding’

Control which queries will use clustering columns.

credentials : Path | None = None

The path to a service account key file. If None, the application default credentials will be used. That is how an identity holding no key of its own reaches BigQuery, such as one federated through workload identity federation or an impersonated service account. Google recommends federating an existing identity rather than downloading a key.

feeding_query_timeout : Duration = datetime.timedelta(seconds=3600)

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

the initial load to feed aggregate_providers and hierarchies;
the refresh operations.

lookup_mode : ‘allow’ | ‘warn’ | ‘deny’ = ‘warn’

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 : Annotated[int, Field(gt=0)] = 500

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

query_timeout : Duration = datetime.timedelta(seconds=300)

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

time_travel : bool = True

Whether to use time travel in queries.

​final class atoti_directquery_bigquery.ConnectionConfig

​Example

​auto_multi_column_array_conversion : AutoMultiColumnArrayConversion | None = None

​cache : bool = True

​column_clustered_queries : ‘all’ | ‘feeding’ = ‘feeding’

​credentials : Path | None = None

​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)

​time_travel : bool = True