Class TableExternalDataConfiguration

Inheritance

System.Object

TableExternalDataConfiguration

Inherited Members

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

Namespace: Pulumi.Gcp.BigQuery.Outputs

Assembly: Pulumi.Gcp.dll

Syntax

public sealed class TableExternalDataConfiguration

Fields

Autodetect

• Let BigQuery try to autodetect the schema and format of the table.

Declaration

public readonly bool Autodetect

Field Value

Type	Description
System.Boolean

Compression

The compression type of the data source. Valid values are "NONE" or "GZIP".

Declaration

public readonly string Compression

Field Value

Type	Description
System.String

CsvOptions

Additional properties to set if source_format is set to "CSV". Structure is documented below.

Declaration

public readonly TableExternalDataConfigurationCsvOptions CsvOptions

Field Value

Type	Description
TableExternalDataConfigurationCsvOptions

GoogleSheetsOptions

Additional options if source_format is set to "GOOGLE_SHEETS". Structure is documented below.

Declaration

public readonly TableExternalDataConfigurationGoogleSheetsOptions GoogleSheetsOptions

Field Value

Type	Description
TableExternalDataConfigurationGoogleSheetsOptions

IgnoreUnknownValues

Indicates if BigQuery should allow extra values that are not represented in the table schema. If true, the extra values are ignored. If false, records with extra columns are treated as bad records, and if there are too many bad records, an invalid error is returned in the job result. The default value is false.

Declaration

public readonly bool? IgnoreUnknownValues

Field Value

Type	Description
System.Nullable<System.Boolean>

MaxBadRecords

The maximum number of bad records that BigQuery can ignore when reading data.

Declaration

public readonly int? MaxBadRecords

Field Value

Type	Description
System.Nullable<System.Int32>

SourceFormat

The data format. Supported values are: "CSV", "GOOGLE_SHEETS", "NEWLINE_DELIMITED_JSON", "AVRO", "PARQUET", and "DATSTORE_BACKUP". To use "GOOGLE_SHEETS" the scopes must include "https://www.googleapis.com/auth/drive.readonly".

Declaration

public readonly string SourceFormat

Field Value

Type	Description
System.String

SourceUris

A list of the fully-qualified URIs that point to your data in Google Cloud.

Declaration

public readonly ImmutableArray<string> SourceUris

Field Value

Type	Description
System.Collections.Immutable.ImmutableArray<System.String>