Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

...

Using BigQuery Connections

Info

NOTE: JSON data stored in BigQuery is not supported for ingest or publication.

Uses of BigQuery

D s product
 can use BigQuery for the following tasks:

...

Info

NOTE: In some environments, users may not be permitted the bigquery.datasets.create permission, and

D s dataflow
jobs on BigQuery sources fail. As a workaround, an administrator can define a BigQuery dataset for use for these jobs. This dataset is used by
D s product
productdp
for storing temporary tables of intermediate query results when running
D s dataflow
jobs on BigQuery sources, which eliminates the need for the bigquery.datasets.create permission in the service account. For more information on defining this BigQuery query dataset, see Dataprep Project Settings Page.

Info

NOTE: Object and Array data types are written back to BigQuery as string values. Some Array data types are written as arrays. For more information, see BigQuery Data Type Conversions.

Info

NOTE: BigQuery does not support destinations with a dot (.) in the name. For more information, see https://cloud.google.com/bigquery/docs/tables#table_naming.

...