I'm trying to create an external table with partitioning on Hive using the Deployment manager (.yaml). My code is like this, but it is not returning the key.
resources:
- name: test
type: bigquery.v2.table
properties:
storageClass: STANDARD
location: us-east1
datasetId: testingdataset #id do dataset
tableReference:
projectId: project #id do projeto
tableId: testing
description: Table test
schema:
fields:
- mode: nullable
name: Test1
type: STRING
- mode: nullable
name: Test2
type: STRING
- mode: nullable
name: Test3
type: STRING
externalDataConfiguration:
hivePartitioningOptions:
mode: CUSTOM
sourceUriPrefix: gs://testing-bucket/{dt:STRING}
fields: dt
sourceUris:
- gs://testing-bucket/dt=*/testing.csv
sourceFormat: CSV
csvOptions:
fieldDelimiter: ;