Dataquery🔗

Constructor🔗

Dataquery()

Methods🔗

build🔗

Builds the object.

def build() -> bigquery.Dataquery

convert_to_utc🔗

def convert_to_utc(convert_to_utc: bool) -> typing.Self

dataset🔗

def dataset(dataset: str) -> typing.Self

datasource🔗

For mixed data sources the selected datasource is on the query level.

For non mixed scenarios this is undefined.

TODO find a better way to do this ^ that's friendly to schema

TODO this shouldn't be unknown but DataSourceRef | null

def datasource(datasource: dashboard.DataSourceRef) -> typing.Self

editor_mode🔗

def editor_mode(editor_mode: bigquery.EditorMode) -> typing.Self

format_val🔗

def format_val(format_val: bigquery.QueryFormat) -> typing.Self

hide🔗

true if query is disabled (ie should not be returned to the dashboard)

Note this does not always imply that the query should not be executed since

the results from a hidden query may be used as the input to other queries (SSE etc)

def hide(hide: bool) -> typing.Self

location🔗

def location(location: str) -> typing.Self

partitioned🔗

def partitioned(partitioned: bool) -> typing.Self

partitioned_field🔗

def partitioned_field(partitioned_field: str) -> typing.Self

project🔗

def project(project: str) -> typing.Self

query_priority🔗

def query_priority(query_priority: bigquery.QueryPriority) -> typing.Self

query_type🔗

Specify the query flavor

TODO make this required and give it a default

def query_type(query_type: str) -> typing.Self

raw_query🔗

def raw_query(raw_query: bool) -> typing.Self

raw_sql🔗

def raw_sql(raw_sql: str) -> typing.Self

ref_id🔗

A unique identifier for the query within the list of targets.

In server side expressions, the refId is used as a variable name to identify results.

By default, the UI will assign A->Z; however setting meaningful names may be useful.

def ref_id(ref_id: str) -> typing.Self

sharded🔗

def sharded(sharded: bool) -> typing.Self

sql🔗

def sql(sql: cogbuilder.Builder[bigquery.SQLExpression]) -> typing.Self

table🔗

def table(table: str) -> typing.Self

time_shift🔗

def time_shift(time_shift: str) -> typing.Self