More than 1 year has passed since last update.

bigquery ddl with hive partition on gcs

BigQuery

Posted at 2021-06-05

CREATE EXTERNAL TABLE dataset.AutoHivePartitionedTable
WITH PARTITION COLUMNS
OPTIONS (
  uris=['gs://bucket/path/*'],
  format=csv,
  hive_partition_uri_prefix='gs://bucket/path'
);

parquetの場合はformat=parquet
if not exists と or replaceの同時指定はできない．当然．．．

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up