Table is the Schema for the Tables API. Creates a table resource in a dataset for Google BigQuery.
Type
CRD
Group
bigquery.gcp.upbound.io
Version
v1beta1
apiVersion: bigquery.gcp.upbound.io/v1beta1
kind: Table
TableSpec defines the desired state of Table
No description provided.
Specifies column names to use for data clustering. Up to four top-level columns are allowed, and should be specified in descending priority order.
Reference to a Dataset in bigquery to populate datasetId.
Policies for referencing.
Selector for a Dataset in bigquery to populate datasetId.
Policies for selection.
Specifies how the table should be encrypted. If left blank, the table will be encrypted with a Google-managed key; that process is transparent to the user. Structure is documented below.
Describes the data format, location, and other properties of a table stored outside of BigQuery. By defining these properties, the data source can then be queried as if it were a standard BigQuery table. Structure is documented below.
Additional options if source_format is set to "AVRO". Structure is documented below.
Additional properties to set if source_format is set to "CSV". Structure is documented below.
Additional options if source_format is set to "GOOGLE_SHEETS". Structure is documented below.
When set, configures hive partitioning support. Not all storage formats support hive partitioning -- requesting hive partitioning on an unsupported format will lead to an error, as will providing an invalid specification. Structure is documented below.
Additional properties to set if source_format is set to "JSON". Structure is documented below.
Additional properties to set if source_format is set to "PARQUET". Structure is documented below.
A list of the fully-qualified URIs that point to your data in Google Cloud.
If specified, configures this table as a materialized view. Structure is documented below.
Defines the primary key and foreign keys. Structure is documented below.
Present only if the table has a foreign key. The foreign key is not enforced. Structure is documented below.
: The pair of the foreign key column and primary key column. Structure is documented below.
Represents the primary key constraint on a table's columns. Present only if the table has a primary key. The primary key is not enforced. Structure is documented below.
: The columns that are composed of the primary key constraint.
No description provided.
If specified, configures time-based partitioning for this table. Structure is documented below.
If specified, configures this table as a view. Structure is documented below.
THIS IS A BETA FIELD. It will be honored unless the Management Policies feature flag is disabled. InitProvider holds the same fields as ForProvider, with the exception of Identifier and other resource reference fields. The fields that are in InitProvider are merged into ForProvider when the resource is created. The same fields are also added to the terraform ignore_changes hook, to avoid updating them after creation. This is useful for fields that are required on creation, but we do not desire to update them after creation, for example because of an external controller is managing them, like an autoscaler.
Specifies column names to use for data clustering. Up to four top-level columns are allowed, and should be specified in descending priority order.
Specifies how the table should be encrypted. If left blank, the table will be encrypted with a Google-managed key; that process is transparent to the user. Structure is documented below.
Describes the data format, location, and other properties of a table stored outside of BigQuery. By defining these properties, the data source can then be queried as if it were a standard BigQuery table. Structure is documented below.
Additional options if source_format is set to "AVRO". Structure is documented below.
Additional properties to set if source_format is set to "CSV". Structure is documented below.
Additional options if source_format is set to "GOOGLE_SHEETS". Structure is documented below.
When set, configures hive partitioning support. Not all storage formats support hive partitioning -- requesting hive partitioning on an unsupported format will lead to an error, as will providing an invalid specification. Structure is documented below.
Additional properties to set if source_format is set to "JSON". Structure is documented below.
Additional properties to set if source_format is set to "PARQUET". Structure is documented below.
A list of the fully-qualified URIs that point to your data in Google Cloud.
If specified, configures this table as a materialized view. Structure is documented below.
Defines the primary key and foreign keys. Structure is documented below.
Present only if the table has a foreign key. The foreign key is not enforced. Structure is documented below.
: The pair of the foreign key column and primary key column. Structure is documented below.
Represents the primary key constraint on a table's columns. Present only if the table has a primary key. The primary key is not enforced. Structure is documented below.
: The columns that are composed of the primary key constraint.
No description provided.
If specified, configures time-based partitioning for this table. Structure is documented below.
If specified, configures this table as a view. Structure is documented below.
THIS IS A BETA FIELD. It is on by default but can be opted out through a Crossplane feature flag. ManagementPolicies specify the array of actions Crossplane is allowed to take on the managed and external resources. This field is planned to replace the DeletionPolicy field in a future release. Currently, both could be set independently and non-default values would be honored if the feature flag is enabled. If both are custom, the DeletionPolicy field will be ignored. See the design doc for more information: https://github.com/crossplane/crossplane/blob/499895a25d1a1a0ba1604944ef98ac7a1a71f197/design/design-doc-observe-only-resources.md?plain=1#L223 and this one: https://github.com/crossplane/crossplane/blob/444267e84783136daa93568b364a5f01228cacbe/design/one-pager-ignore-changes.md
ProviderConfigReference specifies how the provider that will be used to create, observe, update, and delete this managed resource should be configured.
Policies for referencing.
PublishConnectionDetailsTo specifies the connection secret config which contains a name, metadata and a reference to secret store config to which any connection details for this managed resource should be written. Connection details frequently include the endpoint, username, and password required to connect to the managed resource.
WriteConnectionSecretToReference specifies the namespace and name of a Secret to which any connection details for this managed resource should be written. Connection details frequently include the endpoint, username, and password required to connect to the managed resource. This field is planned to be replaced in a future release in favor of PublishConnectionDetailsTo. Currently, both could be set independently and connection details would be published to both without affecting each other.
TableStatus defines the observed state of Table.
No description provided.
Specifies column names to use for data clustering. Up to four top-level columns are allowed, and should be specified in descending priority order.
Specifies how the table should be encrypted. If left blank, the table will be encrypted with a Google-managed key; that process is transparent to the user. Structure is documented below.
Describes the data format, location, and other properties of a table stored outside of BigQuery. By defining these properties, the data source can then be queried as if it were a standard BigQuery table. Structure is documented below.
Additional options if source_format is set to "AVRO". Structure is documented below.
Additional properties to set if source_format is set to "CSV". Structure is documented below.
Additional options if source_format is set to "GOOGLE_SHEETS". Structure is documented below.
When set, configures hive partitioning support. Not all storage formats support hive partitioning -- requesting hive partitioning on an unsupported format will lead to an error, as will providing an invalid specification. Structure is documented below.
Additional properties to set if source_format is set to "JSON". Structure is documented below.
Additional properties to set if source_format is set to "PARQUET". Structure is documented below.
A list of the fully-qualified URIs that point to your data in Google Cloud.
If specified, configures this table as a materialized view. Structure is documented below.
Defines the primary key and foreign keys. Structure is documented below.
Present only if the table has a foreign key. The foreign key is not enforced. Structure is documented below.
: The pair of the foreign key column and primary key column. Structure is documented below.
Represents the primary key constraint on a table's columns. Present only if the table has a primary key. The primary key is not enforced. Structure is documented below.
: The columns that are composed of the primary key constraint.
No description provided.
If specified, configures time-based partitioning for this table. Structure is documented below.
If specified, configures this table as a view. Structure is documented below.
Conditions of the resource.
foo
apiVersion: bigquery.gcp.upbound.io/v1beta1
kind: Table
metadata:
annotations:
meta.upbound.io/example-id: bigquery/v1beta1/job
upjet.upbound.io/manual-intervention: "Dependent resource skipped: This resource
requires a schema to be provisioned in the referenced dataset's table"
labels:
testing.upbound.io/example-name: foo
name: foo
spec:
forProvider:
datasetIdSelector:
matchLabels:
testing.upbound.io/example-name: bar
deletionProtection: false
default
apiVersion: bigquery.gcp.upbound.io/v1beta1
kind: Table
metadata:
annotations:
meta.upbound.io/example-id: bigquery/v1beta1/tableiammember
upjet.upbound.io/manual-intervention: "Dependent resource skipped: Member refers to an existing user account"
labels:
testing.upbound.io/example-name: default
name: default
spec:
forProvider:
datasetIdSelector:
matchLabels:
testing.upbound.io/example-name: default
deletionProtection: false
labels:
env: default
schema: |
[
{
"name": "permalink",
"type": "STRING",
"mode": "NULLABLE",
"description": "The Permalink"
},
{
"name": "state",
"type": "STRING",
"mode": "NULLABLE",
"description": "State where the head office is located"
}
]
timePartitioning:
- type: DAY
default
apiVersion: bigquery.gcp.upbound.io/v1beta1
kind: Table
metadata:
annotations:
meta.upbound.io/example-id: bigquery/v1beta1/table
labels:
testing.upbound.io/example-name: default
name: default
spec:
forProvider:
datasetIdSelector:
matchLabels:
testing.upbound.io/example-name: default
deletionProtection: false
labels:
env: default
schema: |
[
{
"name": "permalink",
"type": "STRING",
"mode": "NULLABLE",
"description": "The Permalink"
},
{
"name": "state",
"type": "STRING",
"mode": "NULLABLE",
"description": "State where the head office is located"
}
]
timePartitioning:
- type: DAY
default
apiVersion: bigquery.gcp.upbound.io/v1beta1
kind: Table
metadata:
annotations:
meta.upbound.io/example-id: bigquery/v1beta1/tableiampolicy
upjet.upbound.io/manual-intervention: "Dependent resource skipped: Policy data
refers to an existing user account"
labels:
testing.upbound.io/example-name: default
name: default
spec:
forProvider:
datasetIdSelector:
matchLabels:
testing.upbound.io/example-name: default
deletionProtection: false
labels:
env: default
schema: |
[
{
"name": "permalink",
"type": "STRING",
"mode": "NULLABLE",
"description": "The Permalink"
},
{
"name": "state",
"type": "STRING",
"mode": "NULLABLE",
"description": "State where the head office is located"
}
]
timePartitioning:
- type: DAY
default
apiVersion: bigquery.gcp.upbound.io/v1beta1
kind: Table
metadata:
annotations:
meta.upbound.io/example-id: bigquery/v1beta1/tableiambinding
upjet.upbound.io/manual-intervention: "Dependent resource skipped: Member refers to an existing user account"
labels:
testing.upbound.io/example-name: default
name: default
spec:
forProvider:
datasetIdSelector:
matchLabels:
testing.upbound.io/example-name: default
deletionProtection: false
labels:
env: default
schema: |
[
{
"name": "permalink",
"type": "STRING",
"mode": "NULLABLE",
"description": "The Permalink"
},
{
"name": "state",
"type": "STRING",
"mode": "NULLABLE",
"description": "State where the head office is located"
}
]
timePartitioning:
- type: DAY
© 2022 Upbound, Inc.
Discover the building blocksfor your internal cloud platform.