Export a table as Avro
Export a table as Csv
Export a table as Json
Extract locations of tables to be access by a query.
Extract tables to be accessed by a query.
Get rows from a query.
Get schema for a query without executing it.
Get table metadata.
Get table metadata.
Get rows from a table.
Get rows from a table.
Get schema from a table.
Get schema from a table.
Get list of tables in a dataset.
Get a typed iterator for a BigQuery SELECT query or table.
Get a typed iterator for a BigQuery SELECT query or table.
Note that T
must be annotated with BigQueryType.fromSchema,
BigQueryType.fromTable, BigQueryType.fromQuery, or BigQueryType.toTable.
By default the source (table or query) specified in the annotation will be used, but it can
be overridden with the newSource
parameter. For example:
@BigQueryType.fromTable("publicdata:samples.gsod") class Row // Read from [publicdata:samples.gsod] as specified in the annotation. bq.getTypedRows[Row]() // Read from [myproject:samples.gsod] instead. bq.getTypedRows[Row]("myproject:samples.gsod") // Read from a query instead. bq.getTypedRows[Row]("SELECT * FROM [publicdata:samples.gsod] LIMIT 1000")
Make a query and save results to a destination table.
Make a query and save results to a destination table.
A temporary table will be created if destinationTable
is null
and a cached table will be
returned instead if one exists.
Check if table exists.
Check if table exists. Returns true
if table exists, false
is table definitely does not
exist, throws in other cases (BigQuery exception, network issue etc.).
Check if table exists.
Check if table exists. Returns true
if table exists, false
is table definitely does not
exist, throws in other cases (BigQuery exception, network issue etc.).
Write rows to a table.
Write rows to a table.
Write a List of rows to a BigQuery table.
Write a List of rows to a BigQuery table. Note that element type T
must be annotated with
BigQueryType.
Write a List of rows to a BigQuery table.
Write a List of rows to a BigQuery table. Note that element type T
must be annotated with
BigQueryType.
A simple BigQuery client.