wb resource create bq-dataset

Categories:

• CLI Reference

Name

wb-resource-create-bq-dataset - Add a controlled BigQuery dataset.

Synopsis

wb resource create bq-dataset [--access=<access>] [--cloning=<cloning>] [--dataset-id=<bigQueryDatasetId>] [--default-partition-lifetime=<defaultPartitionLif _ etimeSeconds>] [--default-table-lifetime=<defaultTableLifetimeSec_ _ onds>] [--description=<description>] [--format=<format>] [--location=<location>] [--workspace=<id>] (--id=<id>_)

Description

Add a controlled BigQuery dataset.

Options

• --access=<access>
  Access scope for the resource: SHARED_ACCESS, PRIVATE_ACCESS.

  Default: SHARED_ACCESS
  

• --cloning=<cloning>
  Instructions for handling when cloning the workspace: COPY_NOTHING, COPY_DEFINITION, COPY_RESOURCE, COPY_REFERENCE, COPY_LINK_REFERENCE.

  Default: COPY_RESOURCE
  

• --dataset-id=<bigQueryDatasetId>
  BigQuery dataset id. If not provided, the resource name will be used as the dataset id.

• --default-partition-lifetime=<defaultPartitionLifetimeSeconds>
  The default lifetime, in seconds, for partitions in newly created partitioned tables. This flag has no minimum value. Specify 0 to remove the existing expiration time. Any partitions in newly created partitioned tables are deleted this many seconds after the partition’s create time, adjusted to UTC (https://en.wikipedia.org/wiki/Coordinated_Universal_Time) such that time zone changes will not affect this lifetime. This value is applied if you do not set a partition expiration on the table when it is created.

• --default-table-lifetime=<defaultTableLifetimeSeconds>
  The default lifetime, in seconds, for newly created tables. The minimum value is 3600 seconds (one hour). Specify 0 to remove the existing expiration time. The expiration time evaluates to the current time plus this value, adjusted to UTC such that time zone changes will not affect this lifetime. Any table created in the dataset is deleted this many seconds after its creation time. This value is applied if you do not set a table expiration when the table is created.

• --description=<description>
  Description of the resource.

• --format=<format>
  Set the format for printing command output: JSON, TEXT. Defaults to the config format property.

  Default: null
  

• --id=<id>
  ID of the resource, scoped to the workspace. Only use letters, numbers, dashes, and underscores.

• --id=<id>
  ID of the resource, scoped to the workspace. Only use letters, numbers, dashes, and underscores.

• --location=<location>
  Dataset location (https://cloud.google.com/bigquery/docs/locations).

  Default: us-central1
  

• --workspace=<id>
  Workspace id to use for this command only.