TableExternalDataConfiguration constructor
- required Input<
bool> autodetect, - Input<
TableExternalDataConfigurationAvroOptions?> ? avroOptions, - Input<
TableExternalDataConfigurationBigtableOptions?> ? bigtableOptions, - Input<
String?> ? compression, - Input<
String?> ? connectionId, - Input<
TableExternalDataConfigurationCsvOptions?> ? csvOptions, - Input<
List< ? decimalTargetTypes,String> ?> - Input<
String?> ? fileSetSpecType, - Input<
TableExternalDataConfigurationGoogleSheetsOptions?> ? googleSheetsOptions, - Input<
TableExternalDataConfigurationHivePartitioningOptions?> ? hivePartitioningOptions, - Input<
bool?> ? ignoreUnknownValues, - Input<
String?> ? jsonExtension, - Input<
TableExternalDataConfigurationJsonOptions?> ? jsonOptions, - Input<
int?> ? maxBadRecords, - Input<
String?> ? metadataCacheMode, - Input<
String?> ? objectMetadata, - Input<
TableExternalDataConfigurationParquetOptions?> ? parquetOptions, - Input<
String?> ? referenceFileSchemaUri, - Input<
String?> ? schema, - Input<
String?> ? sourceFormat, - required Input<
List< sourceUris,String> >
Creates a new TableExternalDataConfiguration.
autodetect Let BigQuery try to autodetect the schema
avroOptions Additional options if sourceFormat is set to
bigtableOptions Additional properties to set if
compression The compression type of the data source.
connectionId The connection specifying the credentials to be used to read
csvOptions Additional properties to set if
decimalTargetTypes Defines the list of possible SQL data types to which the source decimal values are converted. This list and the precision and the scale parameters of the decimal field determine the target type. In the order of NUMERIC, BIGNUMERIC, and STRING, a type is picked if it is in the specified list and if it supports the precision and the scale. STRING supports all precision and scale values. If none of the listed types supports the precision and the scale, the type supporting the widest range in the specified list is picked, and if a value exceeds the supported range when reading the data, an error will be thrown.
fileSetSpecType Specifies how source URIs are interpreted for constructing the file set to load.
googleSheetsOptions Additional options if
hivePartitioningOptions When set, configures hive partitioning
ignoreUnknownValues Indicates if BigQuery should
jsonExtension Used to indicate that a JSON variant, rather than normal JSON, is being used as the sourceFormat. This should only be used in combination with the JSON source format. Valid values are: GEOJSON.
jsonOptions Additional properties to set if
maxBadRecords The maximum number of bad records that
metadataCacheMode Metadata Cache Mode for the table. Set this to enable caching of metadata from external data source. Valid values are AUTOMATIC and MANUAL.
objectMetadata Object Metadata is used to create Object Tables. Object Tables contain a listing of objects (with their metadata) found at the sourceUris. If objectMetadata is set, sourceFormat should be omitted.
parquetOptions Additional properties to set if
referenceFileSchemaUri When creating an external table, the user can provide a reference file with the table schema. This is enabled for the following formats: AVRO, PARQUET, ORC.
schema A JSON schema for the external table. Schema is required
sourceFormat The data format. Please see sourceFormat under
sourceUris A list of the fully-qualified URIs that point to
Implementation
const TableExternalDataConfiguration({
required this.autodetect,
this.avroOptions,
this.bigtableOptions,
this.compression,
this.connectionId,
this.csvOptions,
this.decimalTargetTypes,
this.fileSetSpecType,
this.googleSheetsOptions,
this.hivePartitioningOptions,
this.ignoreUnknownValues,
this.jsonExtension,
this.jsonOptions,
this.maxBadRecords,
this.metadataCacheMode,
this.objectMetadata,
this.parquetOptions,
this.referenceFileSchemaUri,
this.schema,
this.sourceFormat,
required this.sourceUris,
});