BigQueryTable

Property Value
Google Cloud Service Name BigQuery
Google Cloud Service Documentation /bigquery/docs/
Google Cloud Rest Resource Name bigquery/v2/tables
Google Cloud Rest Resource Documentation /bigquery/docs/reference/rest/v2/tables
Config Connector Resource Short Names gcpbigquerytable
gcpbigquerytables
bigquerytable
Config Connector Service Name bigquery.googleapis.com
Config Connector Resource Fully Qualified Name bigquerytables.bigquery.cnrm.cloud.google.com
Can Be Referenced by IAMPolicy/IAMPolicyMember No

Custom Resource Definition Properties

Annotations

Fields
cnrm.cloud.google.com/project-id

Spec

Schema

clustering:
- string
datasetRef:
  external: string
  name: string
  namespace: string
description: string
encryptionConfiguration:
  kmsKeyRef:
    external: string
    name: string
    namespace: string
expirationTime: integer
externalDataConfiguration:
  autodetect: boolean
  compression: string
  csvOptions:
    allowJaggedRows: boolean
    allowQuotedNewlines: boolean
    encoding: string
    fieldDelimiter: string
    quote: string
    skipLeadingRows: integer
  googleSheetsOptions:
    range: string
    skipLeadingRows: integer
  hivePartitioningOptions:
    mode: string
    sourceUriPrefix: string
  ignoreUnknownValues: boolean
  maxBadRecords: integer
  sourceFormat: string
  sourceUris:
  - string
friendlyName: string
rangePartitioning:
  field: string
  range:
    end: integer
    interval: integer
    start: integer
schema: string
timePartitioning:
  expirationMs: integer
  field: string
  requirePartitionFilter: boolean
  type: string
view:
  query: string
  useLegacySql: boolean
Fields

clustering

Optional

list (string)

clustering.[]

Optional

string

datasetRef

Required

object

datasetRef.external

Optional

string

The name of a BigQueryDataset.

datasetRef.name

Optional

string

Name of the referent. More info: https://kubernetes.io/docs/concepts/overview/working-with-objects/names/#names

datasetRef.namespace

Optional

string

Namespace of the referent. More info: https://kubernetes.io/docs/concepts/overview/working-with-objects/namespaces/

description

Optional

string

encryptionConfiguration

Optional

object

encryptionConfiguration.kmsKeyRef

Required*

object

encryptionConfiguration.kmsKeyRef.external

Optional

string

The selfLink of a KMSCryptoKey.

encryptionConfiguration.kmsKeyRef.name

Optional

string

Name of the referent. More info: https://kubernetes.io/docs/concepts/overview/working-with-objects/names/#names

encryptionConfiguration.kmsKeyRef.namespace

Optional

string

Namespace of the referent. More info: https://kubernetes.io/docs/concepts/overview/working-with-objects/namespaces/

expirationTime

Optional

integer

externalDataConfiguration

Optional

object

externalDataConfiguration.autodetect

Required*

boolean

externalDataConfiguration.compression

Optional

string

externalDataConfiguration.csvOptions

Optional

object

externalDataConfiguration.csvOptions.allowJaggedRows

Optional

boolean

externalDataConfiguration.csvOptions.allowQuotedNewlines

Optional

boolean

externalDataConfiguration.csvOptions.encoding

Optional

string

externalDataConfiguration.csvOptions.fieldDelimiter

Optional

string

externalDataConfiguration.csvOptions.quote

Required*

string

externalDataConfiguration.csvOptions.skipLeadingRows

Optional

integer

externalDataConfiguration.googleSheetsOptions

Optional

object

externalDataConfiguration.googleSheetsOptions.range

Optional

string

externalDataConfiguration.googleSheetsOptions.skipLeadingRows

Optional

integer

externalDataConfiguration.hivePartitioningOptions

Optional

object

externalDataConfiguration.hivePartitioningOptions.mode

Optional

string

externalDataConfiguration.hivePartitioningOptions.sourceUriPrefix

Optional

string

externalDataConfiguration.ignoreUnknownValues

Optional

boolean

externalDataConfiguration.maxBadRecords

Optional

integer

externalDataConfiguration.sourceFormat

Required*

string

externalDataConfiguration.sourceUris

Required*

list (string)

externalDataConfiguration.sourceUris.[]

Required*

string

friendlyName

Optional

string

rangePartitioning

Optional

object

rangePartitioning.field

Required*

string

rangePartitioning.range

Required*

object

rangePartitioning.range.end

Required*

integer

rangePartitioning.range.interval

Required*

integer

rangePartitioning.range.start

Required*

integer

schema

Optional

string

timePartitioning

Optional

object

timePartitioning.expirationMs

Optional

integer

timePartitioning.field

Optional

string

timePartitioning.requirePartitionFilter

Optional

boolean

timePartitioning.type

Required*

string

view

Optional

object

view.query

Required*

string

view.useLegacySql

Optional

boolean

* Field is required when parent field is specified

Status

Schema

conditions:
- lastTransitionTime: string
  message: string
  reason: string
  status: string
  type: string
creationTime: integer
etag: string
lastModifiedTime: integer
location: string
numBytes: integer
numLongTermBytes: integer
numRows: integer
selfLink: string
type: string
Fields
conditions

list (object)

conditions.[]

object

conditions.[].lastTransitionTime

string

Last time the condition transitioned from one status to another.

conditions.[].message

string

Human-readable message indicating details about last transition.

conditions.[].reason

string

Unique, one-word, CamelCase reason for the condition's last transition.

conditions.[].status

string

Status is the status of the condition. Can be True, False, Unknown.

conditions.[].type

string

Type is the type of the condition.

creationTime

integer

etag

string

lastModifiedTime

integer

location

string

numBytes

integer

numLongTermBytes

integer

numRows

integer

selfLink

string

type

string

Sample YAML(s)

Typical Use Case

# Copyright 2020 Google LLC
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
#     http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.

apiVersion: bigquery.cnrm.cloud.google.com/v1beta1
kind: BigQueryTable
metadata:
  name: bigquerytablesample
  labels:
    data-source: "external"
    schema-type: "auto-junk"
spec:
  description: "BigQuery Sample Table"
  datasetRef:
    name: bigquerytabledep
  friendlyName: bigquerytable-sample
  externalDataConfiguration:
    autodetect: true
    compression: NONE
    ignoreUnknownValues: false
    maxBadRecords: 10
    sourceFormat: CSV
    sourceUris:
      - "gs://gcp-public-data-landsat/LC08/01/044/034/LC08_L1GT_044034_20130330_20170310_01_T2/LC08_L1GT_044034_20130330_20170310_01_T2_ANG.txt"
      - "gs://gcp-public-data-landsat/LC08/01/044/034/LC08_L1GT_044034_20130330_20180201_01_T2/LC08_L1GT_044034_20130330_20180201_01_T2_ANG.txt"
---
apiVersion: bigquery.cnrm.cloud.google.com/v1beta1
kind: BigQueryDataset
metadata:
  name: bigquerytabledep
spec:
  friendlyName: bigquerytable-dep