names of the fields in the table that should be read. If empty, all fields will be read. If the specified field is a nested field, all the sub-fields in the field will be selected.
SQL text filtering statement, similar ti a WHERE clause in a query. Currently, we support combinations of predicates that are a comparison between a column and a constant value in SQL statement. Aggregates are not supported. For example:
"a > DATE '2014-09-27' AND (b > 5 AND c LIKE 'date')"
String formatting syntax can be used in tableSpec
when additional args
are supplied. For
example:
@BigQueryType.fromStorage("project:dataset.%s", "table")
"$LATEST" can be used as a placeholder for table partitions. The latest partition available will be used. For example:
@BigQueryType.fromStorage("project:dataset.table_%s", "$LATEST")
Also generate a companion object with convenience methods.
Macro annotation for a BigQuery table using the storage API.
Generate case classes for BigQuery storage API, including column projection and filtering. Note that
tableSpec
must be a string literal in the form ofproject:dataset.table
with optional.stripMargin
at the end. For example: