1. Packages
  2. Google Cloud Native
  3. API Docs
  4. bigquery
  5. bigquery/v2
  6. Job

Google Cloud Native is in preview. Google Cloud Classic is fully supported.

Google Cloud Native v0.32.0 published on Wednesday, Nov 29, 2023 by Pulumi

google-native.bigquery/v2.Job

Explore with Pulumi AI

google-native logo

Google Cloud Native is in preview. Google Cloud Classic is fully supported.

Google Cloud Native v0.32.0 published on Wednesday, Nov 29, 2023 by Pulumi

    Starts a new asynchronous job. Requires the Can View project role. Auto-naming is currently not supported for this resource.

    Create Job Resource

    Resources are created with functions called constructors. To learn more about declaring and configuring resources, see Resources.

    Constructor syntax

    new Job(name: string, args?: JobArgs, opts?: CustomResourceOptions);
    @overload
    def Job(resource_name: str,
            args: Optional[JobArgs] = None,
            opts: Optional[ResourceOptions] = None)
    
    @overload
    def Job(resource_name: str,
            opts: Optional[ResourceOptions] = None,
            configuration: Optional[JobConfigurationArgs] = None,
            job_reference: Optional[JobReferenceArgs] = None,
            project: Optional[str] = None,
            source: Optional[Union[pulumi.Asset, pulumi.Archive]] = None)
    func NewJob(ctx *Context, name string, args *JobArgs, opts ...ResourceOption) (*Job, error)
    public Job(string name, JobArgs? args = null, CustomResourceOptions? opts = null)
    public Job(String name, JobArgs args)
    public Job(String name, JobArgs args, CustomResourceOptions options)
    
    type: google-native:bigquery/v2:Job
    properties: # The arguments to resource properties.
    options: # Bag of options to control resource's behavior.
    
    

    Parameters

    name string
    The unique name of the resource.
    args JobArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    resource_name str
    The unique name of the resource.
    args JobArgs
    The arguments to resource properties.
    opts ResourceOptions
    Bag of options to control resource's behavior.
    ctx Context
    Context object for the current deployment.
    name string
    The unique name of the resource.
    args JobArgs
    The arguments to resource properties.
    opts ResourceOption
    Bag of options to control resource's behavior.
    name string
    The unique name of the resource.
    args JobArgs
    The arguments to resource properties.
    opts CustomResourceOptions
    Bag of options to control resource's behavior.
    name String
    The unique name of the resource.
    args JobArgs
    The arguments to resource properties.
    options CustomResourceOptions
    Bag of options to control resource's behavior.

    Example

    The following reference example uses placeholder values for all input properties.

    var google_nativeJobResource = new GoogleNative.BigQuery.V2.Job("google-nativeJobResource", new()
    {
        Configuration = new GoogleNative.BigQuery.V2.Inputs.JobConfigurationArgs
        {
            Copy = new GoogleNative.BigQuery.V2.Inputs.JobConfigurationTableCopyArgs
            {
                CreateDisposition = "string",
                DestinationEncryptionConfiguration = new GoogleNative.BigQuery.V2.Inputs.EncryptionConfigurationArgs
                {
                    KmsKeyName = "string",
                },
                DestinationExpirationTime = "any",
                DestinationTable = new GoogleNative.BigQuery.V2.Inputs.TableReferenceArgs
                {
                    DatasetId = "string",
                    Project = "string",
                    TableId = "string",
                },
                OperationType = "string",
                SourceTable = new GoogleNative.BigQuery.V2.Inputs.TableReferenceArgs
                {
                    DatasetId = "string",
                    Project = "string",
                    TableId = "string",
                },
                SourceTables = new[]
                {
                    new GoogleNative.BigQuery.V2.Inputs.TableReferenceArgs
                    {
                        DatasetId = "string",
                        Project = "string",
                        TableId = "string",
                    },
                },
                WriteDisposition = "string",
            },
            DryRun = false,
            Extract = new GoogleNative.BigQuery.V2.Inputs.JobConfigurationExtractArgs
            {
                Compression = "string",
                DestinationFormat = "string",
                DestinationUri = "string",
                DestinationUris = new[]
                {
                    "string",
                },
                FieldDelimiter = "string",
                PrintHeader = false,
                SourceModel = new GoogleNative.BigQuery.V2.Inputs.ModelReferenceArgs
                {
                    DatasetId = "string",
                    ModelId = "string",
                    Project = "string",
                },
                SourceTable = new GoogleNative.BigQuery.V2.Inputs.TableReferenceArgs
                {
                    DatasetId = "string",
                    Project = "string",
                    TableId = "string",
                },
                UseAvroLogicalTypes = false,
            },
            JobTimeoutMs = "string",
            Labels = 
            {
                { "string", "string" },
            },
            Load = new GoogleNative.BigQuery.V2.Inputs.JobConfigurationLoadArgs
            {
                AllowJaggedRows = false,
                AllowQuotedNewlines = false,
                Autodetect = false,
                Clustering = new GoogleNative.BigQuery.V2.Inputs.ClusteringArgs
                {
                    Fields = new[]
                    {
                        "string",
                    },
                },
                ConnectionProperties = new[]
                {
                    new GoogleNative.BigQuery.V2.Inputs.ConnectionPropertyArgs
                    {
                        Key = "string",
                        Value = "string",
                    },
                },
                CreateDisposition = "string",
                CreateSession = false,
                DecimalTargetTypes = new[]
                {
                    "string",
                },
                DestinationEncryptionConfiguration = new GoogleNative.BigQuery.V2.Inputs.EncryptionConfigurationArgs
                {
                    KmsKeyName = "string",
                },
                DestinationTable = new GoogleNative.BigQuery.V2.Inputs.TableReferenceArgs
                {
                    DatasetId = "string",
                    Project = "string",
                    TableId = "string",
                },
                DestinationTableProperties = new GoogleNative.BigQuery.V2.Inputs.DestinationTablePropertiesArgs
                {
                    Description = "string",
                    ExpirationTime = "string",
                    FriendlyName = "string",
                    Labels = 
                    {
                        { "string", "string" },
                    },
                },
                Encoding = "string",
                FieldDelimiter = "string",
                FileSetSpecType = "string",
                HivePartitioningOptions = new GoogleNative.BigQuery.V2.Inputs.HivePartitioningOptionsArgs
                {
                    Mode = "string",
                    RequirePartitionFilter = false,
                    SourceUriPrefix = "string",
                },
                IgnoreUnknownValues = false,
                JsonExtension = "string",
                MaxBadRecords = 0,
                NullMarker = "string",
                ParquetOptions = new GoogleNative.BigQuery.V2.Inputs.ParquetOptionsArgs
                {
                    EnableListInference = false,
                    EnumAsString = false,
                },
                PreserveAsciiControlCharacters = false,
                ProjectionFields = new[]
                {
                    "string",
                },
                Quote = "string",
                RangePartitioning = new GoogleNative.BigQuery.V2.Inputs.RangePartitioningArgs
                {
                    Field = "string",
                    Range = new GoogleNative.BigQuery.V2.Inputs.RangePartitioningRangeArgs
                    {
                        End = "string",
                        Interval = "string",
                        Start = "string",
                    },
                },
                ReferenceFileSchemaUri = "string",
                Schema = new GoogleNative.BigQuery.V2.Inputs.TableSchemaArgs
                {
                    Fields = new[]
                    {
                        new GoogleNative.BigQuery.V2.Inputs.TableFieldSchemaArgs
                        {
                            Categories = new GoogleNative.BigQuery.V2.Inputs.TableFieldSchemaCategoriesArgs
                            {
                                Names = new[]
                                {
                                    "string",
                                },
                            },
                            Collation = "string",
                            DefaultValueExpression = "string",
                            Description = "string",
                            Fields = new[]
                            {
                                tableFieldSchema,
                            },
                            MaxLength = "string",
                            Mode = "string",
                            Name = "string",
                            PolicyTags = new GoogleNative.BigQuery.V2.Inputs.TableFieldSchemaPolicyTagsArgs
                            {
                                Names = new[]
                                {
                                    "string",
                                },
                            },
                            Precision = "string",
                            RangeElementType = new GoogleNative.BigQuery.V2.Inputs.TableFieldSchemaRangeElementTypeArgs
                            {
                                Type = "string",
                            },
                            RoundingMode = "string",
                            Scale = "string",
                            Type = "string",
                        },
                    },
                },
                SchemaUpdateOptions = new[]
                {
                    "string",
                },
                SkipLeadingRows = 0,
                SourceFormat = "string",
                SourceUris = new[]
                {
                    "string",
                },
                TimePartitioning = new GoogleNative.BigQuery.V2.Inputs.TimePartitioningArgs
                {
                    ExpirationMs = "string",
                    Field = "string",
                    RequirePartitionFilter = false,
                    Type = "string",
                },
                UseAvroLogicalTypes = false,
                WriteDisposition = "string",
            },
            Query = new GoogleNative.BigQuery.V2.Inputs.JobConfigurationQueryArgs
            {
                AllowLargeResults = false,
                Clustering = new GoogleNative.BigQuery.V2.Inputs.ClusteringArgs
                {
                    Fields = new[]
                    {
                        "string",
                    },
                },
                ConnectionProperties = new[]
                {
                    new GoogleNative.BigQuery.V2.Inputs.ConnectionPropertyArgs
                    {
                        Key = "string",
                        Value = "string",
                    },
                },
                Continuous = false,
                CreateDisposition = "string",
                CreateSession = false,
                DefaultDataset = new GoogleNative.BigQuery.V2.Inputs.DatasetReferenceArgs
                {
                    DatasetId = "string",
                    Project = "string",
                },
                DestinationEncryptionConfiguration = new GoogleNative.BigQuery.V2.Inputs.EncryptionConfigurationArgs
                {
                    KmsKeyName = "string",
                },
                DestinationTable = new GoogleNative.BigQuery.V2.Inputs.TableReferenceArgs
                {
                    DatasetId = "string",
                    Project = "string",
                    TableId = "string",
                },
                FlattenResults = false,
                MaximumBillingTier = 0,
                MaximumBytesBilled = "string",
                ParameterMode = "string",
                Priority = "string",
                Query = "string",
                QueryParameters = new[]
                {
                    new GoogleNative.BigQuery.V2.Inputs.QueryParameterArgs
                    {
                        Name = "string",
                        ParameterType = new GoogleNative.BigQuery.V2.Inputs.QueryParameterTypeArgs
                        {
                            ArrayType = queryParameterType,
                            StructTypes = new[]
                            {
                                new GoogleNative.BigQuery.V2.Inputs.QueryParameterTypeStructTypesItemArgs
                                {
                                    Description = "string",
                                    Name = "string",
                                    Type = queryParameterType,
                                },
                            },
                            Type = "string",
                        },
                        ParameterValue = new GoogleNative.BigQuery.V2.Inputs.QueryParameterValueArgs
                        {
                            ArrayValues = new[]
                            {
                                queryParameterValue,
                            },
                            StructValues = 
                            {
                                { "string", "string" },
                            },
                            Value = "string",
                        },
                    },
                },
                RangePartitioning = new GoogleNative.BigQuery.V2.Inputs.RangePartitioningArgs
                {
                    Field = "string",
                    Range = new GoogleNative.BigQuery.V2.Inputs.RangePartitioningRangeArgs
                    {
                        End = "string",
                        Interval = "string",
                        Start = "string",
                    },
                },
                SchemaUpdateOptions = new[]
                {
                    "string",
                },
                TableDefinitions = 
                {
                    { "string", "string" },
                },
                TimePartitioning = new GoogleNative.BigQuery.V2.Inputs.TimePartitioningArgs
                {
                    ExpirationMs = "string",
                    Field = "string",
                    RequirePartitionFilter = false,
                    Type = "string",
                },
                UseLegacySql = false,
                UseQueryCache = false,
                UserDefinedFunctionResources = new[]
                {
                    new GoogleNative.BigQuery.V2.Inputs.UserDefinedFunctionResourceArgs
                    {
                        InlineCode = "string",
                        ResourceUri = "string",
                    },
                },
                WriteDisposition = "string",
            },
        },
        JobReference = new GoogleNative.BigQuery.V2.Inputs.JobReferenceArgs
        {
            JobId = "string",
            Location = "string",
            Project = "string",
        },
        Project = "string",
        Source = new StringAsset("content"),
    });
    
    example, err := bigquery.NewJob(ctx, "google-nativeJobResource", &bigquery.JobArgs{
    Configuration: &bigquery.JobConfigurationArgs{
    Copy: &bigquery.JobConfigurationTableCopyArgs{
    CreateDisposition: pulumi.String("string"),
    DestinationEncryptionConfiguration: &bigquery.EncryptionConfigurationArgs{
    KmsKeyName: pulumi.String("string"),
    },
    DestinationExpirationTime: pulumi.Any("any"),
    DestinationTable: &bigquery.TableReferenceArgs{
    DatasetId: pulumi.String("string"),
    Project: pulumi.String("string"),
    TableId: pulumi.String("string"),
    },
    OperationType: pulumi.String("string"),
    SourceTable: &bigquery.TableReferenceArgs{
    DatasetId: pulumi.String("string"),
    Project: pulumi.String("string"),
    TableId: pulumi.String("string"),
    },
    SourceTables: bigquery.TableReferenceArray{
    &bigquery.TableReferenceArgs{
    DatasetId: pulumi.String("string"),
    Project: pulumi.String("string"),
    TableId: pulumi.String("string"),
    },
    },
    WriteDisposition: pulumi.String("string"),
    },
    DryRun: pulumi.Bool(false),
    Extract: &bigquery.JobConfigurationExtractArgs{
    Compression: pulumi.String("string"),
    DestinationFormat: pulumi.String("string"),
    DestinationUri: pulumi.String("string"),
    DestinationUris: pulumi.StringArray{
    pulumi.String("string"),
    },
    FieldDelimiter: pulumi.String("string"),
    PrintHeader: pulumi.Bool(false),
    SourceModel: &bigquery.ModelReferenceArgs{
    DatasetId: pulumi.String("string"),
    ModelId: pulumi.String("string"),
    Project: pulumi.String("string"),
    },
    SourceTable: &bigquery.TableReferenceArgs{
    DatasetId: pulumi.String("string"),
    Project: pulumi.String("string"),
    TableId: pulumi.String("string"),
    },
    UseAvroLogicalTypes: pulumi.Bool(false),
    },
    JobTimeoutMs: pulumi.String("string"),
    Labels: pulumi.StringMap{
    "string": pulumi.String("string"),
    },
    Load: &bigquery.JobConfigurationLoadArgs{
    AllowJaggedRows: pulumi.Bool(false),
    AllowQuotedNewlines: pulumi.Bool(false),
    Autodetect: pulumi.Bool(false),
    Clustering: &bigquery.ClusteringArgs{
    Fields: pulumi.StringArray{
    pulumi.String("string"),
    },
    },
    ConnectionProperties: bigquery.ConnectionPropertyArray{
    &bigquery.ConnectionPropertyArgs{
    Key: pulumi.String("string"),
    Value: pulumi.String("string"),
    },
    },
    CreateDisposition: pulumi.String("string"),
    CreateSession: pulumi.Bool(false),
    DecimalTargetTypes: pulumi.StringArray{
    pulumi.String("string"),
    },
    DestinationEncryptionConfiguration: &bigquery.EncryptionConfigurationArgs{
    KmsKeyName: pulumi.String("string"),
    },
    DestinationTable: &bigquery.TableReferenceArgs{
    DatasetId: pulumi.String("string"),
    Project: pulumi.String("string"),
    TableId: pulumi.String("string"),
    },
    DestinationTableProperties: &bigquery.DestinationTablePropertiesArgs{
    Description: pulumi.String("string"),
    ExpirationTime: pulumi.String("string"),
    FriendlyName: pulumi.String("string"),
    Labels: pulumi.StringMap{
    "string": pulumi.String("string"),
    },
    },
    Encoding: pulumi.String("string"),
    FieldDelimiter: pulumi.String("string"),
    FileSetSpecType: pulumi.String("string"),
    HivePartitioningOptions: &bigquery.HivePartitioningOptionsArgs{
    Mode: pulumi.String("string"),
    RequirePartitionFilter: pulumi.Bool(false),
    SourceUriPrefix: pulumi.String("string"),
    },
    IgnoreUnknownValues: pulumi.Bool(false),
    JsonExtension: pulumi.String("string"),
    MaxBadRecords: pulumi.Int(0),
    NullMarker: pulumi.String("string"),
    ParquetOptions: &bigquery.ParquetOptionsArgs{
    EnableListInference: pulumi.Bool(false),
    EnumAsString: pulumi.Bool(false),
    },
    PreserveAsciiControlCharacters: pulumi.Bool(false),
    ProjectionFields: pulumi.StringArray{
    pulumi.String("string"),
    },
    Quote: pulumi.String("string"),
    RangePartitioning: &bigquery.RangePartitioningArgs{
    Field: pulumi.String("string"),
    Range: &bigquery.RangePartitioningRangeArgs{
    End: pulumi.String("string"),
    Interval: pulumi.String("string"),
    Start: pulumi.String("string"),
    },
    },
    ReferenceFileSchemaUri: pulumi.String("string"),
    Schema: &bigquery.TableSchemaArgs{
    Fields: []bigquery.TableFieldSchemaArgs{
    {
    Categories: {
    Names: pulumi.StringArray{
    pulumi.String("string"),
    },
    },
    Collation: pulumi.String("string"),
    DefaultValueExpression: pulumi.String("string"),
    Description: pulumi.String("string"),
    Fields: bigquery.TableFieldSchemaArray{
    tableFieldSchema,
    },
    MaxLength: pulumi.String("string"),
    Mode: pulumi.String("string"),
    Name: pulumi.String("string"),
    PolicyTags: {
    Names: pulumi.StringArray{
    pulumi.String("string"),
    },
    },
    Precision: pulumi.String("string"),
    RangeElementType: {
    Type: pulumi.String("string"),
    },
    RoundingMode: pulumi.String("string"),
    Scale: pulumi.String("string"),
    Type: pulumi.String("string"),
    },
    },
    },
    SchemaUpdateOptions: pulumi.StringArray{
    pulumi.String("string"),
    },
    SkipLeadingRows: pulumi.Int(0),
    SourceFormat: pulumi.String("string"),
    SourceUris: pulumi.StringArray{
    pulumi.String("string"),
    },
    TimePartitioning: &bigquery.TimePartitioningArgs{
    ExpirationMs: pulumi.String("string"),
    Field: pulumi.String("string"),
    RequirePartitionFilter: pulumi.Bool(false),
    Type: pulumi.String("string"),
    },
    UseAvroLogicalTypes: pulumi.Bool(false),
    WriteDisposition: pulumi.String("string"),
    },
    Query: &bigquery.JobConfigurationQueryArgs{
    AllowLargeResults: pulumi.Bool(false),
    Clustering: &bigquery.ClusteringArgs{
    Fields: pulumi.StringArray{
    pulumi.String("string"),
    },
    },
    ConnectionProperties: bigquery.ConnectionPropertyArray{
    &bigquery.ConnectionPropertyArgs{
    Key: pulumi.String("string"),
    Value: pulumi.String("string"),
    },
    },
    Continuous: pulumi.Bool(false),
    CreateDisposition: pulumi.String("string"),
    CreateSession: pulumi.Bool(false),
    DefaultDataset: &bigquery.DatasetReferenceArgs{
    DatasetId: pulumi.String("string"),
    Project: pulumi.String("string"),
    },
    DestinationEncryptionConfiguration: &bigquery.EncryptionConfigurationArgs{
    KmsKeyName: pulumi.String("string"),
    },
    DestinationTable: &bigquery.TableReferenceArgs{
    DatasetId: pulumi.String("string"),
    Project: pulumi.String("string"),
    TableId: pulumi.String("string"),
    },
    FlattenResults: pulumi.Bool(false),
    MaximumBillingTier: pulumi.Int(0),
    MaximumBytesBilled: pulumi.String("string"),
    ParameterMode: pulumi.String("string"),
    Priority: pulumi.String("string"),
    Query: pulumi.String("string"),
    QueryParameters: []bigquery.QueryParameterArgs{
    {
    Name: pulumi.String("string"),
    ParameterType: {
    ArrayType: pulumi.Any(queryParameterType),
    StructTypes: []bigquery.QueryParameterTypeStructTypesItemArgs{
    {
    Description: pulumi.String("string"),
    Name: pulumi.String("string"),
    Type: pulumi.Any(queryParameterType),
    },
    },
    Type: pulumi.String("string"),
    },
    ParameterValue: {
    ArrayValues: bigquery.QueryParameterValueArray{
    queryParameterValue,
    },
    StructValues: {
    "string": pulumi.String("string"),
    },
    Value: pulumi.String("string"),
    },
    },
    },
    RangePartitioning: &bigquery.RangePartitioningArgs{
    Field: pulumi.String("string"),
    Range: &bigquery.RangePartitioningRangeArgs{
    End: pulumi.String("string"),
    Interval: pulumi.String("string"),
    Start: pulumi.String("string"),
    },
    },
    SchemaUpdateOptions: pulumi.StringArray{
    pulumi.String("string"),
    },
    TableDefinitions: pulumi.StringMap{
    "string": pulumi.String("string"),
    },
    TimePartitioning: &bigquery.TimePartitioningArgs{
    ExpirationMs: pulumi.String("string"),
    Field: pulumi.String("string"),
    RequirePartitionFilter: pulumi.Bool(false),
    Type: pulumi.String("string"),
    },
    UseLegacySql: pulumi.Bool(false),
    UseQueryCache: pulumi.Bool(false),
    UserDefinedFunctionResources: bigquery.UserDefinedFunctionResourceArray{
    &bigquery.UserDefinedFunctionResourceArgs{
    InlineCode: pulumi.String("string"),
    ResourceUri: pulumi.String("string"),
    },
    },
    WriteDisposition: pulumi.String("string"),
    },
    },
    JobReference: &bigquery.JobReferenceArgs{
    JobId: pulumi.String("string"),
    Location: pulumi.String("string"),
    Project: pulumi.String("string"),
    },
    Project: pulumi.String("string"),
    Source: pulumi.NewStringAsset("content"),
    })
    
    var google_nativeJobResource = new Job("google-nativeJobResource", JobArgs.builder()
        .configuration(JobConfigurationArgs.builder()
            .copy(JobConfigurationTableCopyArgs.builder()
                .createDisposition("string")
                .destinationEncryptionConfiguration(EncryptionConfigurationArgs.builder()
                    .kmsKeyName("string")
                    .build())
                .destinationExpirationTime("any")
                .destinationTable(TableReferenceArgs.builder()
                    .datasetId("string")
                    .project("string")
                    .tableId("string")
                    .build())
                .operationType("string")
                .sourceTable(TableReferenceArgs.builder()
                    .datasetId("string")
                    .project("string")
                    .tableId("string")
                    .build())
                .sourceTables(TableReferenceArgs.builder()
                    .datasetId("string")
                    .project("string")
                    .tableId("string")
                    .build())
                .writeDisposition("string")
                .build())
            .dryRun(false)
            .extract(JobConfigurationExtractArgs.builder()
                .compression("string")
                .destinationFormat("string")
                .destinationUri("string")
                .destinationUris("string")
                .fieldDelimiter("string")
                .printHeader(false)
                .sourceModel(ModelReferenceArgs.builder()
                    .datasetId("string")
                    .modelId("string")
                    .project("string")
                    .build())
                .sourceTable(TableReferenceArgs.builder()
                    .datasetId("string")
                    .project("string")
                    .tableId("string")
                    .build())
                .useAvroLogicalTypes(false)
                .build())
            .jobTimeoutMs("string")
            .labels(Map.of("string", "string"))
            .load(JobConfigurationLoadArgs.builder()
                .allowJaggedRows(false)
                .allowQuotedNewlines(false)
                .autodetect(false)
                .clustering(ClusteringArgs.builder()
                    .fields("string")
                    .build())
                .connectionProperties(ConnectionPropertyArgs.builder()
                    .key("string")
                    .value("string")
                    .build())
                .createDisposition("string")
                .createSession(false)
                .decimalTargetTypes("string")
                .destinationEncryptionConfiguration(EncryptionConfigurationArgs.builder()
                    .kmsKeyName("string")
                    .build())
                .destinationTable(TableReferenceArgs.builder()
                    .datasetId("string")
                    .project("string")
                    .tableId("string")
                    .build())
                .destinationTableProperties(DestinationTablePropertiesArgs.builder()
                    .description("string")
                    .expirationTime("string")
                    .friendlyName("string")
                    .labels(Map.of("string", "string"))
                    .build())
                .encoding("string")
                .fieldDelimiter("string")
                .fileSetSpecType("string")
                .hivePartitioningOptions(HivePartitioningOptionsArgs.builder()
                    .mode("string")
                    .requirePartitionFilter(false)
                    .sourceUriPrefix("string")
                    .build())
                .ignoreUnknownValues(false)
                .jsonExtension("string")
                .maxBadRecords(0)
                .nullMarker("string")
                .parquetOptions(ParquetOptionsArgs.builder()
                    .enableListInference(false)
                    .enumAsString(false)
                    .build())
                .preserveAsciiControlCharacters(false)
                .projectionFields("string")
                .quote("string")
                .rangePartitioning(RangePartitioningArgs.builder()
                    .field("string")
                    .range(RangePartitioningRangeArgs.builder()
                        .end("string")
                        .interval("string")
                        .start("string")
                        .build())
                    .build())
                .referenceFileSchemaUri("string")
                .schema(TableSchemaArgs.builder()
                    .fields(TableFieldSchemaArgs.builder()
                        .categories(TableFieldSchemaCategoriesArgs.builder()
                            .names("string")
                            .build())
                        .collation("string")
                        .defaultValueExpression("string")
                        .description("string")
                        .fields(tableFieldSchema)
                        .maxLength("string")
                        .mode("string")
                        .name("string")
                        .policyTags(TableFieldSchemaPolicyTagsArgs.builder()
                            .names("string")
                            .build())
                        .precision("string")
                        .rangeElementType(TableFieldSchemaRangeElementTypeArgs.builder()
                            .type("string")
                            .build())
                        .roundingMode("string")
                        .scale("string")
                        .type("string")
                        .build())
                    .build())
                .schemaUpdateOptions("string")
                .skipLeadingRows(0)
                .sourceFormat("string")
                .sourceUris("string")
                .timePartitioning(TimePartitioningArgs.builder()
                    .expirationMs("string")
                    .field("string")
                    .requirePartitionFilter(false)
                    .type("string")
                    .build())
                .useAvroLogicalTypes(false)
                .writeDisposition("string")
                .build())
            .query(JobConfigurationQueryArgs.builder()
                .allowLargeResults(false)
                .clustering(ClusteringArgs.builder()
                    .fields("string")
                    .build())
                .connectionProperties(ConnectionPropertyArgs.builder()
                    .key("string")
                    .value("string")
                    .build())
                .continuous(false)
                .createDisposition("string")
                .createSession(false)
                .defaultDataset(DatasetReferenceArgs.builder()
                    .datasetId("string")
                    .project("string")
                    .build())
                .destinationEncryptionConfiguration(EncryptionConfigurationArgs.builder()
                    .kmsKeyName("string")
                    .build())
                .destinationTable(TableReferenceArgs.builder()
                    .datasetId("string")
                    .project("string")
                    .tableId("string")
                    .build())
                .flattenResults(false)
                .maximumBillingTier(0)
                .maximumBytesBilled("string")
                .parameterMode("string")
                .priority("string")
                .query("string")
                .queryParameters(QueryParameterArgs.builder()
                    .name("string")
                    .parameterType(QueryParameterTypeArgs.builder()
                        .arrayType(queryParameterType)
                        .structTypes(QueryParameterTypeStructTypesItemArgs.builder()
                            .description("string")
                            .name("string")
                            .type(queryParameterType)
                            .build())
                        .type("string")
                        .build())
                    .parameterValue(QueryParameterValueArgs.builder()
                        .arrayValues(queryParameterValue)
                        .structValues(Map.of("string", "string"))
                        .value("string")
                        .build())
                    .build())
                .rangePartitioning(RangePartitioningArgs.builder()
                    .field("string")
                    .range(RangePartitioningRangeArgs.builder()
                        .end("string")
                        .interval("string")
                        .start("string")
                        .build())
                    .build())
                .schemaUpdateOptions("string")
                .tableDefinitions(Map.of("string", "string"))
                .timePartitioning(TimePartitioningArgs.builder()
                    .expirationMs("string")
                    .field("string")
                    .requirePartitionFilter(false)
                    .type("string")
                    .build())
                .useLegacySql(false)
                .useQueryCache(false)
                .userDefinedFunctionResources(UserDefinedFunctionResourceArgs.builder()
                    .inlineCode("string")
                    .resourceUri("string")
                    .build())
                .writeDisposition("string")
                .build())
            .build())
        .jobReference(JobReferenceArgs.builder()
            .jobId("string")
            .location("string")
            .project("string")
            .build())
        .project("string")
        .source(new StringAsset("content"))
        .build());
    
    google_native_job_resource = google_native.bigquery.v2.Job("google-nativeJobResource",
        configuration=google_native.bigquery.v2.JobConfigurationArgs(
            copy=google_native.bigquery.v2.JobConfigurationTableCopyArgs(
                create_disposition="string",
                destination_encryption_configuration=google_native.bigquery.v2.EncryptionConfigurationArgs(
                    kms_key_name="string",
                ),
                destination_expiration_time="any",
                destination_table=google_native.bigquery.v2.TableReferenceArgs(
                    dataset_id="string",
                    project="string",
                    table_id="string",
                ),
                operation_type="string",
                source_table=google_native.bigquery.v2.TableReferenceArgs(
                    dataset_id="string",
                    project="string",
                    table_id="string",
                ),
                source_tables=[google_native.bigquery.v2.TableReferenceArgs(
                    dataset_id="string",
                    project="string",
                    table_id="string",
                )],
                write_disposition="string",
            ),
            dry_run=False,
            extract=google_native.bigquery.v2.JobConfigurationExtractArgs(
                compression="string",
                destination_format="string",
                destination_uri="string",
                destination_uris=["string"],
                field_delimiter="string",
                print_header=False,
                source_model=google_native.bigquery.v2.ModelReferenceArgs(
                    dataset_id="string",
                    model_id="string",
                    project="string",
                ),
                source_table=google_native.bigquery.v2.TableReferenceArgs(
                    dataset_id="string",
                    project="string",
                    table_id="string",
                ),
                use_avro_logical_types=False,
            ),
            job_timeout_ms="string",
            labels={
                "string": "string",
            },
            load=google_native.bigquery.v2.JobConfigurationLoadArgs(
                allow_jagged_rows=False,
                allow_quoted_newlines=False,
                autodetect=False,
                clustering=google_native.bigquery.v2.ClusteringArgs(
                    fields=["string"],
                ),
                connection_properties=[google_native.bigquery.v2.ConnectionPropertyArgs(
                    key="string",
                    value="string",
                )],
                create_disposition="string",
                create_session=False,
                decimal_target_types=["string"],
                destination_encryption_configuration=google_native.bigquery.v2.EncryptionConfigurationArgs(
                    kms_key_name="string",
                ),
                destination_table=google_native.bigquery.v2.TableReferenceArgs(
                    dataset_id="string",
                    project="string",
                    table_id="string",
                ),
                destination_table_properties=google_native.bigquery.v2.DestinationTablePropertiesArgs(
                    description="string",
                    expiration_time="string",
                    friendly_name="string",
                    labels={
                        "string": "string",
                    },
                ),
                encoding="string",
                field_delimiter="string",
                file_set_spec_type="string",
                hive_partitioning_options=google_native.bigquery.v2.HivePartitioningOptionsArgs(
                    mode="string",
                    require_partition_filter=False,
                    source_uri_prefix="string",
                ),
                ignore_unknown_values=False,
                json_extension="string",
                max_bad_records=0,
                null_marker="string",
                parquet_options=google_native.bigquery.v2.ParquetOptionsArgs(
                    enable_list_inference=False,
                    enum_as_string=False,
                ),
                preserve_ascii_control_characters=False,
                projection_fields=["string"],
                quote="string",
                range_partitioning=google_native.bigquery.v2.RangePartitioningArgs(
                    field="string",
                    range=google_native.bigquery.v2.RangePartitioningRangeArgs(
                        end="string",
                        interval="string",
                        start="string",
                    ),
                ),
                reference_file_schema_uri="string",
                schema=google_native.bigquery.v2.TableSchemaArgs(
                    fields=[google_native.bigquery.v2.TableFieldSchemaArgs(
                        categories=google_native.bigquery.v2.TableFieldSchemaCategoriesArgs(
                            names=["string"],
                        ),
                        collation="string",
                        default_value_expression="string",
                        description="string",
                        fields=[table_field_schema],
                        max_length="string",
                        mode="string",
                        name="string",
                        policy_tags=google_native.bigquery.v2.TableFieldSchemaPolicyTagsArgs(
                            names=["string"],
                        ),
                        precision="string",
                        range_element_type=google_native.bigquery.v2.TableFieldSchemaRangeElementTypeArgs(
                            type="string",
                        ),
                        rounding_mode="string",
                        scale="string",
                        type="string",
                    )],
                ),
                schema_update_options=["string"],
                skip_leading_rows=0,
                source_format="string",
                source_uris=["string"],
                time_partitioning=google_native.bigquery.v2.TimePartitioningArgs(
                    expiration_ms="string",
                    field="string",
                    require_partition_filter=False,
                    type="string",
                ),
                use_avro_logical_types=False,
                write_disposition="string",
            ),
            query=google_native.bigquery.v2.JobConfigurationQueryArgs(
                allow_large_results=False,
                clustering=google_native.bigquery.v2.ClusteringArgs(
                    fields=["string"],
                ),
                connection_properties=[google_native.bigquery.v2.ConnectionPropertyArgs(
                    key="string",
                    value="string",
                )],
                continuous=False,
                create_disposition="string",
                create_session=False,
                default_dataset=google_native.bigquery.v2.DatasetReferenceArgs(
                    dataset_id="string",
                    project="string",
                ),
                destination_encryption_configuration=google_native.bigquery.v2.EncryptionConfigurationArgs(
                    kms_key_name="string",
                ),
                destination_table=google_native.bigquery.v2.TableReferenceArgs(
                    dataset_id="string",
                    project="string",
                    table_id="string",
                ),
                flatten_results=False,
                maximum_billing_tier=0,
                maximum_bytes_billed="string",
                parameter_mode="string",
                priority="string",
                query="string",
                query_parameters=[google_native.bigquery.v2.QueryParameterArgs(
                    name="string",
                    parameter_type=google_native.bigquery.v2.QueryParameterTypeArgs(
                        array_type=query_parameter_type,
                        struct_types=[google_native.bigquery.v2.QueryParameterTypeStructTypesItemArgs(
                            description="string",
                            name="string",
                            type=query_parameter_type,
                        )],
                        type="string",
                    ),
                    parameter_value=google_native.bigquery.v2.QueryParameterValueArgs(
                        array_values=[query_parameter_value],
                        struct_values={
                            "string": "string",
                        },
                        value="string",
                    ),
                )],
                range_partitioning=google_native.bigquery.v2.RangePartitioningArgs(
                    field="string",
                    range=google_native.bigquery.v2.RangePartitioningRangeArgs(
                        end="string",
                        interval="string",
                        start="string",
                    ),
                ),
                schema_update_options=["string"],
                table_definitions={
                    "string": "string",
                },
                time_partitioning=google_native.bigquery.v2.TimePartitioningArgs(
                    expiration_ms="string",
                    field="string",
                    require_partition_filter=False,
                    type="string",
                ),
                use_legacy_sql=False,
                use_query_cache=False,
                user_defined_function_resources=[google_native.bigquery.v2.UserDefinedFunctionResourceArgs(
                    inline_code="string",
                    resource_uri="string",
                )],
                write_disposition="string",
            ),
        ),
        job_reference=google_native.bigquery.v2.JobReferenceArgs(
            job_id="string",
            location="string",
            project="string",
        ),
        project="string",
        source=pulumi.StringAsset("content"))
    
    const google_nativeJobResource = new google_native.bigquery.v2.Job("google-nativeJobResource", {
        configuration: {
            copy: {
                createDisposition: "string",
                destinationEncryptionConfiguration: {
                    kmsKeyName: "string",
                },
                destinationExpirationTime: "any",
                destinationTable: {
                    datasetId: "string",
                    project: "string",
                    tableId: "string",
                },
                operationType: "string",
                sourceTable: {
                    datasetId: "string",
                    project: "string",
                    tableId: "string",
                },
                sourceTables: [{
                    datasetId: "string",
                    project: "string",
                    tableId: "string",
                }],
                writeDisposition: "string",
            },
            dryRun: false,
            extract: {
                compression: "string",
                destinationFormat: "string",
                destinationUri: "string",
                destinationUris: ["string"],
                fieldDelimiter: "string",
                printHeader: false,
                sourceModel: {
                    datasetId: "string",
                    modelId: "string",
                    project: "string",
                },
                sourceTable: {
                    datasetId: "string",
                    project: "string",
                    tableId: "string",
                },
                useAvroLogicalTypes: false,
            },
            jobTimeoutMs: "string",
            labels: {
                string: "string",
            },
            load: {
                allowJaggedRows: false,
                allowQuotedNewlines: false,
                autodetect: false,
                clustering: {
                    fields: ["string"],
                },
                connectionProperties: [{
                    key: "string",
                    value: "string",
                }],
                createDisposition: "string",
                createSession: false,
                decimalTargetTypes: ["string"],
                destinationEncryptionConfiguration: {
                    kmsKeyName: "string",
                },
                destinationTable: {
                    datasetId: "string",
                    project: "string",
                    tableId: "string",
                },
                destinationTableProperties: {
                    description: "string",
                    expirationTime: "string",
                    friendlyName: "string",
                    labels: {
                        string: "string",
                    },
                },
                encoding: "string",
                fieldDelimiter: "string",
                fileSetSpecType: "string",
                hivePartitioningOptions: {
                    mode: "string",
                    requirePartitionFilter: false,
                    sourceUriPrefix: "string",
                },
                ignoreUnknownValues: false,
                jsonExtension: "string",
                maxBadRecords: 0,
                nullMarker: "string",
                parquetOptions: {
                    enableListInference: false,
                    enumAsString: false,
                },
                preserveAsciiControlCharacters: false,
                projectionFields: ["string"],
                quote: "string",
                rangePartitioning: {
                    field: "string",
                    range: {
                        end: "string",
                        interval: "string",
                        start: "string",
                    },
                },
                referenceFileSchemaUri: "string",
                schema: {
                    fields: [{
                        categories: {
                            names: ["string"],
                        },
                        collation: "string",
                        defaultValueExpression: "string",
                        description: "string",
                        fields: [tableFieldSchema],
                        maxLength: "string",
                        mode: "string",
                        name: "string",
                        policyTags: {
                            names: ["string"],
                        },
                        precision: "string",
                        rangeElementType: {
                            type: "string",
                        },
                        roundingMode: "string",
                        scale: "string",
                        type: "string",
                    }],
                },
                schemaUpdateOptions: ["string"],
                skipLeadingRows: 0,
                sourceFormat: "string",
                sourceUris: ["string"],
                timePartitioning: {
                    expirationMs: "string",
                    field: "string",
                    requirePartitionFilter: false,
                    type: "string",
                },
                useAvroLogicalTypes: false,
                writeDisposition: "string",
            },
            query: {
                allowLargeResults: false,
                clustering: {
                    fields: ["string"],
                },
                connectionProperties: [{
                    key: "string",
                    value: "string",
                }],
                continuous: false,
                createDisposition: "string",
                createSession: false,
                defaultDataset: {
                    datasetId: "string",
                    project: "string",
                },
                destinationEncryptionConfiguration: {
                    kmsKeyName: "string",
                },
                destinationTable: {
                    datasetId: "string",
                    project: "string",
                    tableId: "string",
                },
                flattenResults: false,
                maximumBillingTier: 0,
                maximumBytesBilled: "string",
                parameterMode: "string",
                priority: "string",
                query: "string",
                queryParameters: [{
                    name: "string",
                    parameterType: {
                        arrayType: queryParameterType,
                        structTypes: [{
                            description: "string",
                            name: "string",
                            type: queryParameterType,
                        }],
                        type: "string",
                    },
                    parameterValue: {
                        arrayValues: [queryParameterValue],
                        structValues: {
                            string: "string",
                        },
                        value: "string",
                    },
                }],
                rangePartitioning: {
                    field: "string",
                    range: {
                        end: "string",
                        interval: "string",
                        start: "string",
                    },
                },
                schemaUpdateOptions: ["string"],
                tableDefinitions: {
                    string: "string",
                },
                timePartitioning: {
                    expirationMs: "string",
                    field: "string",
                    requirePartitionFilter: false,
                    type: "string",
                },
                useLegacySql: false,
                useQueryCache: false,
                userDefinedFunctionResources: [{
                    inlineCode: "string",
                    resourceUri: "string",
                }],
                writeDisposition: "string",
            },
        },
        jobReference: {
            jobId: "string",
            location: "string",
            project: "string",
        },
        project: "string",
        source: new pulumi.asset.StringAsset("content"),
    });
    
    type: google-native:bigquery/v2:Job
    properties:
        configuration:
            copy:
                createDisposition: string
                destinationEncryptionConfiguration:
                    kmsKeyName: string
                destinationExpirationTime: any
                destinationTable:
                    datasetId: string
                    project: string
                    tableId: string
                operationType: string
                sourceTable:
                    datasetId: string
                    project: string
                    tableId: string
                sourceTables:
                    - datasetId: string
                      project: string
                      tableId: string
                writeDisposition: string
            dryRun: false
            extract:
                compression: string
                destinationFormat: string
                destinationUri: string
                destinationUris:
                    - string
                fieldDelimiter: string
                printHeader: false
                sourceModel:
                    datasetId: string
                    modelId: string
                    project: string
                sourceTable:
                    datasetId: string
                    project: string
                    tableId: string
                useAvroLogicalTypes: false
            jobTimeoutMs: string
            labels:
                string: string
            load:
                allowJaggedRows: false
                allowQuotedNewlines: false
                autodetect: false
                clustering:
                    fields:
                        - string
                connectionProperties:
                    - key: string
                      value: string
                createDisposition: string
                createSession: false
                decimalTargetTypes:
                    - string
                destinationEncryptionConfiguration:
                    kmsKeyName: string
                destinationTable:
                    datasetId: string
                    project: string
                    tableId: string
                destinationTableProperties:
                    description: string
                    expirationTime: string
                    friendlyName: string
                    labels:
                        string: string
                encoding: string
                fieldDelimiter: string
                fileSetSpecType: string
                hivePartitioningOptions:
                    mode: string
                    requirePartitionFilter: false
                    sourceUriPrefix: string
                ignoreUnknownValues: false
                jsonExtension: string
                maxBadRecords: 0
                nullMarker: string
                parquetOptions:
                    enableListInference: false
                    enumAsString: false
                preserveAsciiControlCharacters: false
                projectionFields:
                    - string
                quote: string
                rangePartitioning:
                    field: string
                    range:
                        end: string
                        interval: string
                        start: string
                referenceFileSchemaUri: string
                schema:
                    fields:
                        - categories:
                            names:
                                - string
                          collation: string
                          defaultValueExpression: string
                          description: string
                          fields:
                            - ${tableFieldSchema}
                          maxLength: string
                          mode: string
                          name: string
                          policyTags:
                            names:
                                - string
                          precision: string
                          rangeElementType:
                            type: string
                          roundingMode: string
                          scale: string
                          type: string
                schemaUpdateOptions:
                    - string
                skipLeadingRows: 0
                sourceFormat: string
                sourceUris:
                    - string
                timePartitioning:
                    expirationMs: string
                    field: string
                    requirePartitionFilter: false
                    type: string
                useAvroLogicalTypes: false
                writeDisposition: string
            query:
                allowLargeResults: false
                clustering:
                    fields:
                        - string
                connectionProperties:
                    - key: string
                      value: string
                continuous: false
                createDisposition: string
                createSession: false
                defaultDataset:
                    datasetId: string
                    project: string
                destinationEncryptionConfiguration:
                    kmsKeyName: string
                destinationTable:
                    datasetId: string
                    project: string
                    tableId: string
                flattenResults: false
                maximumBillingTier: 0
                maximumBytesBilled: string
                parameterMode: string
                priority: string
                query: string
                queryParameters:
                    - name: string
                      parameterType:
                        arrayType: ${queryParameterType}
                        structTypes:
                            - description: string
                              name: string
                              type: ${queryParameterType}
                        type: string
                      parameterValue:
                        arrayValues:
                            - ${queryParameterValue}
                        structValues:
                            string: string
                        value: string
                rangePartitioning:
                    field: string
                    range:
                        end: string
                        interval: string
                        start: string
                schemaUpdateOptions:
                    - string
                tableDefinitions:
                    string: string
                timePartitioning:
                    expirationMs: string
                    field: string
                    requirePartitionFilter: false
                    type: string
                useLegacySql: false
                useQueryCache: false
                userDefinedFunctionResources:
                    - inlineCode: string
                      resourceUri: string
                writeDisposition: string
        jobReference:
            jobId: string
            location: string
            project: string
        project: string
        source:
            fn::StringAsset: content
    

    Job Resource Properties

    To learn more about resource properties and how to use them, see Inputs and Outputs in the Architecture and Concepts docs.

    Inputs

    The Job resource accepts the following input properties:

    Configuration Pulumi.GoogleNative.BigQuery.V2.Inputs.JobConfiguration
    [Required] Describes the job configuration.
    JobReference Pulumi.GoogleNative.BigQuery.V2.Inputs.JobReference
    [Optional] Reference describing the unique-per-user name of the job.
    Project string
    Source AssetOrArchive
    Configuration JobConfigurationArgs
    [Required] Describes the job configuration.
    JobReference JobReferenceArgs
    [Optional] Reference describing the unique-per-user name of the job.
    Project string
    Source pulumi.AssetOrArchive
    configuration JobConfiguration
    [Required] Describes the job configuration.
    jobReference JobReference
    [Optional] Reference describing the unique-per-user name of the job.
    project String
    source AssetOrArchive
    configuration JobConfiguration
    [Required] Describes the job configuration.
    jobReference JobReference
    [Optional] Reference describing the unique-per-user name of the job.
    project string
    source pulumi.asset.Asset | pulumi.asset.Archive
    configuration JobConfigurationArgs
    [Required] Describes the job configuration.
    job_reference JobReferenceArgs
    [Optional] Reference describing the unique-per-user name of the job.
    project str
    source Union[pulumi.Asset, pulumi.Archive]
    configuration Property Map
    [Required] Describes the job configuration.
    jobReference Property Map
    [Optional] Reference describing the unique-per-user name of the job.
    project String
    source Asset

    Outputs

    All input properties are implicitly available as output properties. Additionally, the Job resource produces the following output properties:

    Etag string
    A hash of this resource.
    Id string
    The provider-assigned unique ID for this managed resource.
    JobCreationReason object
    If set, it provides the reason why a Job was created. If not set, it should be treated as the default: REQUESTED. This feature is not yet available. Jobs will always be created.
    Kind string
    The type of the resource.
    SelfLink string
    A URL that can be used to access this resource again.
    Statistics Pulumi.GoogleNative.BigQuery.V2.Outputs.JobStatisticsResponse
    Information about the job, including starting time and ending time of the job.
    Status Pulumi.GoogleNative.BigQuery.V2.Outputs.JobStatusResponse
    The status of this job. Examine this value when polling an asynchronous job to see if the job is complete.
    UserEmail string
    Email address of the user who ran the job.
    Etag string
    A hash of this resource.
    Id string
    The provider-assigned unique ID for this managed resource.
    JobCreationReason interface{}
    If set, it provides the reason why a Job was created. If not set, it should be treated as the default: REQUESTED. This feature is not yet available. Jobs will always be created.
    Kind string
    The type of the resource.
    SelfLink string
    A URL that can be used to access this resource again.
    Statistics JobStatisticsResponse
    Information about the job, including starting time and ending time of the job.
    Status JobStatusResponse
    The status of this job. Examine this value when polling an asynchronous job to see if the job is complete.
    UserEmail string
    Email address of the user who ran the job.
    etag String
    A hash of this resource.
    id String
    The provider-assigned unique ID for this managed resource.
    jobCreationReason Object
    If set, it provides the reason why a Job was created. If not set, it should be treated as the default: REQUESTED. This feature is not yet available. Jobs will always be created.
    kind String
    The type of the resource.
    selfLink String
    A URL that can be used to access this resource again.
    statistics JobStatisticsResponse
    Information about the job, including starting time and ending time of the job.
    status JobStatusResponse
    The status of this job. Examine this value when polling an asynchronous job to see if the job is complete.
    userEmail String
    Email address of the user who ran the job.
    etag string
    A hash of this resource.
    id string
    The provider-assigned unique ID for this managed resource.
    jobCreationReason any
    If set, it provides the reason why a Job was created. If not set, it should be treated as the default: REQUESTED. This feature is not yet available. Jobs will always be created.
    kind string
    The type of the resource.
    selfLink string
    A URL that can be used to access this resource again.
    statistics JobStatisticsResponse
    Information about the job, including starting time and ending time of the job.
    status JobStatusResponse
    The status of this job. Examine this value when polling an asynchronous job to see if the job is complete.
    userEmail string
    Email address of the user who ran the job.
    etag str
    A hash of this resource.
    id str
    The provider-assigned unique ID for this managed resource.
    job_creation_reason Any
    If set, it provides the reason why a Job was created. If not set, it should be treated as the default: REQUESTED. This feature is not yet available. Jobs will always be created.
    kind str
    The type of the resource.
    self_link str
    A URL that can be used to access this resource again.
    statistics JobStatisticsResponse
    Information about the job, including starting time and ending time of the job.
    status JobStatusResponse
    The status of this job. Examine this value when polling an asynchronous job to see if the job is complete.
    user_email str
    Email address of the user who ran the job.
    etag String
    A hash of this resource.
    id String
    The provider-assigned unique ID for this managed resource.
    jobCreationReason Any
    If set, it provides the reason why a Job was created. If not set, it should be treated as the default: REQUESTED. This feature is not yet available. Jobs will always be created.
    kind String
    The type of the resource.
    selfLink String
    A URL that can be used to access this resource again.
    statistics Property Map
    Information about the job, including starting time and ending time of the job.
    status Property Map
    The status of this job. Examine this value when polling an asynchronous job to see if the job is complete.
    userEmail String
    Email address of the user who ran the job.

    Supporting Types

    BiEngineReasonResponse, BiEngineReasonResponseArgs

    Code string
    High-level BI Engine reason for partial or disabled acceleration.
    Message string
    Free form human-readable reason for partial or disabled acceleration.
    Code string
    High-level BI Engine reason for partial or disabled acceleration.
    Message string
    Free form human-readable reason for partial or disabled acceleration.
    code String
    High-level BI Engine reason for partial or disabled acceleration.
    message String
    Free form human-readable reason for partial or disabled acceleration.
    code string
    High-level BI Engine reason for partial or disabled acceleration.
    message string
    Free form human-readable reason for partial or disabled acceleration.
    code str
    High-level BI Engine reason for partial or disabled acceleration.
    message str
    Free form human-readable reason for partial or disabled acceleration.
    code String
    High-level BI Engine reason for partial or disabled acceleration.
    message String
    Free form human-readable reason for partial or disabled acceleration.

    BiEngineStatisticsResponse, BiEngineStatisticsResponseArgs

    AccelerationMode string
    Specifies which mode of BI Engine acceleration was performed (if any).
    BiEngineMode string
    Specifies which mode of BI Engine acceleration was performed (if any).
    BiEngineReasons List<Pulumi.GoogleNative.BigQuery.V2.Inputs.BiEngineReasonResponse>
    In case of DISABLED or PARTIAL bi_engine_mode, these contain the explanatory reasons as to why BI Engine could not accelerate. In case the full query was accelerated, this field is not populated.
    AccelerationMode string
    Specifies which mode of BI Engine acceleration was performed (if any).
    BiEngineMode string
    Specifies which mode of BI Engine acceleration was performed (if any).
    BiEngineReasons []BiEngineReasonResponse
    In case of DISABLED or PARTIAL bi_engine_mode, these contain the explanatory reasons as to why BI Engine could not accelerate. In case the full query was accelerated, this field is not populated.
    accelerationMode String
    Specifies which mode of BI Engine acceleration was performed (if any).
    biEngineMode String
    Specifies which mode of BI Engine acceleration was performed (if any).
    biEngineReasons List<BiEngineReasonResponse>
    In case of DISABLED or PARTIAL bi_engine_mode, these contain the explanatory reasons as to why BI Engine could not accelerate. In case the full query was accelerated, this field is not populated.
    accelerationMode string
    Specifies which mode of BI Engine acceleration was performed (if any).
    biEngineMode string
    Specifies which mode of BI Engine acceleration was performed (if any).
    biEngineReasons BiEngineReasonResponse[]
    In case of DISABLED or PARTIAL bi_engine_mode, these contain the explanatory reasons as to why BI Engine could not accelerate. In case the full query was accelerated, this field is not populated.
    acceleration_mode str
    Specifies which mode of BI Engine acceleration was performed (if any).
    bi_engine_mode str
    Specifies which mode of BI Engine acceleration was performed (if any).
    bi_engine_reasons Sequence[BiEngineReasonResponse]
    In case of DISABLED or PARTIAL bi_engine_mode, these contain the explanatory reasons as to why BI Engine could not accelerate. In case the full query was accelerated, this field is not populated.
    accelerationMode String
    Specifies which mode of BI Engine acceleration was performed (if any).
    biEngineMode String
    Specifies which mode of BI Engine acceleration was performed (if any).
    biEngineReasons List<Property Map>
    In case of DISABLED or PARTIAL bi_engine_mode, these contain the explanatory reasons as to why BI Engine could not accelerate. In case the full query was accelerated, this field is not populated.

    BigQueryModelTrainingResponse, BigQueryModelTrainingResponseArgs

    CurrentIteration int
    [Output-only, Beta] Index of current ML training iteration. Updated during create model query job to show job progress.
    ExpectedTotalIterations string
    [Output-only, Beta] Expected number of iterations for the create model query job specified as num_iterations in the input query. The actual total number of iterations may be less than this number due to early stop.
    CurrentIteration int
    [Output-only, Beta] Index of current ML training iteration. Updated during create model query job to show job progress.
    ExpectedTotalIterations string
    [Output-only, Beta] Expected number of iterations for the create model query job specified as num_iterations in the input query. The actual total number of iterations may be less than this number due to early stop.
    currentIteration Integer
    [Output-only, Beta] Index of current ML training iteration. Updated during create model query job to show job progress.
    expectedTotalIterations String
    [Output-only, Beta] Expected number of iterations for the create model query job specified as num_iterations in the input query. The actual total number of iterations may be less than this number due to early stop.
    currentIteration number
    [Output-only, Beta] Index of current ML training iteration. Updated during create model query job to show job progress.
    expectedTotalIterations string
    [Output-only, Beta] Expected number of iterations for the create model query job specified as num_iterations in the input query. The actual total number of iterations may be less than this number due to early stop.
    current_iteration int
    [Output-only, Beta] Index of current ML training iteration. Updated during create model query job to show job progress.
    expected_total_iterations str
    [Output-only, Beta] Expected number of iterations for the create model query job specified as num_iterations in the input query. The actual total number of iterations may be less than this number due to early stop.
    currentIteration Number
    [Output-only, Beta] Index of current ML training iteration. Updated during create model query job to show job progress.
    expectedTotalIterations String
    [Output-only, Beta] Expected number of iterations for the create model query job specified as num_iterations in the input query. The actual total number of iterations may be less than this number due to early stop.

    Clustering, ClusteringArgs

    Fields List<string>
    [Repeated] One or more fields on which data should be clustered. Only top-level, non-repeated, simple-type fields are supported. When you cluster a table using multiple columns, the order of columns you specify is important. The order of the specified columns determines the sort order of the data.
    Fields []string
    [Repeated] One or more fields on which data should be clustered. Only top-level, non-repeated, simple-type fields are supported. When you cluster a table using multiple columns, the order of columns you specify is important. The order of the specified columns determines the sort order of the data.
    fields List<String>
    [Repeated] One or more fields on which data should be clustered. Only top-level, non-repeated, simple-type fields are supported. When you cluster a table using multiple columns, the order of columns you specify is important. The order of the specified columns determines the sort order of the data.
    fields string[]
    [Repeated] One or more fields on which data should be clustered. Only top-level, non-repeated, simple-type fields are supported. When you cluster a table using multiple columns, the order of columns you specify is important. The order of the specified columns determines the sort order of the data.
    fields Sequence[str]
    [Repeated] One or more fields on which data should be clustered. Only top-level, non-repeated, simple-type fields are supported. When you cluster a table using multiple columns, the order of columns you specify is important. The order of the specified columns determines the sort order of the data.
    fields List<String>
    [Repeated] One or more fields on which data should be clustered. Only top-level, non-repeated, simple-type fields are supported. When you cluster a table using multiple columns, the order of columns you specify is important. The order of the specified columns determines the sort order of the data.

    ClusteringResponse, ClusteringResponseArgs

    Fields List<string>
    [Repeated] One or more fields on which data should be clustered. Only top-level, non-repeated, simple-type fields are supported. When you cluster a table using multiple columns, the order of columns you specify is important. The order of the specified columns determines the sort order of the data.
    Fields []string
    [Repeated] One or more fields on which data should be clustered. Only top-level, non-repeated, simple-type fields are supported. When you cluster a table using multiple columns, the order of columns you specify is important. The order of the specified columns determines the sort order of the data.
    fields List<String>
    [Repeated] One or more fields on which data should be clustered. Only top-level, non-repeated, simple-type fields are supported. When you cluster a table using multiple columns, the order of columns you specify is important. The order of the specified columns determines the sort order of the data.
    fields string[]
    [Repeated] One or more fields on which data should be clustered. Only top-level, non-repeated, simple-type fields are supported. When you cluster a table using multiple columns, the order of columns you specify is important. The order of the specified columns determines the sort order of the data.
    fields Sequence[str]
    [Repeated] One or more fields on which data should be clustered. Only top-level, non-repeated, simple-type fields are supported. When you cluster a table using multiple columns, the order of columns you specify is important. The order of the specified columns determines the sort order of the data.
    fields List<String>
    [Repeated] One or more fields on which data should be clustered. Only top-level, non-repeated, simple-type fields are supported. When you cluster a table using multiple columns, the order of columns you specify is important. The order of the specified columns determines the sort order of the data.

    ConnectionProperty, ConnectionPropertyArgs

    Key string
    [Required] Name of the connection property to set.
    Value string
    [Required] Value of the connection property.
    Key string
    [Required] Name of the connection property to set.
    Value string
    [Required] Value of the connection property.
    key String
    [Required] Name of the connection property to set.
    value String
    [Required] Value of the connection property.
    key string
    [Required] Name of the connection property to set.
    value string
    [Required] Value of the connection property.
    key str
    [Required] Name of the connection property to set.
    value str
    [Required] Value of the connection property.
    key String
    [Required] Name of the connection property to set.
    value String
    [Required] Value of the connection property.

    ConnectionPropertyResponse, ConnectionPropertyResponseArgs

    Key string
    [Required] Name of the connection property to set.
    Value string
    [Required] Value of the connection property.
    Key string
    [Required] Name of the connection property to set.
    Value string
    [Required] Value of the connection property.
    key String
    [Required] Name of the connection property to set.
    value String
    [Required] Value of the connection property.
    key string
    [Required] Name of the connection property to set.
    value string
    [Required] Value of the connection property.
    key str
    [Required] Name of the connection property to set.
    value str
    [Required] Value of the connection property.
    key String
    [Required] Name of the connection property to set.
    value String
    [Required] Value of the connection property.

    DataMaskingStatisticsResponse, DataMaskingStatisticsResponseArgs

    DataMaskingApplied bool
    [Preview] Whether any accessed data was protected by data masking. The actual evaluation is done by accessStats.masked_field_count > 0. Since this is only used for the discovery_doc generation purpose, as long as the type (boolean) matches, client library can leverage this. The actual evaluation of the variable is done else-where.
    DataMaskingApplied bool
    [Preview] Whether any accessed data was protected by data masking. The actual evaluation is done by accessStats.masked_field_count > 0. Since this is only used for the discovery_doc generation purpose, as long as the type (boolean) matches, client library can leverage this. The actual evaluation of the variable is done else-where.
    dataMaskingApplied Boolean
    [Preview] Whether any accessed data was protected by data masking. The actual evaluation is done by accessStats.masked_field_count > 0. Since this is only used for the discovery_doc generation purpose, as long as the type (boolean) matches, client library can leverage this. The actual evaluation of the variable is done else-where.
    dataMaskingApplied boolean
    [Preview] Whether any accessed data was protected by data masking. The actual evaluation is done by accessStats.masked_field_count > 0. Since this is only used for the discovery_doc generation purpose, as long as the type (boolean) matches, client library can leverage this. The actual evaluation of the variable is done else-where.
    data_masking_applied bool
    [Preview] Whether any accessed data was protected by data masking. The actual evaluation is done by accessStats.masked_field_count > 0. Since this is only used for the discovery_doc generation purpose, as long as the type (boolean) matches, client library can leverage this. The actual evaluation of the variable is done else-where.
    dataMaskingApplied Boolean
    [Preview] Whether any accessed data was protected by data masking. The actual evaluation is done by accessStats.masked_field_count > 0. Since this is only used for the discovery_doc generation purpose, as long as the type (boolean) matches, client library can leverage this. The actual evaluation of the variable is done else-where.

    DatasetReference, DatasetReferenceArgs

    DatasetId string
    [Required] A unique ID for this dataset, without the project name. The ID must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_). The maximum length is 1,024 characters.
    Project string
    [Optional] The ID of the project containing this dataset.
    DatasetId string
    [Required] A unique ID for this dataset, without the project name. The ID must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_). The maximum length is 1,024 characters.
    Project string
    [Optional] The ID of the project containing this dataset.
    datasetId String
    [Required] A unique ID for this dataset, without the project name. The ID must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_). The maximum length is 1,024 characters.
    project String
    [Optional] The ID of the project containing this dataset.
    datasetId string
    [Required] A unique ID for this dataset, without the project name. The ID must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_). The maximum length is 1,024 characters.
    project string
    [Optional] The ID of the project containing this dataset.
    dataset_id str
    [Required] A unique ID for this dataset, without the project name. The ID must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_). The maximum length is 1,024 characters.
    project str
    [Optional] The ID of the project containing this dataset.
    datasetId String
    [Required] A unique ID for this dataset, without the project name. The ID must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_). The maximum length is 1,024 characters.
    project String
    [Optional] The ID of the project containing this dataset.

    DatasetReferenceResponse, DatasetReferenceResponseArgs

    DatasetId string
    [Required] A unique ID for this dataset, without the project name. The ID must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_). The maximum length is 1,024 characters.
    Project string
    [Optional] The ID of the project containing this dataset.
    DatasetId string
    [Required] A unique ID for this dataset, without the project name. The ID must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_). The maximum length is 1,024 characters.
    Project string
    [Optional] The ID of the project containing this dataset.
    datasetId String
    [Required] A unique ID for this dataset, without the project name. The ID must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_). The maximum length is 1,024 characters.
    project String
    [Optional] The ID of the project containing this dataset.
    datasetId string
    [Required] A unique ID for this dataset, without the project name. The ID must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_). The maximum length is 1,024 characters.
    project string
    [Optional] The ID of the project containing this dataset.
    dataset_id str
    [Required] A unique ID for this dataset, without the project name. The ID must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_). The maximum length is 1,024 characters.
    project str
    [Optional] The ID of the project containing this dataset.
    datasetId String
    [Required] A unique ID for this dataset, without the project name. The ID must contain only letters (a-z, A-Z), numbers (0-9), or underscores (_). The maximum length is 1,024 characters.
    project String
    [Optional] The ID of the project containing this dataset.

    DestinationTableProperties, DestinationTablePropertiesArgs

    Description string
    [Optional] The description for the destination table. This will only be used if the destination table is newly created. If the table already exists and a value different than the current description is provided, the job will fail.
    ExpirationTime string
    [Internal] This field is for Google internal use only.
    FriendlyName string
    [Optional] The friendly name for the destination table. This will only be used if the destination table is newly created. If the table already exists and a value different than the current friendly name is provided, the job will fail.
    Labels Dictionary<string, string>
    [Optional] The labels associated with this table. You can use these to organize and group your tables. This will only be used if the destination table is newly created. If the table already exists and labels are different than the current labels are provided, the job will fail.
    Description string
    [Optional] The description for the destination table. This will only be used if the destination table is newly created. If the table already exists and a value different than the current description is provided, the job will fail.
    ExpirationTime string
    [Internal] This field is for Google internal use only.
    FriendlyName string
    [Optional] The friendly name for the destination table. This will only be used if the destination table is newly created. If the table already exists and a value different than the current friendly name is provided, the job will fail.
    Labels map[string]string
    [Optional] The labels associated with this table. You can use these to organize and group your tables. This will only be used if the destination table is newly created. If the table already exists and labels are different than the current labels are provided, the job will fail.
    description String
    [Optional] The description for the destination table. This will only be used if the destination table is newly created. If the table already exists and a value different than the current description is provided, the job will fail.
    expirationTime String
    [Internal] This field is for Google internal use only.
    friendlyName String
    [Optional] The friendly name for the destination table. This will only be used if the destination table is newly created. If the table already exists and a value different than the current friendly name is provided, the job will fail.
    labels Map<String,String>
    [Optional] The labels associated with this table. You can use these to organize and group your tables. This will only be used if the destination table is newly created. If the table already exists and labels are different than the current labels are provided, the job will fail.
    description string
    [Optional] The description for the destination table. This will only be used if the destination table is newly created. If the table already exists and a value different than the current description is provided, the job will fail.
    expirationTime string
    [Internal] This field is for Google internal use only.
    friendlyName string
    [Optional] The friendly name for the destination table. This will only be used if the destination table is newly created. If the table already exists and a value different than the current friendly name is provided, the job will fail.
    labels {[key: string]: string}
    [Optional] The labels associated with this table. You can use these to organize and group your tables. This will only be used if the destination table is newly created. If the table already exists and labels are different than the current labels are provided, the job will fail.
    description str
    [Optional] The description for the destination table. This will only be used if the destination table is newly created. If the table already exists and a value different than the current description is provided, the job will fail.
    expiration_time str
    [Internal] This field is for Google internal use only.
    friendly_name str
    [Optional] The friendly name for the destination table. This will only be used if the destination table is newly created. If the table already exists and a value different than the current friendly name is provided, the job will fail.
    labels Mapping[str, str]
    [Optional] The labels associated with this table. You can use these to organize and group your tables. This will only be used if the destination table is newly created. If the table already exists and labels are different than the current labels are provided, the job will fail.
    description String
    [Optional] The description for the destination table. This will only be used if the destination table is newly created. If the table already exists and a value different than the current description is provided, the job will fail.
    expirationTime String
    [Internal] This field is for Google internal use only.
    friendlyName String
    [Optional] The friendly name for the destination table. This will only be used if the destination table is newly created. If the table already exists and a value different than the current friendly name is provided, the job will fail.
    labels Map<String>
    [Optional] The labels associated with this table. You can use these to organize and group your tables. This will only be used if the destination table is newly created. If the table already exists and labels are different than the current labels are provided, the job will fail.

    DestinationTablePropertiesResponse, DestinationTablePropertiesResponseArgs

    Description string
    [Optional] The description for the destination table. This will only be used if the destination table is newly created. If the table already exists and a value different than the current description is provided, the job will fail.
    ExpirationTime string
    [Internal] This field is for Google internal use only.
    FriendlyName string
    [Optional] The friendly name for the destination table. This will only be used if the destination table is newly created. If the table already exists and a value different than the current friendly name is provided, the job will fail.
    Labels Dictionary<string, string>
    [Optional] The labels associated with this table. You can use these to organize and group your tables. This will only be used if the destination table is newly created. If the table already exists and labels are different than the current labels are provided, the job will fail.
    Description string
    [Optional] The description for the destination table. This will only be used if the destination table is newly created. If the table already exists and a value different than the current description is provided, the job will fail.
    ExpirationTime string
    [Internal] This field is for Google internal use only.
    FriendlyName string
    [Optional] The friendly name for the destination table. This will only be used if the destination table is newly created. If the table already exists and a value different than the current friendly name is provided, the job will fail.
    Labels map[string]string
    [Optional] The labels associated with this table. You can use these to organize and group your tables. This will only be used if the destination table is newly created. If the table already exists and labels are different than the current labels are provided, the job will fail.
    description String
    [Optional] The description for the destination table. This will only be used if the destination table is newly created. If the table already exists and a value different than the current description is provided, the job will fail.
    expirationTime String
    [Internal] This field is for Google internal use only.
    friendlyName String
    [Optional] The friendly name for the destination table. This will only be used if the destination table is newly created. If the table already exists and a value different than the current friendly name is provided, the job will fail.
    labels Map<String,String>
    [Optional] The labels associated with this table. You can use these to organize and group your tables. This will only be used if the destination table is newly created. If the table already exists and labels are different than the current labels are provided, the job will fail.
    description string
    [Optional] The description for the destination table. This will only be used if the destination table is newly created. If the table already exists and a value different than the current description is provided, the job will fail.
    expirationTime string
    [Internal] This field is for Google internal use only.
    friendlyName string
    [Optional] The friendly name for the destination table. This will only be used if the destination table is newly created. If the table already exists and a value different than the current friendly name is provided, the job will fail.
    labels {[key: string]: string}
    [Optional] The labels associated with this table. You can use these to organize and group your tables. This will only be used if the destination table is newly created. If the table already exists and labels are different than the current labels are provided, the job will fail.
    description str
    [Optional] The description for the destination table. This will only be used if the destination table is newly created. If the table already exists and a value different than the current description is provided, the job will fail.
    expiration_time str
    [Internal] This field is for Google internal use only.
    friendly_name str
    [Optional] The friendly name for the destination table. This will only be used if the destination table is newly created. If the table already exists and a value different than the current friendly name is provided, the job will fail.
    labels Mapping[str, str]
    [Optional] The labels associated with this table. You can use these to organize and group your tables. This will only be used if the destination table is newly created. If the table already exists and labels are different than the current labels are provided, the job will fail.
    description String
    [Optional] The description for the destination table. This will only be used if the destination table is newly created. If the table already exists and a value different than the current description is provided, the job will fail.
    expirationTime String
    [Internal] This field is for Google internal use only.
    friendlyName String
    [Optional] The friendly name for the destination table. This will only be used if the destination table is newly created. If the table already exists and a value different than the current friendly name is provided, the job will fail.
    labels Map<String>
    [Optional] The labels associated with this table. You can use these to organize and group your tables. This will only be used if the destination table is newly created. If the table already exists and labels are different than the current labels are provided, the job will fail.

    DmlStatisticsResponse, DmlStatisticsResponseArgs

    DeletedRowCount string
    Number of deleted Rows. populated by DML DELETE, MERGE and TRUNCATE statements.
    InsertedRowCount string
    Number of inserted Rows. Populated by DML INSERT and MERGE statements.
    UpdatedRowCount string
    Number of updated Rows. Populated by DML UPDATE and MERGE statements.
    DeletedRowCount string
    Number of deleted Rows. populated by DML DELETE, MERGE and TRUNCATE statements.
    InsertedRowCount string
    Number of inserted Rows. Populated by DML INSERT and MERGE statements.
    UpdatedRowCount string
    Number of updated Rows. Populated by DML UPDATE and MERGE statements.
    deletedRowCount String
    Number of deleted Rows. populated by DML DELETE, MERGE and TRUNCATE statements.
    insertedRowCount String
    Number of inserted Rows. Populated by DML INSERT and MERGE statements.
    updatedRowCount String
    Number of updated Rows. Populated by DML UPDATE and MERGE statements.
    deletedRowCount string
    Number of deleted Rows. populated by DML DELETE, MERGE and TRUNCATE statements.
    insertedRowCount string
    Number of inserted Rows. Populated by DML INSERT and MERGE statements.
    updatedRowCount string
    Number of updated Rows. Populated by DML UPDATE and MERGE statements.
    deleted_row_count str
    Number of deleted Rows. populated by DML DELETE, MERGE and TRUNCATE statements.
    inserted_row_count str
    Number of inserted Rows. Populated by DML INSERT and MERGE statements.
    updated_row_count str
    Number of updated Rows. Populated by DML UPDATE and MERGE statements.
    deletedRowCount String
    Number of deleted Rows. populated by DML DELETE, MERGE and TRUNCATE statements.
    insertedRowCount String
    Number of inserted Rows. Populated by DML INSERT and MERGE statements.
    updatedRowCount String
    Number of updated Rows. Populated by DML UPDATE and MERGE statements.

    EncryptionConfiguration, EncryptionConfigurationArgs

    KmsKeyName string
    Optional. Describes the Cloud KMS encryption key that will be used to protect destination BigQuery table. The BigQuery Service Account associated with your project requires access to this encryption key.
    KmsKeyName string
    Optional. Describes the Cloud KMS encryption key that will be used to protect destination BigQuery table. The BigQuery Service Account associated with your project requires access to this encryption key.
    kmsKeyName String
    Optional. Describes the Cloud KMS encryption key that will be used to protect destination BigQuery table. The BigQuery Service Account associated with your project requires access to this encryption key.
    kmsKeyName string
    Optional. Describes the Cloud KMS encryption key that will be used to protect destination BigQuery table. The BigQuery Service Account associated with your project requires access to this encryption key.
    kms_key_name str
    Optional. Describes the Cloud KMS encryption key that will be used to protect destination BigQuery table. The BigQuery Service Account associated with your project requires access to this encryption key.
    kmsKeyName String
    Optional. Describes the Cloud KMS encryption key that will be used to protect destination BigQuery table. The BigQuery Service Account associated with your project requires access to this encryption key.

    EncryptionConfigurationResponse, EncryptionConfigurationResponseArgs

    KmsKeyName string
    Optional. Describes the Cloud KMS encryption key that will be used to protect destination BigQuery table. The BigQuery Service Account associated with your project requires access to this encryption key.
    KmsKeyName string
    Optional. Describes the Cloud KMS encryption key that will be used to protect destination BigQuery table. The BigQuery Service Account associated with your project requires access to this encryption key.
    kmsKeyName String
    Optional. Describes the Cloud KMS encryption key that will be used to protect destination BigQuery table. The BigQuery Service Account associated with your project requires access to this encryption key.
    kmsKeyName string
    Optional. Describes the Cloud KMS encryption key that will be used to protect destination BigQuery table. The BigQuery Service Account associated with your project requires access to this encryption key.
    kms_key_name str
    Optional. Describes the Cloud KMS encryption key that will be used to protect destination BigQuery table. The BigQuery Service Account associated with your project requires access to this encryption key.
    kmsKeyName String
    Optional. Describes the Cloud KMS encryption key that will be used to protect destination BigQuery table. The BigQuery Service Account associated with your project requires access to this encryption key.

    ErrorProtoResponse, ErrorProtoResponseArgs

    DebugInfo string
    Debugging information. This property is internal to Google and should not be used.
    Location string
    Specifies where the error occurred, if present.
    Message string
    A human-readable description of the error.
    Reason string
    A short error code that summarizes the error.
    DebugInfo string
    Debugging information. This property is internal to Google and should not be used.
    Location string
    Specifies where the error occurred, if present.
    Message string
    A human-readable description of the error.
    Reason string
    A short error code that summarizes the error.
    debugInfo String
    Debugging information. This property is internal to Google and should not be used.
    location String
    Specifies where the error occurred, if present.
    message String
    A human-readable description of the error.
    reason String
    A short error code that summarizes the error.
    debugInfo string
    Debugging information. This property is internal to Google and should not be used.
    location string
    Specifies where the error occurred, if present.
    message string
    A human-readable description of the error.
    reason string
    A short error code that summarizes the error.
    debug_info str
    Debugging information. This property is internal to Google and should not be used.
    location str
    Specifies where the error occurred, if present.
    message str
    A human-readable description of the error.
    reason str
    A short error code that summarizes the error.
    debugInfo String
    Debugging information. This property is internal to Google and should not be used.
    location String
    Specifies where the error occurred, if present.
    message String
    A human-readable description of the error.
    reason String
    A short error code that summarizes the error.

    ExplainQueryStageResponse, ExplainQueryStageResponseArgs

    CompletedParallelInputs string
    Number of parallel input segments completed.
    ComputeMsAvg string
    Milliseconds the average shard spent on CPU-bound tasks.
    ComputeMsMax string
    Milliseconds the slowest shard spent on CPU-bound tasks.
    ComputeRatioAvg double
    Relative amount of time the average shard spent on CPU-bound tasks.
    ComputeRatioMax double
    Relative amount of time the slowest shard spent on CPU-bound tasks.
    EndMs string
    Stage end time represented as milliseconds since epoch.
    InputStages List<string>
    IDs for stages that are inputs to this stage.
    Name string
    Human-readable name for stage.
    ParallelInputs string
    Number of parallel input segments to be processed.
    ReadMsAvg string
    Milliseconds the average shard spent reading input.
    ReadMsMax string
    Milliseconds the slowest shard spent reading input.
    ReadRatioAvg double
    Relative amount of time the average shard spent reading input.
    ReadRatioMax double
    Relative amount of time the slowest shard spent reading input.
    RecordsRead string
    Number of records read into the stage.
    RecordsWritten string
    Number of records written by the stage.
    ShuffleOutputBytes string
    Total number of bytes written to shuffle.
    ShuffleOutputBytesSpilled string
    Total number of bytes written to shuffle and spilled to disk.
    SlotMs string
    Slot-milliseconds used by the stage.
    StartMs string
    Stage start time represented as milliseconds since epoch.
    Status string
    Current status for the stage.
    Steps List<Pulumi.GoogleNative.BigQuery.V2.Inputs.ExplainQueryStepResponse>
    List of operations within the stage in dependency order (approximately chronological).
    WaitMsAvg string
    Milliseconds the average shard spent waiting to be scheduled.
    WaitMsMax string
    Milliseconds the slowest shard spent waiting to be scheduled.
    WaitRatioAvg double
    Relative amount of time the average shard spent waiting to be scheduled.
    WaitRatioMax double
    Relative amount of time the slowest shard spent waiting to be scheduled.
    WriteMsAvg string
    Milliseconds the average shard spent on writing output.
    WriteMsMax string
    Milliseconds the slowest shard spent on writing output.
    WriteRatioAvg double
    Relative amount of time the average shard spent on writing output.
    WriteRatioMax double
    Relative amount of time the slowest shard spent on writing output.
    CompletedParallelInputs string
    Number of parallel input segments completed.
    ComputeMsAvg string
    Milliseconds the average shard spent on CPU-bound tasks.
    ComputeMsMax string
    Milliseconds the slowest shard spent on CPU-bound tasks.
    ComputeRatioAvg float64
    Relative amount of time the average shard spent on CPU-bound tasks.
    ComputeRatioMax float64
    Relative amount of time the slowest shard spent on CPU-bound tasks.
    EndMs string
    Stage end time represented as milliseconds since epoch.
    InputStages []string
    IDs for stages that are inputs to this stage.
    Name string
    Human-readable name for stage.
    ParallelInputs string
    Number of parallel input segments to be processed.
    ReadMsAvg string
    Milliseconds the average shard spent reading input.
    ReadMsMax string
    Milliseconds the slowest shard spent reading input.
    ReadRatioAvg float64
    Relative amount of time the average shard spent reading input.
    ReadRatioMax float64
    Relative amount of time the slowest shard spent reading input.
    RecordsRead string
    Number of records read into the stage.
    RecordsWritten string
    Number of records written by the stage.
    ShuffleOutputBytes string
    Total number of bytes written to shuffle.
    ShuffleOutputBytesSpilled string
    Total number of bytes written to shuffle and spilled to disk.
    SlotMs string
    Slot-milliseconds used by the stage.
    StartMs string
    Stage start time represented as milliseconds since epoch.
    Status string
    Current status for the stage.
    Steps []ExplainQueryStepResponse
    List of operations within the stage in dependency order (approximately chronological).
    WaitMsAvg string
    Milliseconds the average shard spent waiting to be scheduled.
    WaitMsMax string
    Milliseconds the slowest shard spent waiting to be scheduled.
    WaitRatioAvg float64
    Relative amount of time the average shard spent waiting to be scheduled.
    WaitRatioMax float64
    Relative amount of time the slowest shard spent waiting to be scheduled.
    WriteMsAvg string
    Milliseconds the average shard spent on writing output.
    WriteMsMax string
    Milliseconds the slowest shard spent on writing output.
    WriteRatioAvg float64
    Relative amount of time the average shard spent on writing output.
    WriteRatioMax float64
    Relative amount of time the slowest shard spent on writing output.
    completedParallelInputs String
    Number of parallel input segments completed.
    computeMsAvg String
    Milliseconds the average shard spent on CPU-bound tasks.
    computeMsMax String
    Milliseconds the slowest shard spent on CPU-bound tasks.
    computeRatioAvg Double
    Relative amount of time the average shard spent on CPU-bound tasks.
    computeRatioMax Double
    Relative amount of time the slowest shard spent on CPU-bound tasks.
    endMs String
    Stage end time represented as milliseconds since epoch.
    inputStages List<String>
    IDs for stages that are inputs to this stage.
    name String
    Human-readable name for stage.
    parallelInputs String
    Number of parallel input segments to be processed.
    readMsAvg String
    Milliseconds the average shard spent reading input.
    readMsMax String
    Milliseconds the slowest shard spent reading input.
    readRatioAvg Double
    Relative amount of time the average shard spent reading input.
    readRatioMax Double
    Relative amount of time the slowest shard spent reading input.
    recordsRead String
    Number of records read into the stage.
    recordsWritten String
    Number of records written by the stage.
    shuffleOutputBytes String
    Total number of bytes written to shuffle.
    shuffleOutputBytesSpilled String
    Total number of bytes written to shuffle and spilled to disk.
    slotMs String
    Slot-milliseconds used by the stage.
    startMs String
    Stage start time represented as milliseconds since epoch.
    status String
    Current status for the stage.
    steps List<ExplainQueryStepResponse>
    List of operations within the stage in dependency order (approximately chronological).
    waitMsAvg String
    Milliseconds the average shard spent waiting to be scheduled.
    waitMsMax String
    Milliseconds the slowest shard spent waiting to be scheduled.
    waitRatioAvg Double
    Relative amount of time the average shard spent waiting to be scheduled.
    waitRatioMax Double
    Relative amount of time the slowest shard spent waiting to be scheduled.
    writeMsAvg String
    Milliseconds the average shard spent on writing output.
    writeMsMax String
    Milliseconds the slowest shard spent on writing output.
    writeRatioAvg Double
    Relative amount of time the average shard spent on writing output.
    writeRatioMax Double
    Relative amount of time the slowest shard spent on writing output.
    completedParallelInputs string
    Number of parallel input segments completed.
    computeMsAvg string
    Milliseconds the average shard spent on CPU-bound tasks.
    computeMsMax string
    Milliseconds the slowest shard spent on CPU-bound tasks.
    computeRatioAvg number
    Relative amount of time the average shard spent on CPU-bound tasks.
    computeRatioMax number
    Relative amount of time the slowest shard spent on CPU-bound tasks.
    endMs string
    Stage end time represented as milliseconds since epoch.
    inputStages string[]
    IDs for stages that are inputs to this stage.
    name string
    Human-readable name for stage.
    parallelInputs string
    Number of parallel input segments to be processed.
    readMsAvg string
    Milliseconds the average shard spent reading input.
    readMsMax string
    Milliseconds the slowest shard spent reading input.
    readRatioAvg number
    Relative amount of time the average shard spent reading input.
    readRatioMax number
    Relative amount of time the slowest shard spent reading input.
    recordsRead string
    Number of records read into the stage.
    recordsWritten string
    Number of records written by the stage.
    shuffleOutputBytes string
    Total number of bytes written to shuffle.
    shuffleOutputBytesSpilled string
    Total number of bytes written to shuffle and spilled to disk.
    slotMs string
    Slot-milliseconds used by the stage.
    startMs string
    Stage start time represented as milliseconds since epoch.
    status string
    Current status for the stage.
    steps ExplainQueryStepResponse[]
    List of operations within the stage in dependency order (approximately chronological).
    waitMsAvg string
    Milliseconds the average shard spent waiting to be scheduled.
    waitMsMax string
    Milliseconds the slowest shard spent waiting to be scheduled.
    waitRatioAvg number
    Relative amount of time the average shard spent waiting to be scheduled.
    waitRatioMax number
    Relative amount of time the slowest shard spent waiting to be scheduled.
    writeMsAvg string
    Milliseconds the average shard spent on writing output.
    writeMsMax string
    Milliseconds the slowest shard spent on writing output.
    writeRatioAvg number
    Relative amount of time the average shard spent on writing output.
    writeRatioMax number
    Relative amount of time the slowest shard spent on writing output.
    completed_parallel_inputs str
    Number of parallel input segments completed.
    compute_ms_avg str
    Milliseconds the average shard spent on CPU-bound tasks.
    compute_ms_max str
    Milliseconds the slowest shard spent on CPU-bound tasks.
    compute_ratio_avg float
    Relative amount of time the average shard spent on CPU-bound tasks.
    compute_ratio_max float
    Relative amount of time the slowest shard spent on CPU-bound tasks.
    end_ms str
    Stage end time represented as milliseconds since epoch.
    input_stages Sequence[str]
    IDs for stages that are inputs to this stage.
    name str
    Human-readable name for stage.
    parallel_inputs str
    Number of parallel input segments to be processed.
    read_ms_avg str
    Milliseconds the average shard spent reading input.
    read_ms_max str
    Milliseconds the slowest shard spent reading input.
    read_ratio_avg float
    Relative amount of time the average shard spent reading input.
    read_ratio_max float
    Relative amount of time the slowest shard spent reading input.
    records_read str
    Number of records read into the stage.
    records_written str
    Number of records written by the stage.
    shuffle_output_bytes str
    Total number of bytes written to shuffle.
    shuffle_output_bytes_spilled str
    Total number of bytes written to shuffle and spilled to disk.
    slot_ms str
    Slot-milliseconds used by the stage.
    start_ms str
    Stage start time represented as milliseconds since epoch.
    status str
    Current status for the stage.
    steps Sequence[ExplainQueryStepResponse]
    List of operations within the stage in dependency order (approximately chronological).
    wait_ms_avg str
    Milliseconds the average shard spent waiting to be scheduled.
    wait_ms_max str
    Milliseconds the slowest shard spent waiting to be scheduled.
    wait_ratio_avg float
    Relative amount of time the average shard spent waiting to be scheduled.
    wait_ratio_max float
    Relative amount of time the slowest shard spent waiting to be scheduled.
    write_ms_avg str
    Milliseconds the average shard spent on writing output.
    write_ms_max str
    Milliseconds the slowest shard spent on writing output.
    write_ratio_avg float
    Relative amount of time the average shard spent on writing output.
    write_ratio_max float
    Relative amount of time the slowest shard spent on writing output.
    completedParallelInputs String
    Number of parallel input segments completed.
    computeMsAvg String
    Milliseconds the average shard spent on CPU-bound tasks.
    computeMsMax String
    Milliseconds the slowest shard spent on CPU-bound tasks.
    computeRatioAvg Number
    Relative amount of time the average shard spent on CPU-bound tasks.
    computeRatioMax Number
    Relative amount of time the slowest shard spent on CPU-bound tasks.
    endMs String
    Stage end time represented as milliseconds since epoch.
    inputStages List<String>
    IDs for stages that are inputs to this stage.
    name String
    Human-readable name for stage.
    parallelInputs String
    Number of parallel input segments to be processed.
    readMsAvg String
    Milliseconds the average shard spent reading input.
    readMsMax String
    Milliseconds the slowest shard spent reading input.
    readRatioAvg Number
    Relative amount of time the average shard spent reading input.
    readRatioMax Number
    Relative amount of time the slowest shard spent reading input.
    recordsRead String
    Number of records read into the stage.
    recordsWritten String
    Number of records written by the stage.
    shuffleOutputBytes String
    Total number of bytes written to shuffle.
    shuffleOutputBytesSpilled String
    Total number of bytes written to shuffle and spilled to disk.
    slotMs String
    Slot-milliseconds used by the stage.
    startMs String
    Stage start time represented as milliseconds since epoch.
    status String
    Current status for the stage.
    steps List<Property Map>
    List of operations within the stage in dependency order (approximately chronological).
    waitMsAvg String
    Milliseconds the average shard spent waiting to be scheduled.
    waitMsMax String
    Milliseconds the slowest shard spent waiting to be scheduled.
    waitRatioAvg Number
    Relative amount of time the average shard spent waiting to be scheduled.
    waitRatioMax Number
    Relative amount of time the slowest shard spent waiting to be scheduled.
    writeMsAvg String
    Milliseconds the average shard spent on writing output.
    writeMsMax String
    Milliseconds the slowest shard spent on writing output.
    writeRatioAvg Number
    Relative amount of time the average shard spent on writing output.
    writeRatioMax Number
    Relative amount of time the slowest shard spent on writing output.

    ExplainQueryStepResponse, ExplainQueryStepResponseArgs

    Kind string
    Machine-readable operation type.
    Substeps List<string>
    Human-readable stage descriptions.
    Kind string
    Machine-readable operation type.
    Substeps []string
    Human-readable stage descriptions.
    kind String
    Machine-readable operation type.
    substeps List<String>
    Human-readable stage descriptions.
    kind string
    Machine-readable operation type.
    substeps string[]
    Human-readable stage descriptions.
    kind str
    Machine-readable operation type.
    substeps Sequence[str]
    Human-readable stage descriptions.
    kind String
    Machine-readable operation type.
    substeps List<String>
    Human-readable stage descriptions.

    HivePartitioningOptions, HivePartitioningOptionsArgs

    Mode string
    [Optional] When set, what mode of hive partitioning to use when reading data. The following modes are supported. (1) AUTO: automatically infer partition key name(s) and type(s). (2) STRINGS: automatically infer partition key name(s). All types are interpreted as strings. (3) CUSTOM: partition key schema is encoded in the source URI prefix. Not all storage formats support hive partitioning. Requesting hive partitioning on an unsupported format will lead to an error. Currently supported types include: AVRO, CSV, JSON, ORC and Parquet.
    RequirePartitionFilter bool
    [Optional] If set to true, queries over this table require a partition filter that can be used for partition elimination to be specified. Note that this field should only be true when creating a permanent external table or querying a temporary external table. Hive-partitioned loads with requirePartitionFilter explicitly set to true will fail.
    SourceUriPrefix string
    [Optional] When hive partition detection is requested, a common prefix for all source uris should be supplied. The prefix must end immediately before the partition key encoding begins. For example, consider files following this data layout. gs://bucket/path_to_table/dt=2019-01-01/country=BR/id=7/file.avro gs://bucket/path_to_table/dt=2018-12-31/country=CA/id=3/file.avro When hive partitioning is requested with either AUTO or STRINGS detection, the common prefix can be either of gs://bucket/path_to_table or gs://bucket/path_to_table/ (trailing slash does not matter).
    Mode string
    [Optional] When set, what mode of hive partitioning to use when reading data. The following modes are supported. (1) AUTO: automatically infer partition key name(s) and type(s). (2) STRINGS: automatically infer partition key name(s). All types are interpreted as strings. (3) CUSTOM: partition key schema is encoded in the source URI prefix. Not all storage formats support hive partitioning. Requesting hive partitioning on an unsupported format will lead to an error. Currently supported types include: AVRO, CSV, JSON, ORC and Parquet.
    RequirePartitionFilter bool
    [Optional] If set to true, queries over this table require a partition filter that can be used for partition elimination to be specified. Note that this field should only be true when creating a permanent external table or querying a temporary external table. Hive-partitioned loads with requirePartitionFilter explicitly set to true will fail.
    SourceUriPrefix string
    [Optional] When hive partition detection is requested, a common prefix for all source uris should be supplied. The prefix must end immediately before the partition key encoding begins. For example, consider files following this data layout. gs://bucket/path_to_table/dt=2019-01-01/country=BR/id=7/file.avro gs://bucket/path_to_table/dt=2018-12-31/country=CA/id=3/file.avro When hive partitioning is requested with either AUTO or STRINGS detection, the common prefix can be either of gs://bucket/path_to_table or gs://bucket/path_to_table/ (trailing slash does not matter).
    mode String
    [Optional] When set, what mode of hive partitioning to use when reading data. The following modes are supported. (1) AUTO: automatically infer partition key name(s) and type(s). (2) STRINGS: automatically infer partition key name(s). All types are interpreted as strings. (3) CUSTOM: partition key schema is encoded in the source URI prefix. Not all storage formats support hive partitioning. Requesting hive partitioning on an unsupported format will lead to an error. Currently supported types include: AVRO, CSV, JSON, ORC and Parquet.
    requirePartitionFilter Boolean
    [Optional] If set to true, queries over this table require a partition filter that can be used for partition elimination to be specified. Note that this field should only be true when creating a permanent external table or querying a temporary external table. Hive-partitioned loads with requirePartitionFilter explicitly set to true will fail.
    sourceUriPrefix String
    [Optional] When hive partition detection is requested, a common prefix for all source uris should be supplied. The prefix must end immediately before the partition key encoding begins. For example, consider files following this data layout. gs://bucket/path_to_table/dt=2019-01-01/country=BR/id=7/file.avro gs://bucket/path_to_table/dt=2018-12-31/country=CA/id=3/file.avro When hive partitioning is requested with either AUTO or STRINGS detection, the common prefix can be either of gs://bucket/path_to_table or gs://bucket/path_to_table/ (trailing slash does not matter).
    mode string
    [Optional] When set, what mode of hive partitioning to use when reading data. The following modes are supported. (1) AUTO: automatically infer partition key name(s) and type(s). (2) STRINGS: automatically infer partition key name(s). All types are interpreted as strings. (3) CUSTOM: partition key schema is encoded in the source URI prefix. Not all storage formats support hive partitioning. Requesting hive partitioning on an unsupported format will lead to an error. Currently supported types include: AVRO, CSV, JSON, ORC and Parquet.
    requirePartitionFilter boolean
    [Optional] If set to true, queries over this table require a partition filter that can be used for partition elimination to be specified. Note that this field should only be true when creating a permanent external table or querying a temporary external table. Hive-partitioned loads with requirePartitionFilter explicitly set to true will fail.
    sourceUriPrefix string
    [Optional] When hive partition detection is requested, a common prefix for all source uris should be supplied. The prefix must end immediately before the partition key encoding begins. For example, consider files following this data layout. gs://bucket/path_to_table/dt=2019-01-01/country=BR/id=7/file.avro gs://bucket/path_to_table/dt=2018-12-31/country=CA/id=3/file.avro When hive partitioning is requested with either AUTO or STRINGS detection, the common prefix can be either of gs://bucket/path_to_table or gs://bucket/path_to_table/ (trailing slash does not matter).
    mode str
    [Optional] When set, what mode of hive partitioning to use when reading data. The following modes are supported. (1) AUTO: automatically infer partition key name(s) and type(s). (2) STRINGS: automatically infer partition key name(s). All types are interpreted as strings. (3) CUSTOM: partition key schema is encoded in the source URI prefix. Not all storage formats support hive partitioning. Requesting hive partitioning on an unsupported format will lead to an error. Currently supported types include: AVRO, CSV, JSON, ORC and Parquet.
    require_partition_filter bool
    [Optional] If set to true, queries over this table require a partition filter that can be used for partition elimination to be specified. Note that this field should only be true when creating a permanent external table or querying a temporary external table. Hive-partitioned loads with requirePartitionFilter explicitly set to true will fail.
    source_uri_prefix str
    [Optional] When hive partition detection is requested, a common prefix for all source uris should be supplied. The prefix must end immediately before the partition key encoding begins. For example, consider files following this data layout. gs://bucket/path_to_table/dt=2019-01-01/country=BR/id=7/file.avro gs://bucket/path_to_table/dt=2018-12-31/country=CA/id=3/file.avro When hive partitioning is requested with either AUTO or STRINGS detection, the common prefix can be either of gs://bucket/path_to_table or gs://bucket/path_to_table/ (trailing slash does not matter).
    mode String
    [Optional] When set, what mode of hive partitioning to use when reading data. The following modes are supported. (1) AUTO: automatically infer partition key name(s) and type(s). (2) STRINGS: automatically infer partition key name(s). All types are interpreted as strings. (3) CUSTOM: partition key schema is encoded in the source URI prefix. Not all storage formats support hive partitioning. Requesting hive partitioning on an unsupported format will lead to an error. Currently supported types include: AVRO, CSV, JSON, ORC and Parquet.
    requirePartitionFilter Boolean
    [Optional] If set to true, queries over this table require a partition filter that can be used for partition elimination to be specified. Note that this field should only be true when creating a permanent external table or querying a temporary external table. Hive-partitioned loads with requirePartitionFilter explicitly set to true will fail.
    sourceUriPrefix String
    [Optional] When hive partition detection is requested, a common prefix for all source uris should be supplied. The prefix must end immediately before the partition key encoding begins. For example, consider files following this data layout. gs://bucket/path_to_table/dt=2019-01-01/country=BR/id=7/file.avro gs://bucket/path_to_table/dt=2018-12-31/country=CA/id=3/file.avro When hive partitioning is requested with either AUTO or STRINGS detection, the common prefix can be either of gs://bucket/path_to_table or gs://bucket/path_to_table/ (trailing slash does not matter).

    HivePartitioningOptionsResponse, HivePartitioningOptionsResponseArgs

    Fields List<string>
    For permanent external tables, this field is populated with the hive partition keys in the order they were inferred. The types of the partition keys can be deduced by checking the table schema (which will include the partition keys). Not every API will populate this field in the output. For example, Tables.Get will populate it, but Tables.List will not contain this field.
    Mode string
    [Optional] When set, what mode of hive partitioning to use when reading data. The following modes are supported. (1) AUTO: automatically infer partition key name(s) and type(s). (2) STRINGS: automatically infer partition key name(s). All types are interpreted as strings. (3) CUSTOM: partition key schema is encoded in the source URI prefix. Not all storage formats support hive partitioning. Requesting hive partitioning on an unsupported format will lead to an error. Currently supported types include: AVRO, CSV, JSON, ORC and Parquet.
    RequirePartitionFilter bool
    [Optional] If set to true, queries over this table require a partition filter that can be used for partition elimination to be specified. Note that this field should only be true when creating a permanent external table or querying a temporary external table. Hive-partitioned loads with requirePartitionFilter explicitly set to true will fail.
    SourceUriPrefix string
    [Optional] When hive partition detection is requested, a common prefix for all source uris should be supplied. The prefix must end immediately before the partition key encoding begins. For example, consider files following this data layout. gs://bucket/path_to_table/dt=2019-01-01/country=BR/id=7/file.avro gs://bucket/path_to_table/dt=2018-12-31/country=CA/id=3/file.avro When hive partitioning is requested with either AUTO or STRINGS detection, the common prefix can be either of gs://bucket/path_to_table or gs://bucket/path_to_table/ (trailing slash does not matter).
    Fields []string
    For permanent external tables, this field is populated with the hive partition keys in the order they were inferred. The types of the partition keys can be deduced by checking the table schema (which will include the partition keys). Not every API will populate this field in the output. For example, Tables.Get will populate it, but Tables.List will not contain this field.
    Mode string
    [Optional] When set, what mode of hive partitioning to use when reading data. The following modes are supported. (1) AUTO: automatically infer partition key name(s) and type(s). (2) STRINGS: automatically infer partition key name(s). All types are interpreted as strings. (3) CUSTOM: partition key schema is encoded in the source URI prefix. Not all storage formats support hive partitioning. Requesting hive partitioning on an unsupported format will lead to an error. Currently supported types include: AVRO, CSV, JSON, ORC and Parquet.
    RequirePartitionFilter bool
    [Optional] If set to true, queries over this table require a partition filter that can be used for partition elimination to be specified. Note that this field should only be true when creating a permanent external table or querying a temporary external table. Hive-partitioned loads with requirePartitionFilter explicitly set to true will fail.
    SourceUriPrefix string
    [Optional] When hive partition detection is requested, a common prefix for all source uris should be supplied. The prefix must end immediately before the partition key encoding begins. For example, consider files following this data layout. gs://bucket/path_to_table/dt=2019-01-01/country=BR/id=7/file.avro gs://bucket/path_to_table/dt=2018-12-31/country=CA/id=3/file.avro When hive partitioning is requested with either AUTO or STRINGS detection, the common prefix can be either of gs://bucket/path_to_table or gs://bucket/path_to_table/ (trailing slash does not matter).
    fields List<String>
    For permanent external tables, this field is populated with the hive partition keys in the order they were inferred. The types of the partition keys can be deduced by checking the table schema (which will include the partition keys). Not every API will populate this field in the output. For example, Tables.Get will populate it, but Tables.List will not contain this field.
    mode String
    [Optional] When set, what mode of hive partitioning to use when reading data. The following modes are supported. (1) AUTO: automatically infer partition key name(s) and type(s). (2) STRINGS: automatically infer partition key name(s). All types are interpreted as strings. (3) CUSTOM: partition key schema is encoded in the source URI prefix. Not all storage formats support hive partitioning. Requesting hive partitioning on an unsupported format will lead to an error. Currently supported types include: AVRO, CSV, JSON, ORC and Parquet.
    requirePartitionFilter Boolean
    [Optional] If set to true, queries over this table require a partition filter that can be used for partition elimination to be specified. Note that this field should only be true when creating a permanent external table or querying a temporary external table. Hive-partitioned loads with requirePartitionFilter explicitly set to true will fail.
    sourceUriPrefix String
    [Optional] When hive partition detection is requested, a common prefix for all source uris should be supplied. The prefix must end immediately before the partition key encoding begins. For example, consider files following this data layout. gs://bucket/path_to_table/dt=2019-01-01/country=BR/id=7/file.avro gs://bucket/path_to_table/dt=2018-12-31/country=CA/id=3/file.avro When hive partitioning is requested with either AUTO or STRINGS detection, the common prefix can be either of gs://bucket/path_to_table or gs://bucket/path_to_table/ (trailing slash does not matter).
    fields string[]
    For permanent external tables, this field is populated with the hive partition keys in the order they were inferred. The types of the partition keys can be deduced by checking the table schema (which will include the partition keys). Not every API will populate this field in the output. For example, Tables.Get will populate it, but Tables.List will not contain this field.
    mode string
    [Optional] When set, what mode of hive partitioning to use when reading data. The following modes are supported. (1) AUTO: automatically infer partition key name(s) and type(s). (2) STRINGS: automatically infer partition key name(s). All types are interpreted as strings. (3) CUSTOM: partition key schema is encoded in the source URI prefix. Not all storage formats support hive partitioning. Requesting hive partitioning on an unsupported format will lead to an error. Currently supported types include: AVRO, CSV, JSON, ORC and Parquet.
    requirePartitionFilter boolean
    [Optional] If set to true, queries over this table require a partition filter that can be used for partition elimination to be specified. Note that this field should only be true when creating a permanent external table or querying a temporary external table. Hive-partitioned loads with requirePartitionFilter explicitly set to true will fail.
    sourceUriPrefix string
    [Optional] When hive partition detection is requested, a common prefix for all source uris should be supplied. The prefix must end immediately before the partition key encoding begins. For example, consider files following this data layout. gs://bucket/path_to_table/dt=2019-01-01/country=BR/id=7/file.avro gs://bucket/path_to_table/dt=2018-12-31/country=CA/id=3/file.avro When hive partitioning is requested with either AUTO or STRINGS detection, the common prefix can be either of gs://bucket/path_to_table or gs://bucket/path_to_table/ (trailing slash does not matter).
    fields Sequence[str]
    For permanent external tables, this field is populated with the hive partition keys in the order they were inferred. The types of the partition keys can be deduced by checking the table schema (which will include the partition keys). Not every API will populate this field in the output. For example, Tables.Get will populate it, but Tables.List will not contain this field.
    mode str
    [Optional] When set, what mode of hive partitioning to use when reading data. The following modes are supported. (1) AUTO: automatically infer partition key name(s) and type(s). (2) STRINGS: automatically infer partition key name(s). All types are interpreted as strings. (3) CUSTOM: partition key schema is encoded in the source URI prefix. Not all storage formats support hive partitioning. Requesting hive partitioning on an unsupported format will lead to an error. Currently supported types include: AVRO, CSV, JSON, ORC and Parquet.
    require_partition_filter bool
    [Optional] If set to true, queries over this table require a partition filter that can be used for partition elimination to be specified. Note that this field should only be true when creating a permanent external table or querying a temporary external table. Hive-partitioned loads with requirePartitionFilter explicitly set to true will fail.
    source_uri_prefix str
    [Optional] When hive partition detection is requested, a common prefix for all source uris should be supplied. The prefix must end immediately before the partition key encoding begins. For example, consider files following this data layout. gs://bucket/path_to_table/dt=2019-01-01/country=BR/id=7/file.avro gs://bucket/path_to_table/dt=2018-12-31/country=CA/id=3/file.avro When hive partitioning is requested with either AUTO or STRINGS detection, the common prefix can be either of gs://bucket/path_to_table or gs://bucket/path_to_table/ (trailing slash does not matter).
    fields List<String>
    For permanent external tables, this field is populated with the hive partition keys in the order they were inferred. The types of the partition keys can be deduced by checking the table schema (which will include the partition keys). Not every API will populate this field in the output. For example, Tables.Get will populate it, but Tables.List will not contain this field.
    mode String
    [Optional] When set, what mode of hive partitioning to use when reading data. The following modes are supported. (1) AUTO: automatically infer partition key name(s) and type(s). (2) STRINGS: automatically infer partition key name(s). All types are interpreted as strings. (3) CUSTOM: partition key schema is encoded in the source URI prefix. Not all storage formats support hive partitioning. Requesting hive partitioning on an unsupported format will lead to an error. Currently supported types include: AVRO, CSV, JSON, ORC and Parquet.
    requirePartitionFilter Boolean
    [Optional] If set to true, queries over this table require a partition filter that can be used for partition elimination to be specified. Note that this field should only be true when creating a permanent external table or querying a temporary external table. Hive-partitioned loads with requirePartitionFilter explicitly set to true will fail.
    sourceUriPrefix String
    [Optional] When hive partition detection is requested, a common prefix for all source uris should be supplied. The prefix must end immediately before the partition key encoding begins. For example, consider files following this data layout. gs://bucket/path_to_table/dt=2019-01-01/country=BR/id=7/file.avro gs://bucket/path_to_table/dt=2018-12-31/country=CA/id=3/file.avro When hive partitioning is requested with either AUTO or STRINGS detection, the common prefix can be either of gs://bucket/path_to_table or gs://bucket/path_to_table/ (trailing slash does not matter).

    IndexUnusedReasonResponse, IndexUnusedReasonResponseArgs

    BaseTable Pulumi.GoogleNative.BigQuery.V2.Inputs.TableReferenceResponse
    Specifies the base table involved in the reason that no search index was used.
    Code string
    Specifies the high-level reason for the scenario when no search index was used.
    IndexName string
    Specifies the name of the unused search index, if available.
    Message string
    Free form human-readable reason for the scenario when no search index was used.
    BaseTable TableReferenceResponse
    Specifies the base table involved in the reason that no search index was used.
    Code string
    Specifies the high-level reason for the scenario when no search index was used.
    IndexName string
    Specifies the name of the unused search index, if available.
    Message string
    Free form human-readable reason for the scenario when no search index was used.
    baseTable TableReferenceResponse
    Specifies the base table involved in the reason that no search index was used.
    code String
    Specifies the high-level reason for the scenario when no search index was used.
    indexName String
    Specifies the name of the unused search index, if available.
    message String
    Free form human-readable reason for the scenario when no search index was used.
    baseTable TableReferenceResponse
    Specifies the base table involved in the reason that no search index was used.
    code string
    Specifies the high-level reason for the scenario when no search index was used.
    indexName string
    Specifies the name of the unused search index, if available.
    message string
    Free form human-readable reason for the scenario when no search index was used.
    base_table TableReferenceResponse
    Specifies the base table involved in the reason that no search index was used.
    code str
    Specifies the high-level reason for the scenario when no search index was used.
    index_name str
    Specifies the name of the unused search index, if available.
    message str
    Free form human-readable reason for the scenario when no search index was used.
    baseTable Property Map
    Specifies the base table involved in the reason that no search index was used.
    code String
    Specifies the high-level reason for the scenario when no search index was used.
    indexName String
    Specifies the name of the unused search index, if available.
    message String
    Free form human-readable reason for the scenario when no search index was used.

    IterationResultResponse, IterationResultResponseArgs

    DurationMs string
    Time taken to run the iteration in milliseconds.
    EvalLoss double
    Loss computed on the eval data at the end of iteration.
    Index int
    Index of the iteration, 0 based.
    LearnRate double
    Learn rate used for this iteration.
    TrainingLoss double
    Loss computed on the training data at the end of iteration.
    DurationMs string
    Time taken to run the iteration in milliseconds.
    EvalLoss float64
    Loss computed on the eval data at the end of iteration.
    Index int
    Index of the iteration, 0 based.
    LearnRate float64
    Learn rate used for this iteration.
    TrainingLoss float64
    Loss computed on the training data at the end of iteration.
    durationMs String
    Time taken to run the iteration in milliseconds.
    evalLoss Double
    Loss computed on the eval data at the end of iteration.
    index Integer
    Index of the iteration, 0 based.
    learnRate Double
    Learn rate used for this iteration.
    trainingLoss Double
    Loss computed on the training data at the end of iteration.
    durationMs string
    Time taken to run the iteration in milliseconds.
    evalLoss number
    Loss computed on the eval data at the end of iteration.
    index number
    Index of the iteration, 0 based.
    learnRate number
    Learn rate used for this iteration.
    trainingLoss number
    Loss computed on the training data at the end of iteration.
    duration_ms str
    Time taken to run the iteration in milliseconds.
    eval_loss float
    Loss computed on the eval data at the end of iteration.
    index int
    Index of the iteration, 0 based.
    learn_rate float
    Learn rate used for this iteration.
    training_loss float
    Loss computed on the training data at the end of iteration.
    durationMs String
    Time taken to run the iteration in milliseconds.
    evalLoss Number
    Loss computed on the eval data at the end of iteration.
    index Number
    Index of the iteration, 0 based.
    learnRate Number
    Learn rate used for this iteration.
    trainingLoss Number
    Loss computed on the training data at the end of iteration.

    JobConfiguration, JobConfigurationArgs

    Copy Pulumi.GoogleNative.BigQuery.V2.Inputs.JobConfigurationTableCopy
    [Pick one] Copies a table.
    DryRun bool
    [Optional] If set, don't actually run this job. A valid query will return a mostly empty response with some processing statistics, while an invalid query will return the same error it would if it wasn't a dry run. Behavior of non-query jobs is undefined.
    Extract Pulumi.GoogleNative.BigQuery.V2.Inputs.JobConfigurationExtract
    [Pick one] Configures an extract job.
    JobTimeoutMs string
    [Optional] Job timeout in milliseconds. If this time limit is exceeded, BigQuery may attempt to terminate the job.
    Labels Dictionary<string, string>
    The labels associated with this job. You can use these to organize and group your jobs. Label keys and values can be no longer than 63 characters, can only contain lowercase letters, numeric characters, underscores and dashes. International characters are allowed. Label values are optional. Label keys must start with a letter and each label in the list must have a different key.
    Load Pulumi.GoogleNative.BigQuery.V2.Inputs.JobConfigurationLoad
    [Pick one] Configures a load job.
    Query Pulumi.GoogleNative.BigQuery.V2.Inputs.JobConfigurationQuery
    [Pick one] Configures a query job.
    Copy JobConfigurationTableCopy
    [Pick one] Copies a table.
    DryRun bool
    [Optional] If set, don't actually run this job. A valid query will return a mostly empty response with some processing statistics, while an invalid query will return the same error it would if it wasn't a dry run. Behavior of non-query jobs is undefined.
    Extract JobConfigurationExtract
    [Pick one] Configures an extract job.
    JobTimeoutMs string
    [Optional] Job timeout in milliseconds. If this time limit is exceeded, BigQuery may attempt to terminate the job.
    Labels map[string]string
    The labels associated with this job. You can use these to organize and group your jobs. Label keys and values can be no longer than 63 characters, can only contain lowercase letters, numeric characters, underscores and dashes. International characters are allowed. Label values are optional. Label keys must start with a letter and each label in the list must have a different key.
    Load JobConfigurationLoad
    [Pick one] Configures a load job.
    Query JobConfigurationQuery
    [Pick one] Configures a query job.
    copy JobConfigurationTableCopy
    [Pick one] Copies a table.
    dryRun Boolean
    [Optional] If set, don't actually run this job. A valid query will return a mostly empty response with some processing statistics, while an invalid query will return the same error it would if it wasn't a dry run. Behavior of non-query jobs is undefined.
    extract JobConfigurationExtract
    [Pick one] Configures an extract job.
    jobTimeoutMs String
    [Optional] Job timeout in milliseconds. If this time limit is exceeded, BigQuery may attempt to terminate the job.
    labels Map<String,String>
    The labels associated with this job. You can use these to organize and group your jobs. Label keys and values can be no longer than 63 characters, can only contain lowercase letters, numeric characters, underscores and dashes. International characters are allowed. Label values are optional. Label keys must start with a letter and each label in the list must have a different key.
    load JobConfigurationLoad
    [Pick one] Configures a load job.
    query JobConfigurationQuery
    [Pick one] Configures a query job.
    copy JobConfigurationTableCopy
    [Pick one] Copies a table.
    dryRun boolean
    [Optional] If set, don't actually run this job. A valid query will return a mostly empty response with some processing statistics, while an invalid query will return the same error it would if it wasn't a dry run. Behavior of non-query jobs is undefined.
    extract JobConfigurationExtract
    [Pick one] Configures an extract job.
    jobTimeoutMs string
    [Optional] Job timeout in milliseconds. If this time limit is exceeded, BigQuery may attempt to terminate the job.
    labels {[key: string]: string}
    The labels associated with this job. You can use these to organize and group your jobs. Label keys and values can be no longer than 63 characters, can only contain lowercase letters, numeric characters, underscores and dashes. International characters are allowed. Label values are optional. Label keys must start with a letter and each label in the list must have a different key.
    load JobConfigurationLoad
    [Pick one] Configures a load job.
    query JobConfigurationQuery
    [Pick one] Configures a query job.
    copy JobConfigurationTableCopy
    [Pick one] Copies a table.
    dry_run bool
    [Optional] If set, don't actually run this job. A valid query will return a mostly empty response with some processing statistics, while an invalid query will return the same error it would if it wasn't a dry run. Behavior of non-query jobs is undefined.
    extract JobConfigurationExtract
    [Pick one] Configures an extract job.
    job_timeout_ms str
    [Optional] Job timeout in milliseconds. If this time limit is exceeded, BigQuery may attempt to terminate the job.
    labels Mapping[str, str]
    The labels associated with this job. You can use these to organize and group your jobs. Label keys and values can be no longer than 63 characters, can only contain lowercase letters, numeric characters, underscores and dashes. International characters are allowed. Label values are optional. Label keys must start with a letter and each label in the list must have a different key.
    load JobConfigurationLoad
    [Pick one] Configures a load job.
    query JobConfigurationQuery
    [Pick one] Configures a query job.
    copy Property Map
    [Pick one] Copies a table.
    dryRun Boolean
    [Optional] If set, don't actually run this job. A valid query will return a mostly empty response with some processing statistics, while an invalid query will return the same error it would if it wasn't a dry run. Behavior of non-query jobs is undefined.
    extract Property Map
    [Pick one] Configures an extract job.
    jobTimeoutMs String
    [Optional] Job timeout in milliseconds. If this time limit is exceeded, BigQuery may attempt to terminate the job.
    labels Map<String>
    The labels associated with this job. You can use these to organize and group your jobs. Label keys and values can be no longer than 63 characters, can only contain lowercase letters, numeric characters, underscores and dashes. International characters are allowed. Label values are optional. Label keys must start with a letter and each label in the list must have a different key.
    load Property Map
    [Pick one] Configures a load job.
    query Property Map
    [Pick one] Configures a query job.

    JobConfigurationExtract, JobConfigurationExtractArgs

    Compression string
    [Optional] The compression type to use for exported files. Possible values include GZIP, DEFLATE, SNAPPY, and NONE. The default value is NONE. DEFLATE and SNAPPY are only supported for Avro. Not applicable when extracting models.
    DestinationFormat string
    [Optional] The exported file format. Possible values include CSV, NEWLINE_DELIMITED_JSON, PARQUET or AVRO for tables and ML_TF_SAVED_MODEL or ML_XGBOOST_BOOSTER for models. The default value for tables is CSV. Tables with nested or repeated fields cannot be exported as CSV. The default value for models is ML_TF_SAVED_MODEL.
    DestinationUri string
    [Pick one] DEPRECATED: Use destinationUris instead, passing only one URI as necessary. The fully-qualified Google Cloud Storage URI where the extracted table should be written.
    DestinationUris List<string>
    [Pick one] A list of fully-qualified Google Cloud Storage URIs where the extracted table should be written.
    FieldDelimiter string
    [Optional] Delimiter to use between fields in the exported data. Default is ','. Not applicable when extracting models.
    PrintHeader bool
    [Optional] Whether to print out a header row in the results. Default is true. Not applicable when extracting models.
    SourceModel Pulumi.GoogleNative.BigQuery.V2.Inputs.ModelReference
    A reference to the model being exported.
    SourceTable Pulumi.GoogleNative.BigQuery.V2.Inputs.TableReference
    A reference to the table being exported.
    UseAvroLogicalTypes bool
    [Optional] If destinationFormat is set to "AVRO", this flag indicates whether to enable extracting applicable column types (such as TIMESTAMP) to their corresponding AVRO logical types (timestamp-micros), instead of only using their raw types (avro-long). Not applicable when extracting models.
    Compression string
    [Optional] The compression type to use for exported files. Possible values include GZIP, DEFLATE, SNAPPY, and NONE. The default value is NONE. DEFLATE and SNAPPY are only supported for Avro. Not applicable when extracting models.
    DestinationFormat string
    [Optional] The exported file format. Possible values include CSV, NEWLINE_DELIMITED_JSON, PARQUET or AVRO for tables and ML_TF_SAVED_MODEL or ML_XGBOOST_BOOSTER for models. The default value for tables is CSV. Tables with nested or repeated fields cannot be exported as CSV. The default value for models is ML_TF_SAVED_MODEL.
    DestinationUri string
    [Pick one] DEPRECATED: Use destinationUris instead, passing only one URI as necessary. The fully-qualified Google Cloud Storage URI where the extracted table should be written.
    DestinationUris []string
    [Pick one] A list of fully-qualified Google Cloud Storage URIs where the extracted table should be written.
    FieldDelimiter string
    [Optional] Delimiter to use between fields in the exported data. Default is ','. Not applicable when extracting models.
    PrintHeader bool
    [Optional] Whether to print out a header row in the results. Default is true. Not applicable when extracting models.
    SourceModel ModelReference
    A reference to the model being exported.
    SourceTable TableReference
    A reference to the table being exported.
    UseAvroLogicalTypes bool
    [Optional] If destinationFormat is set to "AVRO", this flag indicates whether to enable extracting applicable column types (such as TIMESTAMP) to their corresponding AVRO logical types (timestamp-micros), instead of only using their raw types (avro-long). Not applicable when extracting models.
    compression String
    [Optional] The compression type to use for exported files. Possible values include GZIP, DEFLATE, SNAPPY, and NONE. The default value is NONE. DEFLATE and SNAPPY are only supported for Avro. Not applicable when extracting models.
    destinationFormat String
    [Optional] The exported file format. Possible values include CSV, NEWLINE_DELIMITED_JSON, PARQUET or AVRO for tables and ML_TF_SAVED_MODEL or ML_XGBOOST_BOOSTER for models. The default value for tables is CSV. Tables with nested or repeated fields cannot be exported as CSV. The default value for models is ML_TF_SAVED_MODEL.
    destinationUri String
    [Pick one] DEPRECATED: Use destinationUris instead, passing only one URI as necessary. The fully-qualified Google Cloud Storage URI where the extracted table should be written.
    destinationUris List<String>
    [Pick one] A list of fully-qualified Google Cloud Storage URIs where the extracted table should be written.
    fieldDelimiter String
    [Optional] Delimiter to use between fields in the exported data. Default is ','. Not applicable when extracting models.
    printHeader Boolean
    [Optional] Whether to print out a header row in the results. Default is true. Not applicable when extracting models.
    sourceModel ModelReference
    A reference to the model being exported.
    sourceTable TableReference
    A reference to the table being exported.
    useAvroLogicalTypes Boolean
    [Optional] If destinationFormat is set to "AVRO", this flag indicates whether to enable extracting applicable column types (such as TIMESTAMP) to their corresponding AVRO logical types (timestamp-micros), instead of only using their raw types (avro-long). Not applicable when extracting models.
    compression string
    [Optional] The compression type to use for exported files. Possible values include GZIP, DEFLATE, SNAPPY, and NONE. The default value is NONE. DEFLATE and SNAPPY are only supported for Avro. Not applicable when extracting models.
    destinationFormat string
    [Optional] The exported file format. Possible values include CSV, NEWLINE_DELIMITED_JSON, PARQUET or AVRO for tables and ML_TF_SAVED_MODEL or ML_XGBOOST_BOOSTER for models. The default value for tables is CSV. Tables with nested or repeated fields cannot be exported as CSV. The default value for models is ML_TF_SAVED_MODEL.
    destinationUri string
    [Pick one] DEPRECATED: Use destinationUris instead, passing only one URI as necessary. The fully-qualified Google Cloud Storage URI where the extracted table should be written.
    destinationUris string[]
    [Pick one] A list of fully-qualified Google Cloud Storage URIs where the extracted table should be written.
    fieldDelimiter string
    [Optional] Delimiter to use between fields in the exported data. Default is ','. Not applicable when extracting models.
    printHeader boolean
    [Optional] Whether to print out a header row in the results. Default is true. Not applicable when extracting models.
    sourceModel ModelReference
    A reference to the model being exported.
    sourceTable TableReference
    A reference to the table being exported.
    useAvroLogicalTypes boolean
    [Optional] If destinationFormat is set to "AVRO", this flag indicates whether to enable extracting applicable column types (such as TIMESTAMP) to their corresponding AVRO logical types (timestamp-micros), instead of only using their raw types (avro-long). Not applicable when extracting models.
    compression str
    [Optional] The compression type to use for exported files. Possible values include GZIP, DEFLATE, SNAPPY, and NONE. The default value is NONE. DEFLATE and SNAPPY are only supported for Avro. Not applicable when extracting models.
    destination_format str
    [Optional] The exported file format. Possible values include CSV, NEWLINE_DELIMITED_JSON, PARQUET or AVRO for tables and ML_TF_SAVED_MODEL or ML_XGBOOST_BOOSTER for models. The default value for tables is CSV. Tables with nested or repeated fields cannot be exported as CSV. The default value for models is ML_TF_SAVED_MODEL.
    destination_uri str
    [Pick one] DEPRECATED: Use destinationUris instead, passing only one URI as necessary. The fully-qualified Google Cloud Storage URI where the extracted table should be written.
    destination_uris Sequence[str]
    [Pick one] A list of fully-qualified Google Cloud Storage URIs where the extracted table should be written.
    field_delimiter str
    [Optional] Delimiter to use between fields in the exported data. Default is ','. Not applicable when extracting models.
    print_header bool
    [Optional] Whether to print out a header row in the results. Default is true. Not applicable when extracting models.
    source_model ModelReference
    A reference to the model being exported.
    source_table TableReference
    A reference to the table being exported.
    use_avro_logical_types bool
    [Optional] If destinationFormat is set to "AVRO", this flag indicates whether to enable extracting applicable column types (such as TIMESTAMP) to their corresponding AVRO logical types (timestamp-micros), instead of only using their raw types (avro-long). Not applicable when extracting models.
    compression String
    [Optional] The compression type to use for exported files. Possible values include GZIP, DEFLATE, SNAPPY, and NONE. The default value is NONE. DEFLATE and SNAPPY are only supported for Avro. Not applicable when extracting models.
    destinationFormat String
    [Optional] The exported file format. Possible values include CSV, NEWLINE_DELIMITED_JSON, PARQUET or AVRO for tables and ML_TF_SAVED_MODEL or ML_XGBOOST_BOOSTER for models. The default value for tables is CSV. Tables with nested or repeated fields cannot be exported as CSV. The default value for models is ML_TF_SAVED_MODEL.
    destinationUri String
    [Pick one] DEPRECATED: Use destinationUris instead, passing only one URI as necessary. The fully-qualified Google Cloud Storage URI where the extracted table should be written.
    destinationUris List<String>
    [Pick one] A list of fully-qualified Google Cloud Storage URIs where the extracted table should be written.
    fieldDelimiter String
    [Optional] Delimiter to use between fields in the exported data. Default is ','. Not applicable when extracting models.
    printHeader Boolean
    [Optional] Whether to print out a header row in the results. Default is true. Not applicable when extracting models.
    sourceModel Property Map
    A reference to the model being exported.
    sourceTable Property Map
    A reference to the table being exported.
    useAvroLogicalTypes Boolean
    [Optional] If destinationFormat is set to "AVRO", this flag indicates whether to enable extracting applicable column types (such as TIMESTAMP) to their corresponding AVRO logical types (timestamp-micros), instead of only using their raw types (avro-long). Not applicable when extracting models.

    JobConfigurationExtractResponse, JobConfigurationExtractResponseArgs

    Compression string
    [Optional] The compression type to use for exported files. Possible values include GZIP, DEFLATE, SNAPPY, and NONE. The default value is NONE. DEFLATE and SNAPPY are only supported for Avro. Not applicable when extracting models.
    DestinationFormat string
    [Optional] The exported file format. Possible values include CSV, NEWLINE_DELIMITED_JSON, PARQUET or AVRO for tables and ML_TF_SAVED_MODEL or ML_XGBOOST_BOOSTER for models. The default value for tables is CSV. Tables with nested or repeated fields cannot be exported as CSV. The default value for models is ML_TF_SAVED_MODEL.
    DestinationUri string
    [Pick one] DEPRECATED: Use destinationUris instead, passing only one URI as necessary. The fully-qualified Google Cloud Storage URI where the extracted table should be written.
    DestinationUris List<string>
    [Pick one] A list of fully-qualified Google Cloud Storage URIs where the extracted table should be written.
    FieldDelimiter string
    [Optional] Delimiter to use between fields in the exported data. Default is ','. Not applicable when extracting models.
    PrintHeader bool
    [Optional] Whether to print out a header row in the results. Default is true. Not applicable when extracting models.
    SourceModel Pulumi.GoogleNative.BigQuery.V2.Inputs.ModelReferenceResponse
    A reference to the model being exported.
    SourceTable Pulumi.GoogleNative.BigQuery.V2.Inputs.TableReferenceResponse
    A reference to the table being exported.
    UseAvroLogicalTypes bool
    [Optional] If destinationFormat is set to "AVRO", this flag indicates whether to enable extracting applicable column types (such as TIMESTAMP) to their corresponding AVRO logical types (timestamp-micros), instead of only using their raw types (avro-long). Not applicable when extracting models.
    Compression string
    [Optional] The compression type to use for exported files. Possible values include GZIP, DEFLATE, SNAPPY, and NONE. The default value is NONE. DEFLATE and SNAPPY are only supported for Avro. Not applicable when extracting models.
    DestinationFormat string
    [Optional] The exported file format. Possible values include CSV, NEWLINE_DELIMITED_JSON, PARQUET or AVRO for tables and ML_TF_SAVED_MODEL or ML_XGBOOST_BOOSTER for models. The default value for tables is CSV. Tables with nested or repeated fields cannot be exported as CSV. The default value for models is ML_TF_SAVED_MODEL.
    DestinationUri string
    [Pick one] DEPRECATED: Use destinationUris instead, passing only one URI as necessary. The fully-qualified Google Cloud Storage URI where the extracted table should be written.
    DestinationUris []string
    [Pick one] A list of fully-qualified Google Cloud Storage URIs where the extracted table should be written.
    FieldDelimiter string
    [Optional] Delimiter to use between fields in the exported data. Default is ','. Not applicable when extracting models.
    PrintHeader bool
    [Optional] Whether to print out a header row in the results. Default is true. Not applicable when extracting models.
    SourceModel ModelReferenceResponse
    A reference to the model being exported.
    SourceTable TableReferenceResponse
    A reference to the table being exported.
    UseAvroLogicalTypes bool
    [Optional] If destinationFormat is set to "AVRO", this flag indicates whether to enable extracting applicable column types (such as TIMESTAMP) to their corresponding AVRO logical types (timestamp-micros), instead of only using their raw types (avro-long). Not applicable when extracting models.
    compression String
    [Optional] The compression type to use for exported files. Possible values include GZIP, DEFLATE, SNAPPY, and NONE. The default value is NONE. DEFLATE and SNAPPY are only supported for Avro. Not applicable when extracting models.
    destinationFormat String
    [Optional] The exported file format. Possible values include CSV, NEWLINE_DELIMITED_JSON, PARQUET or AVRO for tables and ML_TF_SAVED_MODEL or ML_XGBOOST_BOOSTER for models. The default value for tables is CSV. Tables with nested or repeated fields cannot be exported as CSV. The default value for models is ML_TF_SAVED_MODEL.
    destinationUri String
    [Pick one] DEPRECATED: Use destinationUris instead, passing only one URI as necessary. The fully-qualified Google Cloud Storage URI where the extracted table should be written.
    destinationUris List<String>
    [Pick one] A list of fully-qualified Google Cloud Storage URIs where the extracted table should be written.
    fieldDelimiter String
    [Optional] Delimiter to use between fields in the exported data. Default is ','. Not applicable when extracting models.
    printHeader Boolean
    [Optional] Whether to print out a header row in the results. Default is true. Not applicable when extracting models.
    sourceModel ModelReferenceResponse
    A reference to the model being exported.
    sourceTable TableReferenceResponse
    A reference to the table being exported.
    useAvroLogicalTypes Boolean
    [Optional] If destinationFormat is set to "AVRO", this flag indicates whether to enable extracting applicable column types (such as TIMESTAMP) to their corresponding AVRO logical types (timestamp-micros), instead of only using their raw types (avro-long). Not applicable when extracting models.
    compression string
    [Optional] The compression type to use for exported files. Possible values include GZIP, DEFLATE, SNAPPY, and NONE. The default value is NONE. DEFLATE and SNAPPY are only supported for Avro. Not applicable when extracting models.
    destinationFormat string
    [Optional] The exported file format. Possible values include CSV, NEWLINE_DELIMITED_JSON, PARQUET or AVRO for tables and ML_TF_SAVED_MODEL or ML_XGBOOST_BOOSTER for models. The default value for tables is CSV. Tables with nested or repeated fields cannot be exported as CSV. The default value for models is ML_TF_SAVED_MODEL.
    destinationUri string
    [Pick one] DEPRECATED: Use destinationUris instead, passing only one URI as necessary. The fully-qualified Google Cloud Storage URI where the extracted table should be written.
    destinationUris string[]
    [Pick one] A list of fully-qualified Google Cloud Storage URIs where the extracted table should be written.
    fieldDelimiter string
    [Optional] Delimiter to use between fields in the exported data. Default is ','. Not applicable when extracting models.
    printHeader boolean
    [Optional] Whether to print out a header row in the results. Default is true. Not applicable when extracting models.
    sourceModel ModelReferenceResponse
    A reference to the model being exported.
    sourceTable TableReferenceResponse
    A reference to the table being exported.
    useAvroLogicalTypes boolean
    [Optional] If destinationFormat is set to "AVRO", this flag indicates whether to enable extracting applicable column types (such as TIMESTAMP) to their corresponding AVRO logical types (timestamp-micros), instead of only using their raw types (avro-long). Not applicable when extracting models.
    compression str
    [Optional] The compression type to use for exported files. Possible values include GZIP, DEFLATE, SNAPPY, and NONE. The default value is NONE. DEFLATE and SNAPPY are only supported for Avro. Not applicable when extracting models.
    destination_format str
    [Optional] The exported file format. Possible values include CSV, NEWLINE_DELIMITED_JSON, PARQUET or AVRO for tables and ML_TF_SAVED_MODEL or ML_XGBOOST_BOOSTER for models. The default value for tables is CSV. Tables with nested or repeated fields cannot be exported as CSV. The default value for models is ML_TF_SAVED_MODEL.
    destination_uri str
    [Pick one] DEPRECATED: Use destinationUris instead, passing only one URI as necessary. The fully-qualified Google Cloud Storage URI where the extracted table should be written.
    destination_uris Sequence[str]
    [Pick one] A list of fully-qualified Google Cloud Storage URIs where the extracted table should be written.
    field_delimiter str
    [Optional] Delimiter to use between fields in the exported data. Default is ','. Not applicable when extracting models.
    print_header bool
    [Optional] Whether to print out a header row in the results. Default is true. Not applicable when extracting models.
    source_model ModelReferenceResponse
    A reference to the model being exported.
    source_table TableReferenceResponse
    A reference to the table being exported.
    use_avro_logical_types bool
    [Optional] If destinationFormat is set to "AVRO", this flag indicates whether to enable extracting applicable column types (such as TIMESTAMP) to their corresponding AVRO logical types (timestamp-micros), instead of only using their raw types (avro-long). Not applicable when extracting models.
    compression String
    [Optional] The compression type to use for exported files. Possible values include GZIP, DEFLATE, SNAPPY, and NONE. The default value is NONE. DEFLATE and SNAPPY are only supported for Avro. Not applicable when extracting models.
    destinationFormat String
    [Optional] The exported file format. Possible values include CSV, NEWLINE_DELIMITED_JSON, PARQUET or AVRO for tables and ML_TF_SAVED_MODEL or ML_XGBOOST_BOOSTER for models. The default value for tables is CSV. Tables with nested or repeated fields cannot be exported as CSV. The default value for models is ML_TF_SAVED_MODEL.
    destinationUri String
    [Pick one] DEPRECATED: Use destinationUris instead, passing only one URI as necessary. The fully-qualified Google Cloud Storage URI where the extracted table should be written.
    destinationUris List<String>
    [Pick one] A list of fully-qualified Google Cloud Storage URIs where the extracted table should be written.
    fieldDelimiter String
    [Optional] Delimiter to use between fields in the exported data. Default is ','. Not applicable when extracting models.
    printHeader Boolean
    [Optional] Whether to print out a header row in the results. Default is true. Not applicable when extracting models.
    sourceModel Property Map
    A reference to the model being exported.
    sourceTable Property Map
    A reference to the table being exported.
    useAvroLogicalTypes Boolean
    [Optional] If destinationFormat is set to "AVRO", this flag indicates whether to enable extracting applicable column types (such as TIMESTAMP) to their corresponding AVRO logical types (timestamp-micros), instead of only using their raw types (avro-long). Not applicable when extracting models.

    JobConfigurationLoad, JobConfigurationLoadArgs

    AllowJaggedRows bool
    [Optional] Accept rows that are missing trailing optional columns. The missing values are treated as nulls. If false, records with missing trailing 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. Only applicable to CSV, ignored for other formats.
    AllowQuotedNewlines bool
    Indicates if BigQuery should allow quoted data sections that contain newline characters in a CSV file. The default value is false.
    Autodetect bool
    [Optional] Indicates if we should automatically infer the options and schema for CSV and JSON sources.
    Clustering Pulumi.GoogleNative.BigQuery.V2.Inputs.Clustering
    [Beta] Clustering specification for the destination table. Must be specified with time-based partitioning, data in the table will be first partitioned and subsequently clustered.
    ConnectionProperties List<Pulumi.GoogleNative.BigQuery.V2.Inputs.ConnectionProperty>
    Connection properties.
    CreateDisposition string
    [Optional] Specifies whether the job is allowed to create new tables. The following values are supported: CREATE_IF_NEEDED: If the table does not exist, BigQuery creates the table. CREATE_NEVER: The table must already exist. If it does not, a 'notFound' error is returned in the job result. The default value is CREATE_IF_NEEDED. Creation, truncation and append actions occur as one atomic update upon job completion.
    CreateSession bool
    If true, creates a new session, where session id will be a server generated random id. If false, runs query with an existing session_id passed in ConnectionProperty, otherwise runs the load job in non-session mode.
    DecimalTargetTypes List<string>
    [Optional] 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. Example: Suppose the value of this field is ["NUMERIC", "BIGNUMERIC"]. If (precision,scale) is: (38,9) -> NUMERIC; (39,9) -> BIGNUMERIC (NUMERIC cannot hold 30 integer digits); (38,10) -> BIGNUMERIC (NUMERIC cannot hold 10 fractional digits); (76,38) -> BIGNUMERIC; (77,38) -> BIGNUMERIC (error if value exeeds supported range). This field cannot contain duplicate types. The order of the types in this field is ignored. For example, ["BIGNUMERIC", "NUMERIC"] is the same as ["NUMERIC", "BIGNUMERIC"] and NUMERIC always takes precedence over BIGNUMERIC. Defaults to ["NUMERIC", "STRING"] for ORC and ["NUMERIC"] for the other file formats.
    DestinationEncryptionConfiguration Pulumi.GoogleNative.BigQuery.V2.Inputs.EncryptionConfiguration
    Custom encryption configuration (e.g., Cloud KMS keys).
    DestinationTable Pulumi.GoogleNative.BigQuery.V2.Inputs.TableReference
    [Required] The destination table to load the data into.
    DestinationTableProperties Pulumi.GoogleNative.BigQuery.V2.Inputs.DestinationTableProperties
    [Beta] [Optional] Properties with which to create the destination table if it is new.
    Encoding string
    [Optional] The character encoding of the data. The supported values are UTF-8 or ISO-8859-1. The default value is UTF-8. BigQuery decodes the data after the raw, binary data has been split using the values of the quote and fieldDelimiter properties.
    FieldDelimiter string
    [Optional] The separator for fields in a CSV file. The separator can be any ISO-8859-1 single-byte character. To use a character in the range 128-255, you must encode the character as UTF8. BigQuery converts the string to ISO-8859-1 encoding, and then uses the first byte of the encoded string to split the data in its raw, binary state. BigQuery also supports the escape sequence "\t" to specify a tab separator. The default value is a comma (',').
    FileSetSpecType string
    [Optional] Specifies how source URIs are interpreted for constructing the file set to load. By default source URIs are expanded against the underlying storage. Other options include specifying manifest files. Only applicable to object storage systems.
    HivePartitioningOptions Pulumi.GoogleNative.BigQuery.V2.Inputs.HivePartitioningOptions
    [Optional] Options to configure hive partitioning support.
    IgnoreUnknownValues bool
    [Optional] 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. The sourceFormat property determines what BigQuery treats as an extra value: CSV: Trailing columns JSON: Named values that don't match any column names
    JsonExtension string
    [Optional] If sourceFormat is set to newline-delimited JSON, indicates whether it should be processed as a JSON variant such as GeoJSON. For a sourceFormat other than JSON, omit this field. If the sourceFormat is newline-delimited JSON: - for newline-delimited GeoJSON: set to GEOJSON.
    MaxBadRecords int
    [Optional] The maximum number of bad records that BigQuery can ignore when running the job. If the number of bad records exceeds this value, an invalid error is returned in the job result. This is only valid for CSV and JSON. The default value is 0, which requires that all records are valid.
    NullMarker string
    [Optional] Specifies a string that represents a null value in a CSV file. For example, if you specify "\N", BigQuery interprets "\N" as a null value when loading a CSV file. The default value is the empty string. If you set this property to a custom value, BigQuery throws an error if an empty string is present for all data types except for STRING and BYTE. For STRING and BYTE columns, BigQuery interprets the empty string as an empty value.
    ParquetOptions Pulumi.GoogleNative.BigQuery.V2.Inputs.ParquetOptions
    [Optional] Options to configure parquet support.
    PreserveAsciiControlCharacters bool
    [Optional] Preserves the embedded ASCII control characters (the first 32 characters in the ASCII-table, from '\x00' to '\x1F') when loading from CSV. Only applicable to CSV, ignored for other formats.
    ProjectionFields List<string>
    If sourceFormat is set to "DATASTORE_BACKUP", indicates which entity properties to load into BigQuery from a Cloud Datastore backup. Property names are case sensitive and must be top-level properties. If no properties are specified, BigQuery loads all properties. If any named property isn't found in the Cloud Datastore backup, an invalid error is returned in the job result.
    Quote string
    [Optional] The value that is used to quote data sections in a CSV file. BigQuery converts the string to ISO-8859-1 encoding, and then uses the first byte of the encoded string to split the data in its raw, binary state. The default value is a double-quote ('"'). If your data does not contain quoted sections, set the property value to an empty string. If your data contains quoted newline characters, you must also set the allowQuotedNewlines property to true.
    RangePartitioning Pulumi.GoogleNative.BigQuery.V2.Inputs.RangePartitioning
    [TrustedTester] Range partitioning specification for this table. Only one of timePartitioning and rangePartitioning should be specified.
    ReferenceFileSchemaUri string
    User provided referencing file with the expected reader schema, Available for the format: AVRO, PARQUET, ORC.
    Schema Pulumi.GoogleNative.BigQuery.V2.Inputs.TableSchema
    [Optional] The schema for the destination table. The schema can be omitted if the destination table already exists, or if you're loading data from Google Cloud Datastore.
    SchemaInline string
    [Deprecated] The inline schema. For CSV schemas, specify as "Field1:Type1[,Field2:Type2]*". For example, "foo:STRING, bar:INTEGER, baz:FLOAT".

    Deprecated: [Deprecated] The inline schema. For CSV schemas, specify as "Field1:Type1[,Field2:Type2]*". For example, "foo:STRING, bar:INTEGER, baz:FLOAT".

    SchemaInlineFormat string
    [Deprecated] The format of the schemaInline property.

    Deprecated: [Deprecated] The format of the schemaInline property.

    SchemaUpdateOptions List<string>
    Allows the schema of the destination table to be updated as a side effect of the load job if a schema is autodetected or supplied in the job configuration. Schema update options are supported in two cases: when writeDisposition is WRITE_APPEND; when writeDisposition is WRITE_TRUNCATE and the destination table is a partition of a table, specified by partition decorators. For normal tables, WRITE_TRUNCATE will always overwrite the schema. One or more of the following values are specified: ALLOW_FIELD_ADDITION: allow adding a nullable field to the schema. ALLOW_FIELD_RELAXATION: allow relaxing a required field in the original schema to nullable.
    SkipLeadingRows int
    [Optional] The number of rows at the top of a CSV file that BigQuery will skip when loading the data. The default value is 0. This property is useful if you have header rows in the file that should be skipped.
    SourceFormat string
    [Optional] The format of the data files. For CSV files, specify "CSV". For datastore backups, specify "DATASTORE_BACKUP". For newline-delimited JSON, specify "NEWLINE_DELIMITED_JSON". For Avro, specify "AVRO". For parquet, specify "PARQUET". For orc, specify "ORC". The default value is CSV.
    SourceUris List<string>
    [Required] The fully-qualified URIs that point to your data in Google Cloud. For Google Cloud Storage URIs: Each URI can contain one '' wildcard character and it must come after the 'bucket' name. Size limits related to load jobs apply to external data sources. For Google Cloud Bigtable URIs: Exactly one URI can be specified and it has be a fully specified and valid HTTPS URL for a Google Cloud Bigtable table. For Google Cloud Datastore backups: Exactly one URI can be specified. Also, the '' wildcard character is not allowed.
    TimePartitioning Pulumi.GoogleNative.BigQuery.V2.Inputs.TimePartitioning
    Time-based partitioning specification for the destination table. Only one of timePartitioning and rangePartitioning should be specified.
    UseAvroLogicalTypes bool
    [Optional] If sourceFormat is set to "AVRO", indicates whether to interpret logical types as the corresponding BigQuery data type (for example, TIMESTAMP), instead of using the raw type (for example, INTEGER).
    WriteDisposition string
    [Optional] Specifies the action that occurs if the destination table already exists. The following values are supported: WRITE_TRUNCATE: If the table already exists, BigQuery overwrites the table data. WRITE_APPEND: If the table already exists, BigQuery appends the data to the table. WRITE_EMPTY: If the table already exists and contains data, a 'duplicate' error is returned in the job result. The default value is WRITE_APPEND. Each action is atomic and only occurs if BigQuery is able to complete the job successfully. Creation, truncation and append actions occur as one atomic update upon job completion.
    AllowJaggedRows bool
    [Optional] Accept rows that are missing trailing optional columns. The missing values are treated as nulls. If false, records with missing trailing 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. Only applicable to CSV, ignored for other formats.
    AllowQuotedNewlines bool
    Indicates if BigQuery should allow quoted data sections that contain newline characters in a CSV file. The default value is false.
    Autodetect bool
    [Optional] Indicates if we should automatically infer the options and schema for CSV and JSON sources.
    Clustering Clustering
    [Beta] Clustering specification for the destination table. Must be specified with time-based partitioning, data in the table will be first partitioned and subsequently clustered.
    ConnectionProperties []ConnectionProperty
    Connection properties.
    CreateDisposition string
    [Optional] Specifies whether the job is allowed to create new tables. The following values are supported: CREATE_IF_NEEDED: If the table does not exist, BigQuery creates the table. CREATE_NEVER: The table must already exist. If it does not, a 'notFound' error is returned in the job result. The default value is CREATE_IF_NEEDED. Creation, truncation and append actions occur as one atomic update upon job completion.
    CreateSession bool
    If true, creates a new session, where session id will be a server generated random id. If false, runs query with an existing session_id passed in ConnectionProperty, otherwise runs the load job in non-session mode.
    DecimalTargetTypes []string
    [Optional] 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. Example: Suppose the value of this field is ["NUMERIC", "BIGNUMERIC"]. If (precision,scale) is: (38,9) -> NUMERIC; (39,9) -> BIGNUMERIC (NUMERIC cannot hold 30 integer digits); (38,10) -> BIGNUMERIC (NUMERIC cannot hold 10 fractional digits); (76,38) -> BIGNUMERIC; (77,38) -> BIGNUMERIC (error if value exeeds supported range). This field cannot contain duplicate types. The order of the types in this field is ignored. For example, ["BIGNUMERIC", "NUMERIC"] is the same as ["NUMERIC", "BIGNUMERIC"] and NUMERIC always takes precedence over BIGNUMERIC. Defaults to ["NUMERIC", "STRING"] for ORC and ["NUMERIC"] for the other file formats.
    DestinationEncryptionConfiguration EncryptionConfiguration
    Custom encryption configuration (e.g., Cloud KMS keys).
    DestinationTable TableReference
    [Required] The destination table to load the data into.
    DestinationTableProperties DestinationTableProperties
    [Beta] [Optional] Properties with which to create the destination table if it is new.
    Encoding string
    [Optional] The character encoding of the data. The supported values are UTF-8 or ISO-8859-1. The default value is UTF-8. BigQuery decodes the data after the raw, binary data has been split using the values of the quote and fieldDelimiter properties.
    FieldDelimiter string
    [Optional] The separator for fields in a CSV file. The separator can be any ISO-8859-1 single-byte character. To use a character in the range 128-255, you must encode the character as UTF8. BigQuery converts the string to ISO-8859-1 encoding, and then uses the first byte of the encoded string to split the data in its raw, binary state. BigQuery also supports the escape sequence "\t" to specify a tab separator. The default value is a comma (',').
    FileSetSpecType string
    [Optional] Specifies how source URIs are interpreted for constructing the file set to load. By default source URIs are expanded against the underlying storage. Other options include specifying manifest files. Only applicable to object storage systems.
    HivePartitioningOptions HivePartitioningOptions
    [Optional] Options to configure hive partitioning support.
    IgnoreUnknownValues bool
    [Optional] 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. The sourceFormat property determines what BigQuery treats as an extra value: CSV: Trailing columns JSON: Named values that don't match any column names
    JsonExtension string
    [Optional] If sourceFormat is set to newline-delimited JSON, indicates whether it should be processed as a JSON variant such as GeoJSON. For a sourceFormat other than JSON, omit this field. If the sourceFormat is newline-delimited JSON: - for newline-delimited GeoJSON: set to GEOJSON.
    MaxBadRecords int
    [Optional] The maximum number of bad records that BigQuery can ignore when running the job. If the number of bad records exceeds this value, an invalid error is returned in the job result. This is only valid for CSV and JSON. The default value is 0, which requires that all records are valid.
    NullMarker string
    [Optional] Specifies a string that represents a null value in a CSV file. For example, if you specify "\N", BigQuery interprets "\N" as a null value when loading a CSV file. The default value is the empty string. If you set this property to a custom value, BigQuery throws an error if an empty string is present for all data types except for STRING and BYTE. For STRING and BYTE columns, BigQuery interprets the empty string as an empty value.
    ParquetOptions ParquetOptions
    [Optional] Options to configure parquet support.
    PreserveAsciiControlCharacters bool
    [Optional] Preserves the embedded ASCII control characters (the first 32 characters in the ASCII-table, from '\x00' to '\x1F') when loading from CSV. Only applicable to CSV, ignored for other formats.
    ProjectionFields []string
    If sourceFormat is set to "DATASTORE_BACKUP", indicates which entity properties to load into BigQuery from a Cloud Datastore backup. Property names are case sensitive and must be top-level properties. If no properties are specified, BigQuery loads all properties. If any named property isn't found in the Cloud Datastore backup, an invalid error is returned in the job result.
    Quote string
    [Optional] The value that is used to quote data sections in a CSV file. BigQuery converts the string to ISO-8859-1 encoding, and then uses the first byte of the encoded string to split the data in its raw, binary state. The default value is a double-quote ('"'). If your data does not contain quoted sections, set the property value to an empty string. If your data contains quoted newline characters, you must also set the allowQuotedNewlines property to true.
    RangePartitioning RangePartitioning
    [TrustedTester] Range partitioning specification for this table. Only one of timePartitioning and rangePartitioning should be specified.
    ReferenceFileSchemaUri string
    User provided referencing file with the expected reader schema, Available for the format: AVRO, PARQUET, ORC.
    Schema TableSchema
    [Optional] The schema for the destination table. The schema can be omitted if the destination table already exists, or if you're loading data from Google Cloud Datastore.
    SchemaInline string
    [Deprecated] The inline schema. For CSV schemas, specify as "Field1:Type1[,Field2:Type2]*". For example, "foo:STRING, bar:INTEGER, baz:FLOAT".

    Deprecated: [Deprecated] The inline schema. For CSV schemas, specify as "Field1:Type1[,Field2:Type2]*". For example, "foo:STRING, bar:INTEGER, baz:FLOAT".

    SchemaInlineFormat string
    [Deprecated] The format of the schemaInline property.

    Deprecated: [Deprecated] The format of the schemaInline property.

    SchemaUpdateOptions []string
    Allows the schema of the destination table to be updated as a side effect of the load job if a schema is autodetected or supplied in the job configuration. Schema update options are supported in two cases: when writeDisposition is WRITE_APPEND; when writeDisposition is WRITE_TRUNCATE and the destination table is a partition of a table, specified by partition decorators. For normal tables, WRITE_TRUNCATE will always overwrite the schema. One or more of the following values are specified: ALLOW_FIELD_ADDITION: allow adding a nullable field to the schema. ALLOW_FIELD_RELAXATION: allow relaxing a required field in the original schema to nullable.
    SkipLeadingRows int
    [Optional] The number of rows at the top of a CSV file that BigQuery will skip when loading the data. The default value is 0. This property is useful if you have header rows in the file that should be skipped.
    SourceFormat string
    [Optional] The format of the data files. For CSV files, specify "CSV". For datastore backups, specify "DATASTORE_BACKUP". For newline-delimited JSON, specify "NEWLINE_DELIMITED_JSON". For Avro, specify "AVRO". For parquet, specify "PARQUET". For orc, specify "ORC". The default value is CSV.
    SourceUris []string
    [Required] The fully-qualified URIs that point to your data in Google Cloud. For Google Cloud Storage URIs: Each URI can contain one '' wildcard character and it must come after the 'bucket' name. Size limits related to load jobs apply to external data sources. For Google Cloud Bigtable URIs: Exactly one URI can be specified and it has be a fully specified and valid HTTPS URL for a Google Cloud Bigtable table. For Google Cloud Datastore backups: Exactly one URI can be specified. Also, the '' wildcard character is not allowed.
    TimePartitioning TimePartitioning
    Time-based partitioning specification for the destination table. Only one of timePartitioning and rangePartitioning should be specified.
    UseAvroLogicalTypes bool
    [Optional] If sourceFormat is set to "AVRO", indicates whether to interpret logical types as the corresponding BigQuery data type (for example, TIMESTAMP), instead of using the raw type (for example, INTEGER).
    WriteDisposition string
    [Optional] Specifies the action that occurs if the destination table already exists. The following values are supported: WRITE_TRUNCATE: If the table already exists, BigQuery overwrites the table data. WRITE_APPEND: If the table already exists, BigQuery appends the data to the table. WRITE_EMPTY: If the table already exists and contains data, a 'duplicate' error is returned in the job result. The default value is WRITE_APPEND. Each action is atomic and only occurs if BigQuery is able to complete the job successfully. Creation, truncation and append actions occur as one atomic update upon job completion.
    allowJaggedRows Boolean
    [Optional] Accept rows that are missing trailing optional columns. The missing values are treated as nulls. If false, records with missing trailing 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. Only applicable to CSV, ignored for other formats.
    allowQuotedNewlines Boolean
    Indicates if BigQuery should allow quoted data sections that contain newline characters in a CSV file. The default value is false.
    autodetect Boolean
    [Optional] Indicates if we should automatically infer the options and schema for CSV and JSON sources.
    clustering Clustering
    [Beta] Clustering specification for the destination table. Must be specified with time-based partitioning, data in the table will be first partitioned and subsequently clustered.
    connectionProperties List<ConnectionProperty>
    Connection properties.
    createDisposition String
    [Optional] Specifies whether the job is allowed to create new tables. The following values are supported: CREATE_IF_NEEDED: If the table does not exist, BigQuery creates the table. CREATE_NEVER: The table must already exist. If it does not, a 'notFound' error is returned in the job result. The default value is CREATE_IF_NEEDED. Creation, truncation and append actions occur as one atomic update upon job completion.
    createSession Boolean
    If true, creates a new session, where session id will be a server generated random id. If false, runs query with an existing session_id passed in ConnectionProperty, otherwise runs the load job in non-session mode.
    decimalTargetTypes List<String>
    [Optional] 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. Example: Suppose the value of this field is ["NUMERIC", "BIGNUMERIC"]. If (precision,scale) is: (38,9) -> NUMERIC; (39,9) -> BIGNUMERIC (NUMERIC cannot hold 30 integer digits); (38,10) -> BIGNUMERIC (NUMERIC cannot hold 10 fractional digits); (76,38) -> BIGNUMERIC; (77,38) -> BIGNUMERIC (error if value exeeds supported range). This field cannot contain duplicate types. The order of the types in this field is ignored. For example, ["BIGNUMERIC", "NUMERIC"] is the same as ["NUMERIC", "BIGNUMERIC"] and NUMERIC always takes precedence over BIGNUMERIC. Defaults to ["NUMERIC", "STRING"] for ORC and ["NUMERIC"] for the other file formats.
    destinationEncryptionConfiguration EncryptionConfiguration
    Custom encryption configuration (e.g., Cloud KMS keys).
    destinationTable TableReference
    [Required] The destination table to load the data into.
    destinationTableProperties DestinationTableProperties
    [Beta] [Optional] Properties with which to create the destination table if it is new.
    encoding String
    [Optional] The character encoding of the data. The supported values are UTF-8 or ISO-8859-1. The default value is UTF-8. BigQuery decodes the data after the raw, binary data has been split using the values of the quote and fieldDelimiter properties.
    fieldDelimiter String
    [Optional] The separator for fields in a CSV file. The separator can be any ISO-8859-1 single-byte character. To use a character in the range 128-255, you must encode the character as UTF8. BigQuery converts the string to ISO-8859-1 encoding, and then uses the first byte of the encoded string to split the data in its raw, binary state. BigQuery also supports the escape sequence "\t" to specify a tab separator. The default value is a comma (',').
    fileSetSpecType String
    [Optional] Specifies how source URIs are interpreted for constructing the file set to load. By default source URIs are expanded against the underlying storage. Other options include specifying manifest files. Only applicable to object storage systems.
    hivePartitioningOptions HivePartitioningOptions
    [Optional] Options to configure hive partitioning support.
    ignoreUnknownValues Boolean
    [Optional] 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. The sourceFormat property determines what BigQuery treats as an extra value: CSV: Trailing columns JSON: Named values that don't match any column names
    jsonExtension String
    [Optional] If sourceFormat is set to newline-delimited JSON, indicates whether it should be processed as a JSON variant such as GeoJSON. For a sourceFormat other than JSON, omit this field. If the sourceFormat is newline-delimited JSON: - for newline-delimited GeoJSON: set to GEOJSON.
    maxBadRecords Integer
    [Optional] The maximum number of bad records that BigQuery can ignore when running the job. If the number of bad records exceeds this value, an invalid error is returned in the job result. This is only valid for CSV and JSON. The default value is 0, which requires that all records are valid.
    nullMarker String
    [Optional] Specifies a string that represents a null value in a CSV file. For example, if you specify "\N", BigQuery interprets "\N" as a null value when loading a CSV file. The default value is the empty string. If you set this property to a custom value, BigQuery throws an error if an empty string is present for all data types except for STRING and BYTE. For STRING and BYTE columns, BigQuery interprets the empty string as an empty value.
    parquetOptions ParquetOptions
    [Optional] Options to configure parquet support.
    preserveAsciiControlCharacters Boolean
    [Optional] Preserves the embedded ASCII control characters (the first 32 characters in the ASCII-table, from '\x00' to '\x1F') when loading from CSV. Only applicable to CSV, ignored for other formats.
    projectionFields List<String>
    If sourceFormat is set to "DATASTORE_BACKUP", indicates which entity properties to load into BigQuery from a Cloud Datastore backup. Property names are case sensitive and must be top-level properties. If no properties are specified, BigQuery loads all properties. If any named property isn't found in the Cloud Datastore backup, an invalid error is returned in the job result.
    quote String
    [Optional] The value that is used to quote data sections in a CSV file. BigQuery converts the string to ISO-8859-1 encoding, and then uses the first byte of the encoded string to split the data in its raw, binary state. The default value is a double-quote ('"'). If your data does not contain quoted sections, set the property value to an empty string. If your data contains quoted newline characters, you must also set the allowQuotedNewlines property to true.
    rangePartitioning RangePartitioning
    [TrustedTester] Range partitioning specification for this table. Only one of timePartitioning and rangePartitioning should be specified.
    referenceFileSchemaUri String
    User provided referencing file with the expected reader schema, Available for the format: AVRO, PARQUET, ORC.
    schema TableSchema
    [Optional] The schema for the destination table. The schema can be omitted if the destination table already exists, or if you're loading data from Google Cloud Datastore.
    schemaInline String
    [Deprecated] The inline schema. For CSV schemas, specify as "Field1:Type1[,Field2:Type2]*". For example, "foo:STRING, bar:INTEGER, baz:FLOAT".

    Deprecated: [Deprecated] The inline schema. For CSV schemas, specify as "Field1:Type1[,Field2:Type2]*". For example, "foo:STRING, bar:INTEGER, baz:FLOAT".

    schemaInlineFormat String
    [Deprecated] The format of the schemaInline property.

    Deprecated: [Deprecated] The format of the schemaInline property.

    schemaUpdateOptions List<String>
    Allows the schema of the destination table to be updated as a side effect of the load job if a schema is autodetected or supplied in the job configuration. Schema update options are supported in two cases: when writeDisposition is WRITE_APPEND; when writeDisposition is WRITE_TRUNCATE and the destination table is a partition of a table, specified by partition decorators. For normal tables, WRITE_TRUNCATE will always overwrite the schema. One or more of the following values are specified: ALLOW_FIELD_ADDITION: allow adding a nullable field to the schema. ALLOW_FIELD_RELAXATION: allow relaxing a required field in the original schema to nullable.
    skipLeadingRows Integer
    [Optional] The number of rows at the top of a CSV file that BigQuery will skip when loading the data. The default value is 0. This property is useful if you have header rows in the file that should be skipped.
    sourceFormat String
    [Optional] The format of the data files. For CSV files, specify "CSV". For datastore backups, specify "DATASTORE_BACKUP". For newline-delimited JSON, specify "NEWLINE_DELIMITED_JSON". For Avro, specify "AVRO". For parquet, specify "PARQUET". For orc, specify "ORC". The default value is CSV.
    sourceUris List<String>
    [Required] The fully-qualified URIs that point to your data in Google Cloud. For Google Cloud Storage URIs: Each URI can contain one '' wildcard character and it must come after the 'bucket' name. Size limits related to load jobs apply to external data sources. For Google Cloud Bigtable URIs: Exactly one URI can be specified and it has be a fully specified and valid HTTPS URL for a Google Cloud Bigtable table. For Google Cloud Datastore backups: Exactly one URI can be specified. Also, the '' wildcard character is not allowed.
    timePartitioning TimePartitioning
    Time-based partitioning specification for the destination table. Only one of timePartitioning and rangePartitioning should be specified.
    useAvroLogicalTypes Boolean
    [Optional] If sourceFormat is set to "AVRO", indicates whether to interpret logical types as the corresponding BigQuery data type (for example, TIMESTAMP), instead of using the raw type (for example, INTEGER).
    writeDisposition String
    [Optional] Specifies the action that occurs if the destination table already exists. The following values are supported: WRITE_TRUNCATE: If the table already exists, BigQuery overwrites the table data. WRITE_APPEND: If the table already exists, BigQuery appends the data to the table. WRITE_EMPTY: If the table already exists and contains data, a 'duplicate' error is returned in the job result. The default value is WRITE_APPEND. Each action is atomic and only occurs if BigQuery is able to complete the job successfully. Creation, truncation and append actions occur as one atomic update upon job completion.
    allowJaggedRows boolean
    [Optional] Accept rows that are missing trailing optional columns. The missing values are treated as nulls. If false, records with missing trailing 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. Only applicable to CSV, ignored for other formats.
    allowQuotedNewlines boolean
    Indicates if BigQuery should allow quoted data sections that contain newline characters in a CSV file. The default value is false.
    autodetect boolean
    [Optional] Indicates if we should automatically infer the options and schema for CSV and JSON sources.
    clustering Clustering
    [Beta] Clustering specification for the destination table. Must be specified with time-based partitioning, data in the table will be first partitioned and subsequently clustered.
    connectionProperties ConnectionProperty[]
    Connection properties.
    createDisposition string
    [Optional] Specifies whether the job is allowed to create new tables. The following values are supported: CREATE_IF_NEEDED: If the table does not exist, BigQuery creates the table. CREATE_NEVER: The table must already exist. If it does not, a 'notFound' error is returned in the job result. The default value is CREATE_IF_NEEDED. Creation, truncation and append actions occur as one atomic update upon job completion.
    createSession boolean
    If true, creates a new session, where session id will be a server generated random id. If false, runs query with an existing session_id passed in ConnectionProperty, otherwise runs the load job in non-session mode.
    decimalTargetTypes string[]
    [Optional] 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. Example: Suppose the value of this field is ["NUMERIC", "BIGNUMERIC"]. If (precision,scale) is: (38,9) -> NUMERIC; (39,9) -> BIGNUMERIC (NUMERIC cannot hold 30 integer digits); (38,10) -> BIGNUMERIC (NUMERIC cannot hold 10 fractional digits); (76,38) -> BIGNUMERIC; (77,38) -> BIGNUMERIC (error if value exeeds supported range). This field cannot contain duplicate types. The order of the types in this field is ignored. For example, ["BIGNUMERIC", "NUMERIC"] is the same as ["NUMERIC", "BIGNUMERIC"] and NUMERIC always takes precedence over BIGNUMERIC. Defaults to ["NUMERIC", "STRING"] for ORC and ["NUMERIC"] for the other file formats.
    destinationEncryptionConfiguration EncryptionConfiguration
    Custom encryption configuration (e.g., Cloud KMS keys).
    destinationTable TableReference
    [Required] The destination table to load the data into.
    destinationTableProperties DestinationTableProperties
    [Beta] [Optional] Properties with which to create the destination table if it is new.
    encoding string
    [Optional] The character encoding of the data. The supported values are UTF-8 or ISO-8859-1. The default value is UTF-8. BigQuery decodes the data after the raw, binary data has been split using the values of the quote and fieldDelimiter properties.
    fieldDelimiter string
    [Optional] The separator for fields in a CSV file. The separator can be any ISO-8859-1 single-byte character. To use a character in the range 128-255, you must encode the character as UTF8. BigQuery converts the string to ISO-8859-1 encoding, and then uses the first byte of the encoded string to split the data in its raw, binary state. BigQuery also supports the escape sequence "\t" to specify a tab separator. The default value is a comma (',').
    fileSetSpecType string
    [Optional] Specifies how source URIs are interpreted for constructing the file set to load. By default source URIs are expanded against the underlying storage. Other options include specifying manifest files. Only applicable to object storage systems.
    hivePartitioningOptions HivePartitioningOptions
    [Optional] Options to configure hive partitioning support.
    ignoreUnknownValues boolean
    [Optional] 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. The sourceFormat property determines what BigQuery treats as an extra value: CSV: Trailing columns JSON: Named values that don't match any column names
    jsonExtension string
    [Optional] If sourceFormat is set to newline-delimited JSON, indicates whether it should be processed as a JSON variant such as GeoJSON. For a sourceFormat other than JSON, omit this field. If the sourceFormat is newline-delimited JSON: - for newline-delimited GeoJSON: set to GEOJSON.
    maxBadRecords number
    [Optional] The maximum number of bad records that BigQuery can ignore when running the job. If the number of bad records exceeds this value, an invalid error is returned in the job result. This is only valid for CSV and JSON. The default value is 0, which requires that all records are valid.
    nullMarker string
    [Optional] Specifies a string that represents a null value in a CSV file. For example, if you specify "\N", BigQuery interprets "\N" as a null value when loading a CSV file. The default value is the empty string. If you set this property to a custom value, BigQuery throws an error if an empty string is present for all data types except for STRING and BYTE. For STRING and BYTE columns, BigQuery interprets the empty string as an empty value.
    parquetOptions ParquetOptions
    [Optional] Options to configure parquet support.
    preserveAsciiControlCharacters boolean
    [Optional] Preserves the embedded ASCII control characters (the first 32 characters in the ASCII-table, from '\x00' to '\x1F') when loading from CSV. Only applicable to CSV, ignored for other formats.
    projectionFields string[]
    If sourceFormat is set to "DATASTORE_BACKUP", indicates which entity properties to load into BigQuery from a Cloud Datastore backup. Property names are case sensitive and must be top-level properties. If no properties are specified, BigQuery loads all properties. If any named property isn't found in the Cloud Datastore backup, an invalid error is returned in the job result.
    quote string
    [Optional] The value that is used to quote data sections in a CSV file. BigQuery converts the string to ISO-8859-1 encoding, and then uses the first byte of the encoded string to split the data in its raw, binary state. The default value is a double-quote ('"'). If your data does not contain quoted sections, set the property value to an empty string. If your data contains quoted newline characters, you must also set the allowQuotedNewlines property to true.
    rangePartitioning RangePartitioning
    [TrustedTester] Range partitioning specification for this table. Only one of timePartitioning and rangePartitioning should be specified.
    referenceFileSchemaUri string
    User provided referencing file with the expected reader schema, Available for the format: AVRO, PARQUET, ORC.
    schema TableSchema
    [Optional] The schema for the destination table. The schema can be omitted if the destination table already exists, or if you're loading data from Google Cloud Datastore.
    schemaInline string
    [Deprecated] The inline schema. For CSV schemas, specify as "Field1:Type1[,Field2:Type2]*". For example, "foo:STRING, bar:INTEGER, baz:FLOAT".

    Deprecated: [Deprecated] The inline schema. For CSV schemas, specify as "Field1:Type1[,Field2:Type2]*". For example, "foo:STRING, bar:INTEGER, baz:FLOAT".

    schemaInlineFormat string
    [Deprecated] The format of the schemaInline property.

    Deprecated: [Deprecated] The format of the schemaInline property.

    schemaUpdateOptions string[]
    Allows the schema of the destination table to be updated as a side effect of the load job if a schema is autodetected or supplied in the job configuration. Schema update options are supported in two cases: when writeDisposition is WRITE_APPEND; when writeDisposition is WRITE_TRUNCATE and the destination table is a partition of a table, specified by partition decorators. For normal tables, WRITE_TRUNCATE will always overwrite the schema. One or more of the following values are specified: ALLOW_FIELD_ADDITION: allow adding a nullable field to the schema. ALLOW_FIELD_RELAXATION: allow relaxing a required field in the original schema to nullable.
    skipLeadingRows number
    [Optional] The number of rows at the top of a CSV file that BigQuery will skip when loading the data. The default value is 0. This property is useful if you have header rows in the file that should be skipped.
    sourceFormat string
    [Optional] The format of the data files. For CSV files, specify "CSV". For datastore backups, specify "DATASTORE_BACKUP". For newline-delimited JSON, specify "NEWLINE_DELIMITED_JSON". For Avro, specify "AVRO". For parquet, specify "PARQUET". For orc, specify "ORC". The default value is CSV.
    sourceUris string[]
    [Required] The fully-qualified URIs that point to your data in Google Cloud. For Google Cloud Storage URIs: Each URI can contain one '' wildcard character and it must come after the 'bucket' name. Size limits related to load jobs apply to external data sources. For Google Cloud Bigtable URIs: Exactly one URI can be specified and it has be a fully specified and valid HTTPS URL for a Google Cloud Bigtable table. For Google Cloud Datastore backups: Exactly one URI can be specified. Also, the '' wildcard character is not allowed.
    timePartitioning TimePartitioning
    Time-based partitioning specification for the destination table. Only one of timePartitioning and rangePartitioning should be specified.
    useAvroLogicalTypes boolean
    [Optional] If sourceFormat is set to "AVRO", indicates whether to interpret logical types as the corresponding BigQuery data type (for example, TIMESTAMP), instead of using the raw type (for example, INTEGER).
    writeDisposition string
    [Optional] Specifies the action that occurs if the destination table already exists. The following values are supported: WRITE_TRUNCATE: If the table already exists, BigQuery overwrites the table data. WRITE_APPEND: If the table already exists, BigQuery appends the data to the table. WRITE_EMPTY: If the table already exists and contains data, a 'duplicate' error is returned in the job result. The default value is WRITE_APPEND. Each action is atomic and only occurs if BigQuery is able to complete the job successfully. Creation, truncation and append actions occur as one atomic update upon job completion.
    allow_jagged_rows bool
    [Optional] Accept rows that are missing trailing optional columns. The missing values are treated as nulls. If false, records with missing trailing 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. Only applicable to CSV, ignored for other formats.
    allow_quoted_newlines bool
    Indicates if BigQuery should allow quoted data sections that contain newline characters in a CSV file. The default value is false.
    autodetect bool
    [Optional] Indicates if we should automatically infer the options and schema for CSV and JSON sources.
    clustering Clustering
    [Beta] Clustering specification for the destination table. Must be specified with time-based partitioning, data in the table will be first partitioned and subsequently clustered.
    connection_properties Sequence[ConnectionProperty]
    Connection properties.
    create_disposition str
    [Optional] Specifies whether the job is allowed to create new tables. The following values are supported: CREATE_IF_NEEDED: If the table does not exist, BigQuery creates the table. CREATE_NEVER: The table must already exist. If it does not, a 'notFound' error is returned in the job result. The default value is CREATE_IF_NEEDED. Creation, truncation and append actions occur as one atomic update upon job completion.
    create_session bool
    If true, creates a new session, where session id will be a server generated random id. If false, runs query with an existing session_id passed in ConnectionProperty, otherwise runs the load job in non-session mode.
    decimal_target_types Sequence[str]
    [Optional] 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. Example: Suppose the value of this field is ["NUMERIC", "BIGNUMERIC"]. If (precision,scale) is: (38,9) -> NUMERIC; (39,9) -> BIGNUMERIC (NUMERIC cannot hold 30 integer digits); (38,10) -> BIGNUMERIC (NUMERIC cannot hold 10 fractional digits); (76,38) -> BIGNUMERIC; (77,38) -> BIGNUMERIC (error if value exeeds supported range). This field cannot contain duplicate types. The order of the types in this field is ignored. For example, ["BIGNUMERIC", "NUMERIC"] is the same as ["NUMERIC", "BIGNUMERIC"] and NUMERIC always takes precedence over BIGNUMERIC. Defaults to ["NUMERIC", "STRING"] for ORC and ["NUMERIC"] for the other file formats.
    destination_encryption_configuration EncryptionConfiguration
    Custom encryption configuration (e.g., Cloud KMS keys).
    destination_table TableReference
    [Required] The destination table to load the data into.
    destination_table_properties DestinationTableProperties
    [Beta] [Optional] Properties with which to create the destination table if it is new.
    encoding str
    [Optional] The character encoding of the data. The supported values are UTF-8 or ISO-8859-1. The default value is UTF-8. BigQuery decodes the data after the raw, binary data has been split using the values of the quote and fieldDelimiter properties.
    field_delimiter str
    [Optional] The separator for fields in a CSV file. The separator can be any ISO-8859-1 single-byte character. To use a character in the range 128-255, you must encode the character as UTF8. BigQuery converts the string to ISO-8859-1 encoding, and then uses the first byte of the encoded string to split the data in its raw, binary state. BigQuery also supports the escape sequence "\t" to specify a tab separator. The default value is a comma (',').
    file_set_spec_type str
    [Optional] Specifies how source URIs are interpreted for constructing the file set to load. By default source URIs are expanded against the underlying storage. Other options include specifying manifest files. Only applicable to object storage systems.
    hive_partitioning_options HivePartitioningOptions
    [Optional] Options to configure hive partitioning support.
    ignore_unknown_values bool
    [Optional] 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. The sourceFormat property determines what BigQuery treats as an extra value: CSV: Trailing columns JSON: Named values that don't match any column names
    json_extension str
    [Optional] If sourceFormat is set to newline-delimited JSON, indicates whether it should be processed as a JSON variant such as GeoJSON. For a sourceFormat other than JSON, omit this field. If the sourceFormat is newline-delimited JSON: - for newline-delimited GeoJSON: set to GEOJSON.
    max_bad_records int
    [Optional] The maximum number of bad records that BigQuery can ignore when running the job. If the number of bad records exceeds this value, an invalid error is returned in the job result. This is only valid for CSV and JSON. The default value is 0, which requires that all records are valid.
    null_marker str
    [Optional] Specifies a string that represents a null value in a CSV file. For example, if you specify "\N", BigQuery interprets "\N" as a null value when loading a CSV file. The default value is the empty string. If you set this property to a custom value, BigQuery throws an error if an empty string is present for all data types except for STRING and BYTE. For STRING and BYTE columns, BigQuery interprets the empty string as an empty value.
    parquet_options ParquetOptions
    [Optional] Options to configure parquet support.
    preserve_ascii_control_characters bool
    [Optional] Preserves the embedded ASCII control characters (the first 32 characters in the ASCII-table, from '\x00' to '\x1F') when loading from CSV. Only applicable to CSV, ignored for other formats.
    projection_fields Sequence[str]
    If sourceFormat is set to "DATASTORE_BACKUP", indicates which entity properties to load into BigQuery from a Cloud Datastore backup. Property names are case sensitive and must be top-level properties. If no properties are specified, BigQuery loads all properties. If any named property isn't found in the Cloud Datastore backup, an invalid error is returned in the job result.
    quote str
    [Optional] The value that is used to quote data sections in a CSV file. BigQuery converts the string to ISO-8859-1 encoding, and then uses the first byte of the encoded string to split the data in its raw, binary state. The default value is a double-quote ('"'). If your data does not contain quoted sections, set the property value to an empty string. If your data contains quoted newline characters, you must also set the allowQuotedNewlines property to true.
    range_partitioning RangePartitioning
    [TrustedTester] Range partitioning specification for this table. Only one of timePartitioning and rangePartitioning should be specified.
    reference_file_schema_uri str
    User provided referencing file with the expected reader schema, Available for the format: AVRO, PARQUET, ORC.
    schema TableSchema
    [Optional] The schema for the destination table. The schema can be omitted if the destination table already exists, or if you're loading data from Google Cloud Datastore.
    schema_inline str
    [Deprecated] The inline schema. For CSV schemas, specify as "Field1:Type1[,Field2:Type2]*". For example, "foo:STRING, bar:INTEGER, baz:FLOAT".

    Deprecated: [Deprecated] The inline schema. For CSV schemas, specify as "Field1:Type1[,Field2:Type2]*". For example, "foo:STRING, bar:INTEGER, baz:FLOAT".

    schema_inline_format str
    [Deprecated] The format of the schemaInline property.

    Deprecated: [Deprecated] The format of the schemaInline property.

    schema_update_options Sequence[str]
    Allows the schema of the destination table to be updated as a side effect of the load job if a schema is autodetected or supplied in the job configuration. Schema update options are supported in two cases: when writeDisposition is WRITE_APPEND; when writeDisposition is WRITE_TRUNCATE and the destination table is a partition of a table, specified by partition decorators. For normal tables, WRITE_TRUNCATE will always overwrite the schema. One or more of the following values are specified: ALLOW_FIELD_ADDITION: allow adding a nullable field to the schema. ALLOW_FIELD_RELAXATION: allow relaxing a required field in the original schema to nullable.
    skip_leading_rows int
    [Optional] The number of rows at the top of a CSV file that BigQuery will skip when loading the data. The default value is 0. This property is useful if you have header rows in the file that should be skipped.
    source_format str
    [Optional] The format of the data files. For CSV files, specify "CSV". For datastore backups, specify "DATASTORE_BACKUP". For newline-delimited JSON, specify "NEWLINE_DELIMITED_JSON". For Avro, specify "AVRO". For parquet, specify "PARQUET". For orc, specify "ORC". The default value is CSV.
    source_uris Sequence[str]
    [Required] The fully-qualified URIs that point to your data in Google Cloud. For Google Cloud Storage URIs: Each URI can contain one '' wildcard character and it must come after the 'bucket' name. Size limits related to load jobs apply to external data sources. For Google Cloud Bigtable URIs: Exactly one URI can be specified and it has be a fully specified and valid HTTPS URL for a Google Cloud Bigtable table. For Google Cloud Datastore backups: Exactly one URI can be specified. Also, the '' wildcard character is not allowed.
    time_partitioning TimePartitioning
    Time-based partitioning specification for the destination table. Only one of timePartitioning and rangePartitioning should be specified.
    use_avro_logical_types bool
    [Optional] If sourceFormat is set to "AVRO", indicates whether to interpret logical types as the corresponding BigQuery data type (for example, TIMESTAMP), instead of using the raw type (for example, INTEGER).
    write_disposition str
    [Optional] Specifies the action that occurs if the destination table already exists. The following values are supported: WRITE_TRUNCATE: If the table already exists, BigQuery overwrites the table data. WRITE_APPEND: If the table already exists, BigQuery appends the data to the table. WRITE_EMPTY: If the table already exists and contains data, a 'duplicate' error is returned in the job result. The default value is WRITE_APPEND. Each action is atomic and only occurs if BigQuery is able to complete the job successfully. Creation, truncation and append actions occur as one atomic update upon job completion.
    allowJaggedRows Boolean
    [Optional] Accept rows that are missing trailing optional columns. The missing values are treated as nulls. If false, records with missing trailing 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. Only applicable to CSV, ignored for other formats.
    allowQuotedNewlines Boolean
    Indicates if BigQuery should allow quoted data sections that contain newline characters in a CSV file. The default value is false.
    autodetect Boolean
    [Optional] Indicates if we should automatically infer the options and schema for CSV and JSON sources.
    clustering Property Map
    [Beta] Clustering specification for the destination table. Must be specified with time-based partitioning, data in the table will be first partitioned and subsequently clustered.
    connectionProperties List<Property Map>
    Connection properties.
    createDisposition String
    [Optional] Specifies whether the job is allowed to create new tables. The following values are supported: CREATE_IF_NEEDED: If the table does not exist, BigQuery creates the table. CREATE_NEVER: The table must already exist. If it does not, a 'notFound' error is returned in the job result. The default value is CREATE_IF_NEEDED. Creation, truncation and append actions occur as one atomic update upon job completion.
    createSession Boolean
    If true, creates a new session, where session id will be a server generated random id. If false, runs query with an existing session_id passed in ConnectionProperty, otherwise runs the load job in non-session mode.
    decimalTargetTypes List<String>
    [Optional] 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. Example: Suppose the value of this field is ["NUMERIC", "BIGNUMERIC"]. If (precision,scale) is: (38,9) -> NUMERIC; (39,9) -> BIGNUMERIC (NUMERIC cannot hold 30 integer digits); (38,10) -> BIGNUMERIC (NUMERIC cannot hold 10 fractional digits); (76,38) -> BIGNUMERIC; (77,38) -> BIGNUMERIC (error if value exeeds supported range). This field cannot contain duplicate types. The order of the types in this field is ignored. For example, ["BIGNUMERIC", "NUMERIC"] is the same as ["NUMERIC", "BIGNUMERIC"] and NUMERIC always takes precedence over BIGNUMERIC. Defaults to ["NUMERIC", "STRING"] for ORC and ["NUMERIC"] for the other file formats.
    destinationEncryptionConfiguration Property Map
    Custom encryption configuration (e.g., Cloud KMS keys).
    destinationTable Property Map
    [Required] The destination table to load the data into.
    destinationTableProperties Property Map
    [Beta] [Optional] Properties with which to create the destination table if it is new.
    encoding String
    [Optional] The character encoding of the data. The supported values are UTF-8 or ISO-8859-1. The default value is UTF-8. BigQuery decodes the data after the raw, binary data has been split using the values of the quote and fieldDelimiter properties.
    fieldDelimiter String
    [Optional] The separator for fields in a CSV file. The separator can be any ISO-8859-1 single-byte character. To use a character in the range 128-255, you must encode the character as UTF8. BigQuery converts the string to ISO-8859-1 encoding, and then uses the first byte of the encoded string to split the data in its raw, binary state. BigQuery also supports the escape sequence "\t" to specify a tab separator. The default value is a comma (',').
    fileSetSpecType String
    [Optional] Specifies how source URIs are interpreted for constructing the file set to load. By default source URIs are expanded against the underlying storage. Other options include specifying manifest files. Only applicable to object storage systems.
    hivePartitioningOptions Property Map
    [Optional] Options to configure hive partitioning support.
    ignoreUnknownValues Boolean
    [Optional] 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. The sourceFormat property determines what BigQuery treats as an extra value: CSV: Trailing columns JSON: Named values that don't match any column names
    jsonExtension String
    [Optional] If sourceFormat is set to newline-delimited JSON, indicates whether it should be processed as a JSON variant such as GeoJSON. For a sourceFormat other than JSON, omit this field. If the sourceFormat is newline-delimited JSON: - for newline-delimited GeoJSON: set to GEOJSON.
    maxBadRecords Number
    [Optional] The maximum number of bad records that BigQuery can ignore when running the job. If the number of bad records exceeds this value, an invalid error is returned in the job result. This is only valid for CSV and JSON. The default value is 0, which requires that all records are valid.
    nullMarker String
    [Optional] Specifies a string that represents a null value in a CSV file. For example, if you specify "\N", BigQuery interprets "\N" as a null value when loading a CSV file. The default value is the empty string. If you set this property to a custom value, BigQuery throws an error if an empty string is present for all data types except for STRING and BYTE. For STRING and BYTE columns, BigQuery interprets the empty string as an empty value.
    parquetOptions Property Map
    [Optional] Options to configure parquet support.
    preserveAsciiControlCharacters Boolean
    [Optional] Preserves the embedded ASCII control characters (the first 32 characters in the ASCII-table, from '\x00' to '\x1F') when loading from CSV. Only applicable to CSV, ignored for other formats.
    projectionFields List<String>
    If sourceFormat is set to "DATASTORE_BACKUP", indicates which entity properties to load into BigQuery from a Cloud Datastore backup. Property names are case sensitive and must be top-level properties. If no properties are specified, BigQuery loads all properties. If any named property isn't found in the Cloud Datastore backup, an invalid error is returned in the job result.
    quote String
    [Optional] The value that is used to quote data sections in a CSV file. BigQuery converts the string to ISO-8859-1 encoding, and then uses the first byte of the encoded string to split the data in its raw, binary state. The default value is a double-quote ('"'). If your data does not contain quoted sections, set the property value to an empty string. If your data contains quoted newline characters, you must also set the allowQuotedNewlines property to true.
    rangePartitioning Property Map
    [TrustedTester] Range partitioning specification for this table. Only one of timePartitioning and rangePartitioning should be specified.
    referenceFileSchemaUri String
    User provided referencing file with the expected reader schema, Available for the format: AVRO, PARQUET, ORC.
    schema Property Map
    [Optional] The schema for the destination table. The schema can be omitted if the destination table already exists, or if you're loading data from Google Cloud Datastore.
    schemaInline String
    [Deprecated] The inline schema. For CSV schemas, specify as "Field1:Type1[,Field2:Type2]*". For example, "foo:STRING, bar:INTEGER, baz:FLOAT".

    Deprecated: [Deprecated] The inline schema. For CSV schemas, specify as "Field1:Type1[,Field2:Type2]*". For example, "foo:STRING, bar:INTEGER, baz:FLOAT".

    schemaInlineFormat String
    [Deprecated] The format of the schemaInline property.

    Deprecated: [Deprecated] The format of the schemaInline property.

    schemaUpdateOptions List<String>
    Allows the schema of the destination table to be updated as a side effect of the load job if a schema is autodetected or supplied in the job configuration. Schema update options are supported in two cases: when writeDisposition is WRITE_APPEND; when writeDisposition is WRITE_TRUNCATE and the destination table is a partition of a table, specified by partition decorators. For normal tables, WRITE_TRUNCATE will always overwrite the schema. One or more of the following values are specified: ALLOW_FIELD_ADDITION: allow adding a nullable field to the schema. ALLOW_FIELD_RELAXATION: allow relaxing a required field in the original schema to nullable.
    skipLeadingRows Number
    [Optional] The number of rows at the top of a CSV file that BigQuery will skip when loading the data. The default value is 0. This property is useful if you have header rows in the file that should be skipped.
    sourceFormat String
    [Optional] The format of the data files. For CSV files, specify "CSV". For datastore backups, specify "DATASTORE_BACKUP". For newline-delimited JSON, specify "NEWLINE_DELIMITED_JSON". For Avro, specify "AVRO". For parquet, specify "PARQUET". For orc, specify "ORC". The default value is CSV.
    sourceUris List<String>
    [Required] The fully-qualified URIs that point to your data in Google Cloud. For Google Cloud Storage URIs: Each URI can contain one '' wildcard character and it must come after the 'bucket' name. Size limits related to load jobs apply to external data sources. For Google Cloud Bigtable URIs: Exactly one URI can be specified and it has be a fully specified and valid HTTPS URL for a Google Cloud Bigtable table. For Google Cloud Datastore backups: Exactly one URI can be specified. Also, the '' wildcard character is not allowed.
    timePartitioning Property Map
    Time-based partitioning specification for the destination table. Only one of timePartitioning and rangePartitioning should be specified.
    useAvroLogicalTypes Boolean
    [Optional] If sourceFormat is set to "AVRO", indicates whether to interpret logical types as the corresponding BigQuery data type (for example, TIMESTAMP), instead of using the raw type (for example, INTEGER).
    writeDisposition String
    [Optional] Specifies the action that occurs if the destination table already exists. The following values are supported: WRITE_TRUNCATE: If the table already exists, BigQuery overwrites the table data. WRITE_APPEND: If the table already exists, BigQuery appends the data to the table. WRITE_EMPTY: If the table already exists and contains data, a 'duplicate' error is returned in the job result. The default value is WRITE_APPEND. Each action is atomic and only occurs if BigQuery is able to complete the job successfully. Creation, truncation and append actions occur as one atomic update upon job completion.

    JobConfigurationLoadResponse, JobConfigurationLoadResponseArgs

    AllowJaggedRows bool
    [Optional] Accept rows that are missing trailing optional columns. The missing values are treated as nulls. If false, records with missing trailing 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. Only applicable to CSV, ignored for other formats.
    AllowQuotedNewlines bool
    Indicates if BigQuery should allow quoted data sections that contain newline characters in a CSV file. The default value is false.
    Autodetect bool
    [Optional] Indicates if we should automatically infer the options and schema for CSV and JSON sources.
    Clustering Pulumi.GoogleNative.BigQuery.V2.Inputs.ClusteringResponse
    [Beta] Clustering specification for the destination table. Must be specified with time-based partitioning, data in the table will be first partitioned and subsequently clustered.
    ConnectionProperties List<Pulumi.GoogleNative.BigQuery.V2.Inputs.ConnectionPropertyResponse>
    Connection properties.
    CreateDisposition string
    [Optional] Specifies whether the job is allowed to create new tables. The following values are supported: CREATE_IF_NEEDED: If the table does not exist, BigQuery creates the table. CREATE_NEVER: The table must already exist. If it does not, a 'notFound' error is returned in the job result. The default value is CREATE_IF_NEEDED. Creation, truncation and append actions occur as one atomic update upon job completion.
    CreateSession bool
    If true, creates a new session, where session id will be a server generated random id. If false, runs query with an existing session_id passed in ConnectionProperty, otherwise runs the load job in non-session mode.
    DecimalTargetTypes List<string>
    [Optional] 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. Example: Suppose the value of this field is ["NUMERIC", "BIGNUMERIC"]. If (precision,scale) is: (38,9) -> NUMERIC; (39,9) -> BIGNUMERIC (NUMERIC cannot hold 30 integer digits); (38,10) -> BIGNUMERIC (NUMERIC cannot hold 10 fractional digits); (76,38) -> BIGNUMERIC; (77,38) -> BIGNUMERIC (error if value exeeds supported range). This field cannot contain duplicate types. The order of the types in this field is ignored. For example, ["BIGNUMERIC", "NUMERIC"] is the same as ["NUMERIC", "BIGNUMERIC"] and NUMERIC always takes precedence over BIGNUMERIC. Defaults to ["NUMERIC", "STRING"] for ORC and ["NUMERIC"] for the other file formats.
    DestinationEncryptionConfiguration Pulumi.GoogleNative.BigQuery.V2.Inputs.EncryptionConfigurationResponse
    Custom encryption configuration (e.g., Cloud KMS keys).
    DestinationTable Pulumi.GoogleNative.BigQuery.V2.Inputs.TableReferenceResponse
    [Required] The destination table to load the data into.
    DestinationTableProperties Pulumi.GoogleNative.BigQuery.V2.Inputs.DestinationTablePropertiesResponse
    [Beta] [Optional] Properties with which to create the destination table if it is new.
    Encoding string
    [Optional] The character encoding of the data. The supported values are UTF-8 or ISO-8859-1. The default value is UTF-8. BigQuery decodes the data after the raw, binary data has been split using the values of the quote and fieldDelimiter properties.
    FieldDelimiter string
    [Optional] The separator for fields in a CSV file. The separator can be any ISO-8859-1 single-byte character. To use a character in the range 128-255, you must encode the character as UTF8. BigQuery converts the string to ISO-8859-1 encoding, and then uses the first byte of the encoded string to split the data in its raw, binary state. BigQuery also supports the escape sequence "\t" to specify a tab separator. The default value is a comma (',').
    FileSetSpecType string
    [Optional] Specifies how source URIs are interpreted for constructing the file set to load. By default source URIs are expanded against the underlying storage. Other options include specifying manifest files. Only applicable to object storage systems.
    HivePartitioningOptions Pulumi.GoogleNative.BigQuery.V2.Inputs.HivePartitioningOptionsResponse
    [Optional] Options to configure hive partitioning support.
    IgnoreUnknownValues bool
    [Optional] 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. The sourceFormat property determines what BigQuery treats as an extra value: CSV: Trailing columns JSON: Named values that don't match any column names
    JsonExtension string
    [Optional] If sourceFormat is set to newline-delimited JSON, indicates whether it should be processed as a JSON variant such as GeoJSON. For a sourceFormat other than JSON, omit this field. If the sourceFormat is newline-delimited JSON: - for newline-delimited GeoJSON: set to GEOJSON.
    MaxBadRecords int
    [Optional] The maximum number of bad records that BigQuery can ignore when running the job. If the number of bad records exceeds this value, an invalid error is returned in the job result. This is only valid for CSV and JSON. The default value is 0, which requires that all records are valid.
    NullMarker string
    [Optional] Specifies a string that represents a null value in a CSV file. For example, if you specify "\N", BigQuery interprets "\N" as a null value when loading a CSV file. The default value is the empty string. If you set this property to a custom value, BigQuery throws an error if an empty string is present for all data types except for STRING and BYTE. For STRING and BYTE columns, BigQuery interprets the empty string as an empty value.
    ParquetOptions Pulumi.GoogleNative.BigQuery.V2.Inputs.ParquetOptionsResponse
    [Optional] Options to configure parquet support.
    PreserveAsciiControlCharacters bool
    [Optional] Preserves the embedded ASCII control characters (the first 32 characters in the ASCII-table, from '\x00' to '\x1F') when loading from CSV. Only applicable to CSV, ignored for other formats.
    ProjectionFields List<string>
    If sourceFormat is set to "DATASTORE_BACKUP", indicates which entity properties to load into BigQuery from a Cloud Datastore backup. Property names are case sensitive and must be top-level properties. If no properties are specified, BigQuery loads all properties. If any named property isn't found in the Cloud Datastore backup, an invalid error is returned in the job result.
    Quote string
    [Optional] The value that is used to quote data sections in a CSV file. BigQuery converts the string to ISO-8859-1 encoding, and then uses the first byte of the encoded string to split the data in its raw, binary state. The default value is a double-quote ('"'). If your data does not contain quoted sections, set the property value to an empty string. If your data contains quoted newline characters, you must also set the allowQuotedNewlines property to true.
    RangePartitioning Pulumi.GoogleNative.BigQuery.V2.Inputs.RangePartitioningResponse
    [TrustedTester] Range partitioning specification for this table. Only one of timePartitioning and rangePartitioning should be specified.
    ReferenceFileSchemaUri string
    User provided referencing file with the expected reader schema, Available for the format: AVRO, PARQUET, ORC.
    Schema Pulumi.GoogleNative.BigQuery.V2.Inputs.TableSchemaResponse
    [Optional] The schema for the destination table. The schema can be omitted if the destination table already exists, or if you're loading data from Google Cloud Datastore.
    SchemaInline string
    [Deprecated] The inline schema. For CSV schemas, specify as "Field1:Type1[,Field2:Type2]*". For example, "foo:STRING, bar:INTEGER, baz:FLOAT".

    Deprecated: [Deprecated] The inline schema. For CSV schemas, specify as "Field1:Type1[,Field2:Type2]*". For example, "foo:STRING, bar:INTEGER, baz:FLOAT".

    SchemaInlineFormat string
    [Deprecated] The format of the schemaInline property.

    Deprecated: [Deprecated] The format of the schemaInline property.

    SchemaUpdateOptions List<string>
    Allows the schema of the destination table to be updated as a side effect of the load job if a schema is autodetected or supplied in the job configuration. Schema update options are supported in two cases: when writeDisposition is WRITE_APPEND; when writeDisposition is WRITE_TRUNCATE and the destination table is a partition of a table, specified by partition decorators. For normal tables, WRITE_TRUNCATE will always overwrite the schema. One or more of the following values are specified: ALLOW_FIELD_ADDITION: allow adding a nullable field to the schema. ALLOW_FIELD_RELAXATION: allow relaxing a required field in the original schema to nullable.
    SkipLeadingRows int
    [Optional] The number of rows at the top of a CSV file that BigQuery will skip when loading the data. The default value is 0. This property is useful if you have header rows in the file that should be skipped.
    SourceFormat string
    [Optional] The format of the data files. For CSV files, specify "CSV". For datastore backups, specify "DATASTORE_BACKUP". For newline-delimited JSON, specify "NEWLINE_DELIMITED_JSON". For Avro, specify "AVRO". For parquet, specify "PARQUET". For orc, specify "ORC". The default value is CSV.
    SourceUris List<string>
    [Required] The fully-qualified URIs that point to your data in Google Cloud. For Google Cloud Storage URIs: Each URI can contain one '' wildcard character and it must come after the 'bucket' name. Size limits related to load jobs apply to external data sources. For Google Cloud Bigtable URIs: Exactly one URI can be specified and it has be a fully specified and valid HTTPS URL for a Google Cloud Bigtable table. For Google Cloud Datastore backups: Exactly one URI can be specified. Also, the '' wildcard character is not allowed.
    TimePartitioning Pulumi.GoogleNative.BigQuery.V2.Inputs.TimePartitioningResponse
    Time-based partitioning specification for the destination table. Only one of timePartitioning and rangePartitioning should be specified.
    UseAvroLogicalTypes bool
    [Optional] If sourceFormat is set to "AVRO", indicates whether to interpret logical types as the corresponding BigQuery data type (for example, TIMESTAMP), instead of using the raw type (for example, INTEGER).
    WriteDisposition string
    [Optional] Specifies the action that occurs if the destination table already exists. The following values are supported: WRITE_TRUNCATE: If the table already exists, BigQuery overwrites the table data. WRITE_APPEND: If the table already exists, BigQuery appends the data to the table. WRITE_EMPTY: If the table already exists and contains data, a 'duplicate' error is returned in the job result. The default value is WRITE_APPEND. Each action is atomic and only occurs if BigQuery is able to complete the job successfully. Creation, truncation and append actions occur as one atomic update upon job completion.
    AllowJaggedRows bool
    [Optional] Accept rows that are missing trailing optional columns. The missing values are treated as nulls. If false, records with missing trailing 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. Only applicable to CSV, ignored for other formats.
    AllowQuotedNewlines bool
    Indicates if BigQuery should allow quoted data sections that contain newline characters in a CSV file. The default value is false.
    Autodetect bool
    [Optional] Indicates if we should automatically infer the options and schema for CSV and JSON sources.
    Clustering ClusteringResponse
    [Beta] Clustering specification for the destination table. Must be specified with time-based partitioning, data in the table will be first partitioned and subsequently clustered.
    ConnectionProperties []ConnectionPropertyResponse
    Connection properties.
    CreateDisposition string
    [Optional] Specifies whether the job is allowed to create new tables. The following values are supported: CREATE_IF_NEEDED: If the table does not exist, BigQuery creates the table. CREATE_NEVER: The table must already exist. If it does not, a 'notFound' error is returned in the job result. The default value is CREATE_IF_NEEDED. Creation, truncation and append actions occur as one atomic update upon job completion.
    CreateSession bool
    If true, creates a new session, where session id will be a server generated random id. If false, runs query with an existing session_id passed in ConnectionProperty, otherwise runs the load job in non-session mode.
    DecimalTargetTypes []string
    [Optional] 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. Example: Suppose the value of this field is ["NUMERIC", "BIGNUMERIC"]. If (precision,scale) is: (38,9) -> NUMERIC; (39,9) -> BIGNUMERIC (NUMERIC cannot hold 30 integer digits); (38,10) -> BIGNUMERIC (NUMERIC cannot hold 10 fractional digits); (76,38) -> BIGNUMERIC; (77,38) -> BIGNUMERIC (error if value exeeds supported range). This field cannot contain duplicate types. The order of the types in this field is ignored. For example, ["BIGNUMERIC", "NUMERIC"] is the same as ["NUMERIC", "BIGNUMERIC"] and NUMERIC always takes precedence over BIGNUMERIC. Defaults to ["NUMERIC", "STRING"] for ORC and ["NUMERIC"] for the other file formats.
    DestinationEncryptionConfiguration EncryptionConfigurationResponse
    Custom encryption configuration (e.g., Cloud KMS keys).
    DestinationTable TableReferenceResponse
    [Required] The destination table to load the data into.
    DestinationTableProperties DestinationTablePropertiesResponse
    [Beta] [Optional] Properties with which to create the destination table if it is new.
    Encoding string
    [Optional] The character encoding of the data. The supported values are UTF-8 or ISO-8859-1. The default value is UTF-8. BigQuery decodes the data after the raw, binary data has been split using the values of the quote and fieldDelimiter properties.
    FieldDelimiter string
    [Optional] The separator for fields in a CSV file. The separator can be any ISO-8859-1 single-byte character. To use a character in the range 128-255, you must encode the character as UTF8. BigQuery converts the string to ISO-8859-1 encoding, and then uses the first byte of the encoded string to split the data in its raw, binary state. BigQuery also supports the escape sequence "\t" to specify a tab separator. The default value is a comma (',').
    FileSetSpecType string
    [Optional] Specifies how source URIs are interpreted for constructing the file set to load. By default source URIs are expanded against the underlying storage. Other options include specifying manifest files. Only applicable to object storage systems.
    HivePartitioningOptions HivePartitioningOptionsResponse
    [Optional] Options to configure hive partitioning support.
    IgnoreUnknownValues bool
    [Optional] 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. The sourceFormat property determines what BigQuery treats as an extra value: CSV: Trailing columns JSON: Named values that don't match any column names
    JsonExtension string
    [Optional] If sourceFormat is set to newline-delimited JSON, indicates whether it should be processed as a JSON variant such as GeoJSON. For a sourceFormat other than JSON, omit this field. If the sourceFormat is newline-delimited JSON: - for newline-delimited GeoJSON: set to GEOJSON.
    MaxBadRecords int
    [Optional] The maximum number of bad records that BigQuery can ignore when running the job. If the number of bad records exceeds this value, an invalid error is returned in the job result. This is only valid for CSV and JSON. The default value is 0, which requires that all records are valid.
    NullMarker string
    [Optional] Specifies a string that represents a null value in a CSV file. For example, if you specify "\N", BigQuery interprets "\N" as a null value when loading a CSV file. The default value is the empty string. If you set this property to a custom value, BigQuery throws an error if an empty string is present for all data types except for STRING and BYTE. For STRING and BYTE columns, BigQuery interprets the empty string as an empty value.
    ParquetOptions ParquetOptionsResponse
    [Optional] Options to configure parquet support.
    PreserveAsciiControlCharacters bool
    [Optional] Preserves the embedded ASCII control characters (the first 32 characters in the ASCII-table, from '\x00' to '\x1F') when loading from CSV. Only applicable to CSV, ignored for other formats.
    ProjectionFields []string
    If sourceFormat is set to "DATASTORE_BACKUP", indicates which entity properties to load into BigQuery from a Cloud Datastore backup. Property names are case sensitive and must be top-level properties. If no properties are specified, BigQuery loads all properties. If any named property isn't found in the Cloud Datastore backup, an invalid error is returned in the job result.
    Quote string
    [Optional] The value that is used to quote data sections in a CSV file. BigQuery converts the string to ISO-8859-1 encoding, and then uses the first byte of the encoded string to split the data in its raw, binary state. The default value is a double-quote ('"'). If your data does not contain quoted sections, set the property value to an empty string. If your data contains quoted newline characters, you must also set the allowQuotedNewlines property to true.
    RangePartitioning RangePartitioningResponse
    [TrustedTester] Range partitioning specification for this table. Only one of timePartitioning and rangePartitioning should be specified.
    ReferenceFileSchemaUri string
    User provided referencing file with the expected reader schema, Available for the format: AVRO, PARQUET, ORC.
    Schema TableSchemaResponse
    [Optional] The schema for the destination table. The schema can be omitted if the destination table already exists, or if you're loading data from Google Cloud Datastore.
    SchemaInline string
    [Deprecated] The inline schema. For CSV schemas, specify as "Field1:Type1[,Field2:Type2]*". For example, "foo:STRING, bar:INTEGER, baz:FLOAT".

    Deprecated: [Deprecated] The inline schema. For CSV schemas, specify as "Field1:Type1[,Field2:Type2]*". For example, "foo:STRING, bar:INTEGER, baz:FLOAT".

    SchemaInlineFormat string
    [Deprecated] The format of the schemaInline property.

    Deprecated: [Deprecated] The format of the schemaInline property.

    SchemaUpdateOptions []string
    Allows the schema of the destination table to be updated as a side effect of the load job if a schema is autodetected or supplied in the job configuration. Schema update options are supported in two cases: when writeDisposition is WRITE_APPEND; when writeDisposition is WRITE_TRUNCATE and the destination table is a partition of a table, specified by partition decorators. For normal tables, WRITE_TRUNCATE will always overwrite the schema. One or more of the following values are specified: ALLOW_FIELD_ADDITION: allow adding a nullable field to the schema. ALLOW_FIELD_RELAXATION: allow relaxing a required field in the original schema to nullable.
    SkipLeadingRows int
    [Optional] The number of rows at the top of a CSV file that BigQuery will skip when loading the data. The default value is 0. This property is useful if you have header rows in the file that should be skipped.
    SourceFormat string
    [Optional] The format of the data files. For CSV files, specify "CSV". For datastore backups, specify "DATASTORE_BACKUP". For newline-delimited JSON, specify "NEWLINE_DELIMITED_JSON". For Avro, specify "AVRO". For parquet, specify "PARQUET". For orc, specify "ORC". The default value is CSV.
    SourceUris []string
    [Required] The fully-qualified URIs that point to your data in Google Cloud. For Google Cloud Storage URIs: Each URI can contain one '' wildcard character and it must come after the 'bucket' name. Size limits related to load jobs apply to external data sources. For Google Cloud Bigtable URIs: Exactly one URI can be specified and it has be a fully specified and valid HTTPS URL for a Google Cloud Bigtable table. For Google Cloud Datastore backups: Exactly one URI can be specified. Also, the '' wildcard character is not allowed.
    TimePartitioning TimePartitioningResponse
    Time-based partitioning specification for the destination table. Only one of timePartitioning and rangePartitioning should be specified.
    UseAvroLogicalTypes bool
    [Optional] If sourceFormat is set to "AVRO", indicates whether to interpret logical types as the corresponding BigQuery data type (for example, TIMESTAMP), instead of using the raw type (for example, INTEGER).
    WriteDisposition string
    [Optional] Specifies the action that occurs if the destination table already exists. The following values are supported: WRITE_TRUNCATE: If the table already exists, BigQuery overwrites the table data. WRITE_APPEND: If the table already exists, BigQuery appends the data to the table. WRITE_EMPTY: If the table already exists and contains data, a 'duplicate' error is returned in the job result. The default value is WRITE_APPEND. Each action is atomic and only occurs if BigQuery is able to complete the job successfully. Creation, truncation and append actions occur as one atomic update upon job completion.
    allowJaggedRows Boolean
    [Optional] Accept rows that are missing trailing optional columns. The missing values are treated as nulls. If false, records with missing trailing 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. Only applicable to CSV, ignored for other formats.
    allowQuotedNewlines Boolean
    Indicates if BigQuery should allow quoted data sections that contain newline characters in a CSV file. The default value is false.
    autodetect Boolean
    [Optional] Indicates if we should automatically infer the options and schema for CSV and JSON sources.
    clustering ClusteringResponse
    [Beta] Clustering specification for the destination table. Must be specified with time-based partitioning, data in the table will be first partitioned and subsequently clustered.
    connectionProperties List<ConnectionPropertyResponse>
    Connection properties.
    createDisposition String
    [Optional] Specifies whether the job is allowed to create new tables. The following values are supported: CREATE_IF_NEEDED: If the table does not exist, BigQuery creates the table. CREATE_NEVER: The table must already exist. If it does not, a 'notFound' error is returned in the job result. The default value is CREATE_IF_NEEDED. Creation, truncation and append actions occur as one atomic update upon job completion.
    createSession Boolean
    If true, creates a new session, where session id will be a server generated random id. If false, runs query with an existing session_id passed in ConnectionProperty, otherwise runs the load job in non-session mode.
    decimalTargetTypes List<String>
    [Optional] 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. Example: Suppose the value of this field is ["NUMERIC", "BIGNUMERIC"]. If (precision,scale) is: (38,9) -> NUMERIC; (39,9) -> BIGNUMERIC (NUMERIC cannot hold 30 integer digits); (38,10) -> BIGNUMERIC (NUMERIC cannot hold 10 fractional digits); (76,38) -> BIGNUMERIC; (77,38) -> BIGNUMERIC (error if value exeeds supported range). This field cannot contain duplicate types. The order of the types in this field is ignored. For example, ["BIGNUMERIC", "NUMERIC"] is the same as ["NUMERIC", "BIGNUMERIC"] and NUMERIC always takes precedence over BIGNUMERIC. Defaults to ["NUMERIC", "STRING"] for ORC and ["NUMERIC"] for the other file formats.
    destinationEncryptionConfiguration EncryptionConfigurationResponse
    Custom encryption configuration (e.g., Cloud KMS keys).
    destinationTable TableReferenceResponse
    [Required] The destination table to load the data into.
    destinationTableProperties DestinationTablePropertiesResponse
    [Beta] [Optional] Properties with which to create the destination table if it is new.
    encoding String
    [Optional] The character encoding of the data. The supported values are UTF-8 or ISO-8859-1. The default value is UTF-8. BigQuery decodes the data after the raw, binary data has been split using the values of the quote and fieldDelimiter properties.
    fieldDelimiter String
    [Optional] The separator for fields in a CSV file. The separator can be any ISO-8859-1 single-byte character. To use a character in the range 128-255, you must encode the character as UTF8. BigQuery converts the string to ISO-8859-1 encoding, and then uses the first byte of the encoded string to split the data in its raw, binary state. BigQuery also supports the escape sequence "\t" to specify a tab separator. The default value is a comma (',').
    fileSetSpecType String
    [Optional] Specifies how source URIs are interpreted for constructing the file set to load. By default source URIs are expanded against the underlying storage. Other options include specifying manifest files. Only applicable to object storage systems.
    hivePartitioningOptions HivePartitioningOptionsResponse
    [Optional] Options to configure hive partitioning support.
    ignoreUnknownValues Boolean
    [Optional] 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. The sourceFormat property determines what BigQuery treats as an extra value: CSV: Trailing columns JSON: Named values that don't match any column names
    jsonExtension String
    [Optional] If sourceFormat is set to newline-delimited JSON, indicates whether it should be processed as a JSON variant such as GeoJSON. For a sourceFormat other than JSON, omit this field. If the sourceFormat is newline-delimited JSON: - for newline-delimited GeoJSON: set to GEOJSON.
    maxBadRecords Integer
    [Optional] The maximum number of bad records that BigQuery can ignore when running the job. If the number of bad records exceeds this value, an invalid error is returned in the job result. This is only valid for CSV and JSON. The default value is 0, which requires that all records are valid.
    nullMarker String
    [Optional] Specifies a string that represents a null value in a CSV file. For example, if you specify "\N", BigQuery interprets "\N" as a null value when loading a CSV file. The default value is the empty string. If you set this property to a custom value, BigQuery throws an error if an empty string is present for all data types except for STRING and BYTE. For STRING and BYTE columns, BigQuery interprets the empty string as an empty value.
    parquetOptions ParquetOptionsResponse
    [Optional] Options to configure parquet support.
    preserveAsciiControlCharacters Boolean
    [Optional] Preserves the embedded ASCII control characters (the first 32 characters in the ASCII-table, from '\x00' to '\x1F') when loading from CSV. Only applicable to CSV, ignored for other formats.
    projectionFields List<String>
    If sourceFormat is set to "DATASTORE_BACKUP", indicates which entity properties to load into BigQuery from a Cloud Datastore backup. Property names are case sensitive and must be top-level properties. If no properties are specified, BigQuery loads all properties. If any named property isn't found in the Cloud Datastore backup, an invalid error is returned in the job result.
    quote String
    [Optional] The value that is used to quote data sections in a CSV file. BigQuery converts the string to ISO-8859-1 encoding, and then uses the first byte of the encoded string to split the data in its raw, binary state. The default value is a double-quote ('"'). If your data does not contain quoted sections, set the property value to an empty string. If your data contains quoted newline characters, you must also set the allowQuotedNewlines property to true.
    rangePartitioning RangePartitioningResponse
    [TrustedTester] Range partitioning specification for this table. Only one of timePartitioning and rangePartitioning should be specified.
    referenceFileSchemaUri String
    User provided referencing file with the expected reader schema, Available for the format: AVRO, PARQUET, ORC.
    schema TableSchemaResponse
    [Optional] The schema for the destination table. The schema can be omitted if the destination table already exists, or if you're loading data from Google Cloud Datastore.
    schemaInline String
    [Deprecated] The inline schema. For CSV schemas, specify as "Field1:Type1[,Field2:Type2]*". For example, "foo:STRING, bar:INTEGER, baz:FLOAT".

    Deprecated: [Deprecated] The inline schema. For CSV schemas, specify as "Field1:Type1[,Field2:Type2]*". For example, "foo:STRING, bar:INTEGER, baz:FLOAT".

    schemaInlineFormat String
    [Deprecated] The format of the schemaInline property.

    Deprecated: [Deprecated] The format of the schemaInline property.

    schemaUpdateOptions List<String>
    Allows the schema of the destination table to be updated as a side effect of the load job if a schema is autodetected or supplied in the job configuration. Schema update options are supported in two cases: when writeDisposition is WRITE_APPEND; when writeDisposition is WRITE_TRUNCATE and the destination table is a partition of a table, specified by partition decorators. For normal tables, WRITE_TRUNCATE will always overwrite the schema. One or more of the following values are specified: ALLOW_FIELD_ADDITION: allow adding a nullable field to the schema. ALLOW_FIELD_RELAXATION: allow relaxing a required field in the original schema to nullable.
    skipLeadingRows Integer
    [Optional] The number of rows at the top of a CSV file that BigQuery will skip when loading the data. The default value is 0. This property is useful if you have header rows in the file that should be skipped.
    sourceFormat String
    [Optional] The format of the data files. For CSV files, specify "CSV". For datastore backups, specify "DATASTORE_BACKUP". For newline-delimited JSON, specify "NEWLINE_DELIMITED_JSON". For Avro, specify "AVRO". For parquet, specify "PARQUET". For orc, specify "ORC". The default value is CSV.
    sourceUris List<String>
    [Required] The fully-qualified URIs that point to your data in Google Cloud. For Google Cloud Storage URIs: Each URI can contain one '' wildcard character and it must come after the 'bucket' name. Size limits related to load jobs apply to external data sources. For Google Cloud Bigtable URIs: Exactly one URI can be specified and it has be a fully specified and valid HTTPS URL for a Google Cloud Bigtable table. For Google Cloud Datastore backups: Exactly one URI can be specified. Also, the '' wildcard character is not allowed.
    timePartitioning TimePartitioningResponse
    Time-based partitioning specification for the destination table. Only one of timePartitioning and rangePartitioning should be specified.
    useAvroLogicalTypes Boolean
    [Optional] If sourceFormat is set to "AVRO", indicates whether to interpret logical types as the corresponding BigQuery data type (for example, TIMESTAMP), instead of using the raw type (for example, INTEGER).
    writeDisposition String
    [Optional] Specifies the action that occurs if the destination table already exists. The following values are supported: WRITE_TRUNCATE: If the table already exists, BigQuery overwrites the table data. WRITE_APPEND: If the table already exists, BigQuery appends the data to the table. WRITE_EMPTY: If the table already exists and contains data, a 'duplicate' error is returned in the job result. The default value is WRITE_APPEND. Each action is atomic and only occurs if BigQuery is able to complete the job successfully. Creation, truncation and append actions occur as one atomic update upon job completion.
    allowJaggedRows boolean
    [Optional] Accept rows that are missing trailing optional columns. The missing values are treated as nulls. If false, records with missing trailing 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. Only applicable to CSV, ignored for other formats.
    allowQuotedNewlines boolean
    Indicates if BigQuery should allow quoted data sections that contain newline characters in a CSV file. The default value is false.
    autodetect boolean
    [Optional] Indicates if we should automatically infer the options and schema for CSV and JSON sources.
    clustering ClusteringResponse
    [Beta] Clustering specification for the destination table. Must be specified with time-based partitioning, data in the table will be first partitioned and subsequently clustered.
    connectionProperties ConnectionPropertyResponse[]
    Connection properties.
    createDisposition string
    [Optional] Specifies whether the job is allowed to create new tables. The following values are supported: CREATE_IF_NEEDED: If the table does not exist, BigQuery creates the table. CREATE_NEVER: The table must already exist. If it does not, a 'notFound' error is returned in the job result. The default value is CREATE_IF_NEEDED. Creation, truncation and append actions occur as one atomic update upon job completion.
    createSession boolean
    If true, creates a new session, where session id will be a server generated random id. If false, runs query with an existing session_id passed in ConnectionProperty, otherwise runs the load job in non-session mode.
    decimalTargetTypes string[]
    [Optional] 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. Example: Suppose the value of this field is ["NUMERIC", "BIGNUMERIC"]. If (precision,scale) is: (38,9) -> NUMERIC; (39,9) -> BIGNUMERIC (NUMERIC cannot hold 30 integer digits); (38,10) -> BIGNUMERIC (NUMERIC cannot hold 10 fractional digits); (76,38) -> BIGNUMERIC; (77,38) -> BIGNUMERIC (error if value exeeds supported range). This field cannot contain duplicate types. The order of the types in this field is ignored. For example, ["BIGNUMERIC", "NUMERIC"] is the same as ["NUMERIC", "BIGNUMERIC"] and NUMERIC always takes precedence over BIGNUMERIC. Defaults to ["NUMERIC", "STRING"] for ORC and ["NUMERIC"] for the other file formats.
    destinationEncryptionConfiguration EncryptionConfigurationResponse
    Custom encryption configuration (e.g., Cloud KMS keys).
    destinationTable TableReferenceResponse
    [Required] The destination table to load the data into.
    destinationTableProperties DestinationTablePropertiesResponse
    [Beta] [Optional] Properties with which to create the destination table if it is new.
    encoding string
    [Optional] The character encoding of the data. The supported values are UTF-8 or ISO-8859-1. The default value is UTF-8. BigQuery decodes the data after the raw, binary data has been split using the values of the quote and fieldDelimiter properties.
    fieldDelimiter string
    [Optional] The separator for fields in a CSV file. The separator can be any ISO-8859-1 single-byte character. To use a character in the range 128-255, you must encode the character as UTF8. BigQuery converts the string to ISO-8859-1 encoding, and then uses the first byte of the encoded string to split the data in its raw, binary state. BigQuery also supports the escape sequence "\t" to specify a tab separator. The default value is a comma (',').
    fileSetSpecType string
    [Optional] Specifies how source URIs are interpreted for constructing the file set to load. By default source URIs are expanded against the underlying storage. Other options include specifying manifest files. Only applicable to object storage systems.
    hivePartitioningOptions HivePartitioningOptionsResponse
    [Optional] Options to configure hive partitioning support.
    ignoreUnknownValues boolean
    [Optional] 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. The sourceFormat property determines what BigQuery treats as an extra value: CSV: Trailing columns JSON: Named values that don't match any column names
    jsonExtension string
    [Optional] If sourceFormat is set to newline-delimited JSON, indicates whether it should be processed as a JSON variant such as GeoJSON. For a sourceFormat other than JSON, omit this field. If the sourceFormat is newline-delimited JSON: - for newline-delimited GeoJSON: set to GEOJSON.
    maxBadRecords number
    [Optional] The maximum number of bad records that BigQuery can ignore when running the job. If the number of bad records exceeds this value, an invalid error is returned in the job result. This is only valid for CSV and JSON. The default value is 0, which requires that all records are valid.
    nullMarker string
    [Optional] Specifies a string that represents a null value in a CSV file. For example, if you specify "\N", BigQuery interprets "\N" as a null value when loading a CSV file. The default value is the empty string. If you set this property to a custom value, BigQuery throws an error if an empty string is present for all data types except for STRING and BYTE. For STRING and BYTE columns, BigQuery interprets the empty string as an empty value.
    parquetOptions ParquetOptionsResponse
    [Optional] Options to configure parquet support.
    preserveAsciiControlCharacters boolean
    [Optional] Preserves the embedded ASCII control characters (the first 32 characters in the ASCII-table, from '\x00' to '\x1F') when loading from CSV. Only applicable to CSV, ignored for other formats.
    projectionFields string[]
    If sourceFormat is set to "DATASTORE_BACKUP", indicates which entity properties to load into BigQuery from a Cloud Datastore backup. Property names are case sensitive and must be top-level properties. If no properties are specified, BigQuery loads all properties. If any named property isn't found in the Cloud Datastore backup, an invalid error is returned in the job result.
    quote string
    [Optional] The value that is used to quote data sections in a CSV file. BigQuery converts the string to ISO-8859-1 encoding, and then uses the first byte of the encoded string to split the data in its raw, binary state. The default value is a double-quote ('"'). If your data does not contain quoted sections, set the property value to an empty string. If your data contains quoted newline characters, you must also set the allowQuotedNewlines property to true.
    rangePartitioning RangePartitioningResponse
    [TrustedTester] Range partitioning specification for this table. Only one of timePartitioning and rangePartitioning should be specified.
    referenceFileSchemaUri string
    User provided referencing file with the expected reader schema, Available for the format: AVRO, PARQUET, ORC.
    schema TableSchemaResponse
    [Optional] The schema for the destination table. The schema can be omitted if the destination table already exists, or if you're loading data from Google Cloud Datastore.
    schemaInline string
    [Deprecated] The inline schema. For CSV schemas, specify as "Field1:Type1[,Field2:Type2]*". For example, "foo:STRING, bar:INTEGER, baz:FLOAT".

    Deprecated: [Deprecated] The inline schema. For CSV schemas, specify as "Field1:Type1[,Field2:Type2]*". For example, "foo:STRING, bar:INTEGER, baz:FLOAT".

    schemaInlineFormat string
    [Deprecated] The format of the schemaInline property.

    Deprecated: [Deprecated] The format of the schemaInline property.

    schemaUpdateOptions string[]
    Allows the schema of the destination table to be updated as a side effect of the load job if a schema is autodetected or supplied in the job configuration. Schema update options are supported in two cases: when writeDisposition is WRITE_APPEND; when writeDisposition is WRITE_TRUNCATE and the destination table is a partition of a table, specified by partition decorators. For normal tables, WRITE_TRUNCATE will always overwrite the schema. One or more of the following values are specified: ALLOW_FIELD_ADDITION: allow adding a nullable field to the schema. ALLOW_FIELD_RELAXATION: allow relaxing a required field in the original schema to nullable.
    skipLeadingRows number
    [Optional] The number of rows at the top of a CSV file that BigQuery will skip when loading the data. The default value is 0. This property is useful if you have header rows in the file that should be skipped.
    sourceFormat string
    [Optional] The format of the data files. For CSV files, specify "CSV". For datastore backups, specify "DATASTORE_BACKUP". For newline-delimited JSON, specify "NEWLINE_DELIMITED_JSON". For Avro, specify "AVRO". For parquet, specify "PARQUET". For orc, specify "ORC". The default value is CSV.
    sourceUris string[]
    [Required] The fully-qualified URIs that point to your data in Google Cloud. For Google Cloud Storage URIs: Each URI can contain one '' wildcard character and it must come after the 'bucket' name. Size limits related to load jobs apply to external data sources. For Google Cloud Bigtable URIs: Exactly one URI can be specified and it has be a fully specified and valid HTTPS URL for a Google Cloud Bigtable table. For Google Cloud Datastore backups: Exactly one URI can be specified. Also, the '' wildcard character is not allowed.
    timePartitioning TimePartitioningResponse
    Time-based partitioning specification for the destination table. Only one of timePartitioning and rangePartitioning should be specified.
    useAvroLogicalTypes boolean
    [Optional] If sourceFormat is set to "AVRO", indicates whether to interpret logical types as the corresponding BigQuery data type (for example, TIMESTAMP), instead of using the raw type (for example, INTEGER).
    writeDisposition string
    [Optional] Specifies the action that occurs if the destination table already exists. The following values are supported: WRITE_TRUNCATE: If the table already exists, BigQuery overwrites the table data. WRITE_APPEND: If the table already exists, BigQuery appends the data to the table. WRITE_EMPTY: If the table already exists and contains data, a 'duplicate' error is returned in the job result. The default value is WRITE_APPEND. Each action is atomic and only occurs if BigQuery is able to complete the job successfully. Creation, truncation and append actions occur as one atomic update upon job completion.
    allow_jagged_rows bool
    [Optional] Accept rows that are missing trailing optional columns. The missing values are treated as nulls. If false, records with missing trailing 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. Only applicable to CSV, ignored for other formats.
    allow_quoted_newlines bool
    Indicates if BigQuery should allow quoted data sections that contain newline characters in a CSV file. The default value is false.
    autodetect bool
    [Optional] Indicates if we should automatically infer the options and schema for CSV and JSON sources.
    clustering ClusteringResponse
    [Beta] Clustering specification for the destination table. Must be specified with time-based partitioning, data in the table will be first partitioned and subsequently clustered.
    connection_properties Sequence[ConnectionPropertyResponse]
    Connection properties.
    create_disposition str
    [Optional] Specifies whether the job is allowed to create new tables. The following values are supported: CREATE_IF_NEEDED: If the table does not exist, BigQuery creates the table. CREATE_NEVER: The table must already exist. If it does not, a 'notFound' error is returned in the job result. The default value is CREATE_IF_NEEDED. Creation, truncation and append actions occur as one atomic update upon job completion.
    create_session bool
    If true, creates a new session, where session id will be a server generated random id. If false, runs query with an existing session_id passed in ConnectionProperty, otherwise runs the load job in non-session mode.
    decimal_target_types Sequence[str]
    [Optional] 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. Example: Suppose the value of this field is ["NUMERIC", "BIGNUMERIC"]. If (precision,scale) is: (38,9) -> NUMERIC; (39,9) -> BIGNUMERIC (NUMERIC cannot hold 30 integer digits); (38,10) -> BIGNUMERIC (NUMERIC cannot hold 10 fractional digits); (76,38) -> BIGNUMERIC; (77,38) -> BIGNUMERIC (error if value exeeds supported range). This field cannot contain duplicate types. The order of the types in this field is ignored. For example, ["BIGNUMERIC", "NUMERIC"] is the same as ["NUMERIC", "BIGNUMERIC"] and NUMERIC always takes precedence over BIGNUMERIC. Defaults to ["NUMERIC", "STRING"] for ORC and ["NUMERIC"] for the other file formats.
    destination_encryption_configuration EncryptionConfigurationResponse
    Custom encryption configuration (e.g., Cloud KMS keys).
    destination_table TableReferenceResponse
    [Required] The destination table to load the data into.
    destination_table_properties DestinationTablePropertiesResponse
    [Beta] [Optional] Properties with which to create the destination table if it is new.
    encoding str
    [Optional] The character encoding of the data. The supported values are UTF-8 or ISO-8859-1. The default value is UTF-8. BigQuery decodes the data after the raw, binary data has been split using the values of the quote and fieldDelimiter properties.
    field_delimiter str
    [Optional] The separator for fields in a CSV file. The separator can be any ISO-8859-1 single-byte character. To use a character in the range 128-255, you must encode the character as UTF8. BigQuery converts the string to ISO-8859-1 encoding, and then uses the first byte of the encoded string to split the data in its raw, binary state. BigQuery also supports the escape sequence "\t" to specify a tab separator. The default value is a comma (',').
    file_set_spec_type str
    [Optional] Specifies how source URIs are interpreted for constructing the file set to load. By default source URIs are expanded against the underlying storage. Other options include specifying manifest files. Only applicable to object storage systems.
    hive_partitioning_options HivePartitioningOptionsResponse
    [Optional] Options to configure hive partitioning support.
    ignore_unknown_values bool
    [Optional] 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. The sourceFormat property determines what BigQuery treats as an extra value: CSV: Trailing columns JSON: Named values that don't match any column names
    json_extension str
    [Optional] If sourceFormat is set to newline-delimited JSON, indicates whether it should be processed as a JSON variant such as GeoJSON. For a sourceFormat other than JSON, omit this field. If the sourceFormat is newline-delimited JSON: - for newline-delimited GeoJSON: set to GEOJSON.
    max_bad_records int
    [Optional] The maximum number of bad records that BigQuery can ignore when running the job. If the number of bad records exceeds this value, an invalid error is returned in the job result. This is only valid for CSV and JSON. The default value is 0, which requires that all records are valid.
    null_marker str
    [Optional] Specifies a string that represents a null value in a CSV file. For example, if you specify "\N", BigQuery interprets "\N" as a null value when loading a CSV file. The default value is the empty string. If you set this property to a custom value, BigQuery throws an error if an empty string is present for all data types except for STRING and BYTE. For STRING and BYTE columns, BigQuery interprets the empty string as an empty value.
    parquet_options ParquetOptionsResponse
    [Optional] Options to configure parquet support.
    preserve_ascii_control_characters bool
    [Optional] Preserves the embedded ASCII control characters (the first 32 characters in the ASCII-table, from '\x00' to '\x1F') when loading from CSV. Only applicable to CSV, ignored for other formats.
    projection_fields Sequence[str]
    If sourceFormat is set to "DATASTORE_BACKUP", indicates which entity properties to load into BigQuery from a Cloud Datastore backup. Property names are case sensitive and must be top-level properties. If no properties are specified, BigQuery loads all properties. If any named property isn't found in the Cloud Datastore backup, an invalid error is returned in the job result.
    quote str
    [Optional] The value that is used to quote data sections in a CSV file. BigQuery converts the string to ISO-8859-1 encoding, and then uses the first byte of the encoded string to split the data in its raw, binary state. The default value is a double-quote ('"'). If your data does not contain quoted sections, set the property value to an empty string. If your data contains quoted newline characters, you must also set the allowQuotedNewlines property to true.
    range_partitioning RangePartitioningResponse
    [TrustedTester] Range partitioning specification for this table. Only one of timePartitioning and rangePartitioning should be specified.
    reference_file_schema_uri str
    User provided referencing file with the expected reader schema, Available for the format: AVRO, PARQUET, ORC.
    schema TableSchemaResponse
    [Optional] The schema for the destination table. The schema can be omitted if the destination table already exists, or if you're loading data from Google Cloud Datastore.
    schema_inline str
    [Deprecated] The inline schema. For CSV schemas, specify as "Field1:Type1[,Field2:Type2]*". For example, "foo:STRING, bar:INTEGER, baz:FLOAT".

    Deprecated: [Deprecated] The inline schema. For CSV schemas, specify as "Field1:Type1[,Field2:Type2]*". For example, "foo:STRING, bar:INTEGER, baz:FLOAT".

    schema_inline_format str
    [Deprecated] The format of the schemaInline property.

    Deprecated: [Deprecated] The format of the schemaInline property.

    schema_update_options Sequence[str]
    Allows the schema of the destination table to be updated as a side effect of the load job if a schema is autodetected or supplied in the job configuration. Schema update options are supported in two cases: when writeDisposition is WRITE_APPEND; when writeDisposition is WRITE_TRUNCATE and the destination table is a partition of a table, specified by partition decorators. For normal tables, WRITE_TRUNCATE will always overwrite the schema. One or more of the following values are specified: ALLOW_FIELD_ADDITION: allow adding a nullable field to the schema. ALLOW_FIELD_RELAXATION: allow relaxing a required field in the original schema to nullable.
    skip_leading_rows int
    [Optional] The number of rows at the top of a CSV file that BigQuery will skip when loading the data. The default value is 0. This property is useful if you have header rows in the file that should be skipped.
    source_format str
    [Optional] The format of the data files. For CSV files, specify "CSV". For datastore backups, specify "DATASTORE_BACKUP". For newline-delimited JSON, specify "NEWLINE_DELIMITED_JSON". For Avro, specify "AVRO". For parquet, specify "PARQUET". For orc, specify "ORC". The default value is CSV.
    source_uris Sequence[str]
    [Required] The fully-qualified URIs that point to your data in Google Cloud. For Google Cloud Storage URIs: Each URI can contain one '' wildcard character and it must come after the 'bucket' name. Size limits related to load jobs apply to external data sources. For Google Cloud Bigtable URIs: Exactly one URI can be specified and it has be a fully specified and valid HTTPS URL for a Google Cloud Bigtable table. For Google Cloud Datastore backups: Exactly one URI can be specified. Also, the '' wildcard character is not allowed.
    time_partitioning TimePartitioningResponse
    Time-based partitioning specification for the destination table. Only one of timePartitioning and rangePartitioning should be specified.
    use_avro_logical_types bool
    [Optional] If sourceFormat is set to "AVRO", indicates whether to interpret logical types as the corresponding BigQuery data type (for example, TIMESTAMP), instead of using the raw type (for example, INTEGER).
    write_disposition str
    [Optional] Specifies the action that occurs if the destination table already exists. The following values are supported: WRITE_TRUNCATE: If the table already exists, BigQuery overwrites the table data. WRITE_APPEND: If the table already exists, BigQuery appends the data to the table. WRITE_EMPTY: If the table already exists and contains data, a 'duplicate' error is returned in the job result. The default value is WRITE_APPEND. Each action is atomic and only occurs if BigQuery is able to complete the job successfully. Creation, truncation and append actions occur as one atomic update upon job completion.
    allowJaggedRows Boolean
    [Optional] Accept rows that are missing trailing optional columns. The missing values are treated as nulls. If false, records with missing trailing 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. Only applicable to CSV, ignored for other formats.
    allowQuotedNewlines Boolean
    Indicates if BigQuery should allow quoted data sections that contain newline characters in a CSV file. The default value is false.
    autodetect Boolean
    [Optional] Indicates if we should automatically infer the options and schema for CSV and JSON sources.
    clustering Property Map
    [Beta] Clustering specification for the destination table. Must be specified with time-based partitioning, data in the table will be first partitioned and subsequently clustered.
    connectionProperties List<Property Map>
    Connection properties.
    createDisposition String
    [Optional] Specifies whether the job is allowed to create new tables. The following values are supported: CREATE_IF_NEEDED: If the table does not exist, BigQuery creates the table. CREATE_NEVER: The table must already exist. If it does not, a 'notFound' error is returned in the job result. The default value is CREATE_IF_NEEDED. Creation, truncation and append actions occur as one atomic update upon job completion.
    createSession Boolean
    If true, creates a new session, where session id will be a server generated random id. If false, runs query with an existing session_id passed in ConnectionProperty, otherwise runs the load job in non-session mode.
    decimalTargetTypes List<String>
    [Optional] 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. Example: Suppose the value of this field is ["NUMERIC", "BIGNUMERIC"]. If (precision,scale) is: (38,9) -> NUMERIC; (39,9) -> BIGNUMERIC (NUMERIC cannot hold 30 integer digits); (38,10) -> BIGNUMERIC (NUMERIC cannot hold 10 fractional digits); (76,38) -> BIGNUMERIC; (77,38) -> BIGNUMERIC (error if value exeeds supported range). This field cannot contain duplicate types. The order of the types in this field is ignored. For example, ["BIGNUMERIC", "NUMERIC"] is the same as ["NUMERIC", "BIGNUMERIC"] and NUMERIC always takes precedence over BIGNUMERIC. Defaults to ["NUMERIC", "STRING"] for ORC and ["NUMERIC"] for the other file formats.
    destinationEncryptionConfiguration Property Map
    Custom encryption configuration (e.g., Cloud KMS keys).
    destinationTable Property Map
    [Required] The destination table to load the data into.
    destinationTableProperties Property Map
    [Beta] [Optional] Properties with which to create the destination table if it is new.
    encoding String
    [Optional] The character encoding of the data. The supported values are UTF-8 or ISO-8859-1. The default value is UTF-8. BigQuery decodes the data after the raw, binary data has been split using the values of the quote and fieldDelimiter properties.
    fieldDelimiter String
    [Optional] The separator for fields in a CSV file. The separator can be any ISO-8859-1 single-byte character. To use a character in the range 128-255, you must encode the character as UTF8. BigQuery converts the string to ISO-8859-1 encoding, and then uses the first byte of the encoded string to split the data in its raw, binary state. BigQuery also supports the escape sequence "\t" to specify a tab separator. The default value is a comma (',').
    fileSetSpecType String
    [Optional] Specifies how source URIs are interpreted for constructing the file set to load. By default source URIs are expanded against the underlying storage. Other options include specifying manifest files. Only applicable to object storage systems.
    hivePartitioningOptions Property Map
    [Optional] Options to configure hive partitioning support.
    ignoreUnknownValues Boolean
    [Optional] 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. The sourceFormat property determines what BigQuery treats as an extra value: CSV: Trailing columns JSON: Named values that don't match any column names
    jsonExtension String
    [Optional] If sourceFormat is set to newline-delimited JSON, indicates whether it should be processed as a JSON variant such as GeoJSON. For a sourceFormat other than JSON, omit this field. If the sourceFormat is newline-delimited JSON: - for newline-delimited GeoJSON: set to GEOJSON.
    maxBadRecords Number
    [Optional] The maximum number of bad records that BigQuery can ignore when running the job. If the number of bad records exceeds this value, an invalid error is returned in the job result. This is only valid for CSV and JSON. The default value is 0, which requires that all records are valid.
    nullMarker String
    [Optional] Specifies a string that represents a null value in a CSV file. For example, if you specify "\N", BigQuery interprets "\N" as a null value when loading a CSV file. The default value is the empty string. If you set this property to a custom value, BigQuery throws an error if an empty string is present for all data types except for STRING and BYTE. For STRING and BYTE columns, BigQuery interprets the empty string as an empty value.
    parquetOptions Property Map
    [Optional] Options to configure parquet support.
    preserveAsciiControlCharacters Boolean
    [Optional] Preserves the embedded ASCII control characters (the first 32 characters in the ASCII-table, from '\x00' to '\x1F') when loading from CSV. Only applicable to CSV, ignored for other formats.
    projectionFields List<String>
    If sourceFormat is set to "DATASTORE_BACKUP", indicates which entity properties to load into BigQuery from a Cloud Datastore backup. Property names are case sensitive and must be top-level properties. If no properties are specified, BigQuery loads all properties. If any named property isn't found in the Cloud Datastore backup, an invalid error is returned in the job result.
    quote String
    [Optional] The value that is used to quote data sections in a CSV file. BigQuery converts the string to ISO-8859-1 encoding, and then uses the first byte of the encoded string to split the data in its raw, binary state. The default value is a double-quote ('"'). If your data does not contain quoted sections, set the property value to an empty string. If your data contains quoted newline characters, you must also set the allowQuotedNewlines property to true.
    rangePartitioning Property Map
    [TrustedTester] Range partitioning specification for this table. Only one of timePartitioning and rangePartitioning should be specified.
    referenceFileSchemaUri String
    User provided referencing file with the expected reader schema, Available for the format: AVRO, PARQUET, ORC.
    schema Property Map
    [Optional] The schema for the destination table. The schema can be omitted if the destination table already exists, or if you're loading data from Google Cloud Datastore.
    schemaInline String
    [Deprecated] The inline schema. For CSV schemas, specify as "Field1:Type1[,Field2:Type2]*". For example, "foo:STRING, bar:INTEGER, baz:FLOAT".

    Deprecated: [Deprecated] The inline schema. For CSV schemas, specify as "Field1:Type1[,Field2:Type2]*". For example, "foo:STRING, bar:INTEGER, baz:FLOAT".

    schemaInlineFormat String
    [Deprecated] The format of the schemaInline property.

    Deprecated: [Deprecated] The format of the schemaInline property.

    schemaUpdateOptions List<String>
    Allows the schema of the destination table to be updated as a side effect of the load job if a schema is autodetected or supplied in the job configuration. Schema update options are supported in two cases: when writeDisposition is WRITE_APPEND; when writeDisposition is WRITE_TRUNCATE and the destination table is a partition of a table, specified by partition decorators. For normal tables, WRITE_TRUNCATE will always overwrite the schema. One or more of the following values are specified: ALLOW_FIELD_ADDITION: allow adding a nullable field to the schema. ALLOW_FIELD_RELAXATION: allow relaxing a required field in the original schema to nullable.
    skipLeadingRows Number
    [Optional] The number of rows at the top of a CSV file that BigQuery will skip when loading the data. The default value is 0. This property is useful if you have header rows in the file that should be skipped.
    sourceFormat String
    [Optional] The format of the data files. For CSV files, specify "CSV". For datastore backups, specify "DATASTORE_BACKUP". For newline-delimited JSON, specify "NEWLINE_DELIMITED_JSON". For Avro, specify "AVRO". For parquet, specify "PARQUET". For orc, specify "ORC". The default value is CSV.
    sourceUris List<String>
    [Required] The fully-qualified URIs that point to your data in Google Cloud. For Google Cloud Storage URIs: Each URI can contain one '' wildcard character and it must come after the 'bucket' name. Size limits related to load jobs apply to external data sources. For Google Cloud Bigtable URIs: Exactly one URI can be specified and it has be a fully specified and valid HTTPS URL for a Google Cloud Bigtable table. For Google Cloud Datastore backups: Exactly one URI can be specified. Also, the '' wildcard character is not allowed.
    timePartitioning Property Map
    Time-based partitioning specification for the destination table. Only one of timePartitioning and rangePartitioning should be specified.
    useAvroLogicalTypes Boolean
    [Optional] If sourceFormat is set to "AVRO", indicates whether to interpret logical types as the corresponding BigQuery data type (for example, TIMESTAMP), instead of using the raw type (for example, INTEGER).
    writeDisposition String
    [Optional] Specifies the action that occurs if the destination table already exists. The following values are supported: WRITE_TRUNCATE: If the table already exists, BigQuery overwrites the table data. WRITE_APPEND: If the table already exists, BigQuery appends the data to the table. WRITE_EMPTY: If the table already exists and contains data, a 'duplicate' error is returned in the job result. The default value is WRITE_APPEND. Each action is atomic and only occurs if BigQuery is able to complete the job successfully. Creation, truncation and append actions occur as one atomic update upon job completion.

    JobConfigurationQuery, JobConfigurationQueryArgs

    AllowLargeResults bool
    [Optional] If true and query uses legacy SQL dialect, allows the query to produce arbitrarily large result tables at a slight cost in performance. Requires destinationTable to be set. For standard SQL queries, this flag is ignored and large results are always allowed. However, you must still set destinationTable when result size exceeds the allowed maximum response size.
    Clustering Pulumi.GoogleNative.BigQuery.V2.Inputs.Clustering
    [Beta] Clustering specification for the destination table. Must be specified with time-based partitioning, data in the table will be first partitioned and subsequently clustered.
    ConnectionProperties List<Pulumi.GoogleNative.BigQuery.V2.Inputs.ConnectionProperty>
    Connection properties.
    Continuous bool
    [Optional] Specifies whether the query should be executed as a continuous query. The default value is false.
    CreateDisposition string
    [Optional] Specifies whether the job is allowed to create new tables. The following values are supported: CREATE_IF_NEEDED: If the table does not exist, BigQuery creates the table. CREATE_NEVER: The table must already exist. If it does not, a 'notFound' error is returned in the job result. The default value is CREATE_IF_NEEDED. Creation, truncation and append actions occur as one atomic update upon job completion.
    CreateSession bool
    If true, creates a new session, where session id will be a server generated random id. If false, runs query with an existing session_id passed in ConnectionProperty, otherwise runs query in non-session mode.
    DefaultDataset Pulumi.GoogleNative.BigQuery.V2.Inputs.DatasetReference
    [Optional] Specifies the default dataset to use for unqualified table names in the query. Note that this does not alter behavior of unqualified dataset names.
    DestinationEncryptionConfiguration Pulumi.GoogleNative.BigQuery.V2.Inputs.EncryptionConfiguration
    Custom encryption configuration (e.g., Cloud KMS keys).
    DestinationTable Pulumi.GoogleNative.BigQuery.V2.Inputs.TableReference
    [Optional] Describes the table where the query results should be stored. If not present, a new table will be created to store the results. This property must be set for large results that exceed the maximum response size.
    FlattenResults bool
    [Optional] If true and query uses legacy SQL dialect, flattens all nested and repeated fields in the query results. allowLargeResults must be true if this is set to false. For standard SQL queries, this flag is ignored and results are never flattened.
    MaximumBillingTier int
    [Optional] Limits the billing tier for this job. Queries that have resource usage beyond this tier will fail (without incurring a charge). If unspecified, this will be set to your project default.
    MaximumBytesBilled string
    [Optional] Limits the bytes billed for this job. Queries that will have bytes billed beyond this limit will fail (without incurring a charge). If unspecified, this will be set to your project default.
    ParameterMode string
    Standard SQL only. Set to POSITIONAL to use positional (?) query parameters or to NAMED to use named (@myparam) query parameters in this query.
    PreserveNulls bool
    [Deprecated] This property is deprecated.

    Deprecated: [Deprecated] This property is deprecated.

    Priority string
    [Optional] Specifies a priority for the query. Possible values include INTERACTIVE and BATCH. The default value is INTERACTIVE.
    Query string
    [Required] SQL query text to execute. The useLegacySql field can be used to indicate whether the query uses legacy SQL or standard SQL.
    QueryParameters List<Pulumi.GoogleNative.BigQuery.V2.Inputs.QueryParameter>
    Query parameters for standard SQL queries.
    RangePartitioning Pulumi.GoogleNative.BigQuery.V2.Inputs.RangePartitioning
    [TrustedTester] Range partitioning specification for this table. Only one of timePartitioning and rangePartitioning should be specified.
    SchemaUpdateOptions List<string>
    Allows the schema of the destination table to be updated as a side effect of the query job. Schema update options are supported in two cases: when writeDisposition is WRITE_APPEND; when writeDisposition is WRITE_TRUNCATE and the destination table is a partition of a table, specified by partition decorators. For normal tables, WRITE_TRUNCATE will always overwrite the schema. One or more of the following values are specified: ALLOW_FIELD_ADDITION: allow adding a nullable field to the schema. ALLOW_FIELD_RELAXATION: allow relaxing a required field in the original schema to nullable.
    TableDefinitions Dictionary<string, string>
    [Optional] If querying an external data source outside of BigQuery, describes the data format, location and other properties of the data source. By defining these properties, the data source can then be queried as if it were a standard BigQuery table.
    TimePartitioning Pulumi.GoogleNative.BigQuery.V2.Inputs.TimePartitioning
    Time-based partitioning specification for the destination table. Only one of timePartitioning and rangePartitioning should be specified.
    UseLegacySql bool
    Specifies whether to use BigQuery's legacy SQL dialect for this query. The default value is true. If set to false, the query will use BigQuery's standard SQL: https://cloud.google.com/bigquery/sql-reference/ When useLegacySql is set to false, the value of flattenResults is ignored; query will be run as if flattenResults is false.
    UseQueryCache bool
    [Optional] Whether to look for the result in the query cache. The query cache is a best-effort cache that will be flushed whenever tables in the query are modified. Moreover, the query cache is only available when a query does not have a destination table specified. The default value is true.
    UserDefinedFunctionResources List<Pulumi.GoogleNative.BigQuery.V2.Inputs.UserDefinedFunctionResource>
    Describes user-defined function resources used in the query.
    WriteDisposition string
    [Optional] Specifies the action that occurs if the destination table already exists. The following values are supported: WRITE_TRUNCATE: If the table already exists, BigQuery overwrites the table data and uses the schema from the query result. WRITE_APPEND: If the table already exists, BigQuery appends the data to the table. WRITE_EMPTY: If the table already exists and contains data, a 'duplicate' error is returned in the job result. The default value is WRITE_EMPTY. Each action is atomic and only occurs if BigQuery is able to complete the job successfully. Creation, truncation and append actions occur as one atomic update upon job completion.
    AllowLargeResults bool
    [Optional] If true and query uses legacy SQL dialect, allows the query to produce arbitrarily large result tables at a slight cost in performance. Requires destinationTable to be set. For standard SQL queries, this flag is ignored and large results are always allowed. However, you must still set destinationTable when result size exceeds the allowed maximum response size.
    Clustering Clustering
    [Beta] Clustering specification for the destination table. Must be specified with time-based partitioning, data in the table will be first partitioned and subsequently clustered.
    ConnectionProperties []ConnectionProperty
    Connection properties.
    Continuous bool
    [Optional] Specifies whether the query should be executed as a continuous query. The default value is false.
    CreateDisposition string
    [Optional] Specifies whether the job is allowed to create new tables. The following values are supported: CREATE_IF_NEEDED: If the table does not exist, BigQuery creates the table. CREATE_NEVER: The table must already exist. If it does not, a 'notFound' error is returned in the job result. The default value is CREATE_IF_NEEDED. Creation, truncation and append actions occur as one atomic update upon job completion.
    CreateSession bool
    If true, creates a new session, where session id will be a server generated random id. If false, runs query with an existing session_id passed in ConnectionProperty, otherwise runs query in non-session mode.
    DefaultDataset DatasetReference
    [Optional] Specifies the default dataset to use for unqualified table names in the query. Note that this does not alter behavior of unqualified dataset names.
    DestinationEncryptionConfiguration EncryptionConfiguration
    Custom encryption configuration (e.g., Cloud KMS keys).
    DestinationTable TableReference
    [Optional] Describes the table where the query results should be stored. If not present, a new table will be created to store the results. This property must be set for large results that exceed the maximum response size.
    FlattenResults bool
    [Optional] If true and query uses legacy SQL dialect, flattens all nested and repeated fields in the query results. allowLargeResults must be true if this is set to false. For standard SQL queries, this flag is ignored and results are never flattened.
    MaximumBillingTier int
    [Optional] Limits the billing tier for this job. Queries that have resource usage beyond this tier will fail (without incurring a charge). If unspecified, this will be set to your project default.
    MaximumBytesBilled string
    [Optional] Limits the bytes billed for this job. Queries that will have bytes billed beyond this limit will fail (without incurring a charge). If unspecified, this will be set to your project default.
    ParameterMode string
    Standard SQL only. Set to POSITIONAL to use positional (?) query parameters or to NAMED to use named (@myparam) query parameters in this query.
    PreserveNulls bool
    [Deprecated] This property is deprecated.

    Deprecated: [Deprecated] This property is deprecated.

    Priority string
    [Optional] Specifies a priority for the query. Possible values include INTERACTIVE and BATCH. The default value is INTERACTIVE.
    Query string
    [Required] SQL query text to execute. The useLegacySql field can be used to indicate whether the query uses legacy SQL or standard SQL.
    QueryParameters []QueryParameter
    Query parameters for standard SQL queries.
    RangePartitioning RangePartitioning
    [TrustedTester] Range partitioning specification for this table. Only one of timePartitioning and rangePartitioning should be specified.
    SchemaUpdateOptions []string
    Allows the schema of the destination table to be updated as a side effect of the query job. Schema update options are supported in two cases: when writeDisposition is WRITE_APPEND; when writeDisposition is WRITE_TRUNCATE and the destination table is a partition of a table, specified by partition decorators. For normal tables, WRITE_TRUNCATE will always overwrite the schema. One or more of the following values are specified: ALLOW_FIELD_ADDITION: allow adding a nullable field to the schema. ALLOW_FIELD_RELAXATION: allow relaxing a required field in the original schema to nullable.
    TableDefinitions map[string]string
    [Optional] If querying an external data source outside of BigQuery, describes the data format, location and other properties of the data source. By defining these properties, the data source can then be queried as if it were a standard BigQuery table.
    TimePartitioning TimePartitioning
    Time-based partitioning specification for the destination table. Only one of timePartitioning and rangePartitioning should be specified.
    UseLegacySql bool
    Specifies whether to use BigQuery's legacy SQL dialect for this query. The default value is true. If set to false, the query will use BigQuery's standard SQL: https://cloud.google.com/bigquery/sql-reference/ When useLegacySql is set to false, the value of flattenResults is ignored; query will be run as if flattenResults is false.
    UseQueryCache bool
    [Optional] Whether to look for the result in the query cache. The query cache is a best-effort cache that will be flushed whenever tables in the query are modified. Moreover, the query cache is only available when a query does not have a destination table specified. The default value is true.
    UserDefinedFunctionResources []UserDefinedFunctionResource
    Describes user-defined function resources used in the query.
    WriteDisposition string
    [Optional] Specifies the action that occurs if the destination table already exists. The following values are supported: WRITE_TRUNCATE: If the table already exists, BigQuery overwrites the table data and uses the schema from the query result. WRITE_APPEND: If the table already exists, BigQuery appends the data to the table. WRITE_EMPTY: If the table already exists and contains data, a 'duplicate' error is returned in the job result. The default value is WRITE_EMPTY. Each action is atomic and only occurs if BigQuery is able to complete the job successfully. Creation, truncation and append actions occur as one atomic update upon job completion.
    allowLargeResults Boolean
    [Optional] If true and query uses legacy SQL dialect, allows the query to produce arbitrarily large result tables at a slight cost in performance. Requires destinationTable to be set. For standard SQL queries, this flag is ignored and large results are always allowed. However, you must still set destinationTable when result size exceeds the allowed maximum response size.
    clustering Clustering
    [Beta] Clustering specification for the destination table. Must be specified with time-based partitioning, data in the table will be first partitioned and subsequently clustered.
    connectionProperties List<ConnectionProperty>
    Connection properties.
    continuous Boolean
    [Optional] Specifies whether the query should be executed as a continuous query. The default value is false.
    createDisposition String
    [Optional] Specifies whether the job is allowed to create new tables. The following values are supported: CREATE_IF_NEEDED: If the table does not exist, BigQuery creates the table. CREATE_NEVER: The table must already exist. If it does not, a 'notFound' error is returned in the job result. The default value is CREATE_IF_NEEDED. Creation, truncation and append actions occur as one atomic update upon job completion.
    createSession Boolean
    If true, creates a new session, where session id will be a server generated random id. If false, runs query with an existing session_id passed in ConnectionProperty, otherwise runs query in non-session mode.
    defaultDataset DatasetReference
    [Optional] Specifies the default dataset to use for unqualified table names in the query. Note that this does not alter behavior of unqualified dataset names.
    destinationEncryptionConfiguration EncryptionConfiguration
    Custom encryption configuration (e.g., Cloud KMS keys).
    destinationTable TableReference
    [Optional] Describes the table where the query results should be stored. If not present, a new table will be created to store the results. This property must be set for large results that exceed the maximum response size.
    flattenResults Boolean
    [Optional] If true and query uses legacy SQL dialect, flattens all nested and repeated fields in the query results. allowLargeResults must be true if this is set to false. For standard SQL queries, this flag is ignored and results are never flattened.
    maximumBillingTier Integer
    [Optional] Limits the billing tier for this job. Queries that have resource usage beyond this tier will fail (without incurring a charge). If unspecified, this will be set to your project default.
    maximumBytesBilled String
    [Optional] Limits the bytes billed for this job. Queries that will have bytes billed beyond this limit will fail (without incurring a charge). If unspecified, this will be set to your project default.
    parameterMode String
    Standard SQL only. Set to POSITIONAL to use positional (?) query parameters or to NAMED to use named (@myparam) query parameters in this query.
    preserveNulls Boolean
    [Deprecated] This property is deprecated.

    Deprecated: [Deprecated] This property is deprecated.

    priority String
    [Optional] Specifies a priority for the query. Possible values include INTERACTIVE and BATCH. The default value is INTERACTIVE.
    query String
    [Required] SQL query text to execute. The useLegacySql field can be used to indicate whether the query uses legacy SQL or standard SQL.
    queryParameters List<QueryParameter>
    Query parameters for standard SQL queries.
    rangePartitioning RangePartitioning
    [TrustedTester] Range partitioning specification for this table. Only one of timePartitioning and rangePartitioning should be specified.
    schemaUpdateOptions List<String>
    Allows the schema of the destination table to be updated as a side effect of the query job. Schema update options are supported in two cases: when writeDisposition is WRITE_APPEND; when writeDisposition is WRITE_TRUNCATE and the destination table is a partition of a table, specified by partition decorators. For normal tables, WRITE_TRUNCATE will always overwrite the schema. One or more of the following values are specified: ALLOW_FIELD_ADDITION: allow adding a nullable field to the schema. ALLOW_FIELD_RELAXATION: allow relaxing a required field in the original schema to nullable.
    tableDefinitions Map<String,String>
    [Optional] If querying an external data source outside of BigQuery, describes the data format, location and other properties of the data source. By defining these properties, the data source can then be queried as if it were a standard BigQuery table.
    timePartitioning TimePartitioning
    Time-based partitioning specification for the destination table. Only one of timePartitioning and rangePartitioning should be specified.
    useLegacySql Boolean
    Specifies whether to use BigQuery's legacy SQL dialect for this query. The default value is true. If set to false, the query will use BigQuery's standard SQL: https://cloud.google.com/bigquery/sql-reference/ When useLegacySql is set to false, the value of flattenResults is ignored; query will be run as if flattenResults is false.
    useQueryCache Boolean
    [Optional] Whether to look for the result in the query cache. The query cache is a best-effort cache that will be flushed whenever tables in the query are modified. Moreover, the query cache is only available when a query does not have a destination table specified. The default value is true.
    userDefinedFunctionResources List<UserDefinedFunctionResource>
    Describes user-defined function resources used in the query.
    writeDisposition String
    [Optional] Specifies the action that occurs if the destination table already exists. The following values are supported: WRITE_TRUNCATE: If the table already exists, BigQuery overwrites the table data and uses the schema from the query result. WRITE_APPEND: If the table already exists, BigQuery appends the data to the table. WRITE_EMPTY: If the table already exists and contains data, a 'duplicate' error is returned in the job result. The default value is WRITE_EMPTY. Each action is atomic and only occurs if BigQuery is able to complete the job successfully. Creation, truncation and append actions occur as one atomic update upon job completion.
    allowLargeResults boolean
    [Optional] If true and query uses legacy SQL dialect, allows the query to produce arbitrarily large result tables at a slight cost in performance. Requires destinationTable to be set. For standard SQL queries, this flag is ignored and large results are always allowed. However, you must still set destinationTable when result size exceeds the allowed maximum response size.
    clustering Clustering
    [Beta] Clustering specification for the destination table. Must be specified with time-based partitioning, data in the table will be first partitioned and subsequently clustered.
    connectionProperties ConnectionProperty[]
    Connection properties.
    continuous boolean
    [Optional] Specifies whether the query should be executed as a continuous query. The default value is false.
    createDisposition string
    [Optional] Specifies whether the job is allowed to create new tables. The following values are supported: CREATE_IF_NEEDED: If the table does not exist, BigQuery creates the table. CREATE_NEVER: The table must already exist. If it does not, a 'notFound' error is returned in the job result. The default value is CREATE_IF_NEEDED. Creation, truncation and append actions occur as one atomic update upon job completion.
    createSession boolean
    If true, creates a new session, where session id will be a server generated random id. If false, runs query with an existing session_id passed in ConnectionProperty, otherwise runs query in non-session mode.
    defaultDataset DatasetReference
    [Optional] Specifies the default dataset to use for unqualified table names in the query. Note that this does not alter behavior of unqualified dataset names.
    destinationEncryptionConfiguration EncryptionConfiguration
    Custom encryption configuration (e.g., Cloud KMS keys).
    destinationTable TableReference
    [Optional] Describes the table where the query results should be stored. If not present, a new table will be created to store the results. This property must be set for large results that exceed the maximum response size.
    flattenResults boolean
    [Optional] If true and query uses legacy SQL dialect, flattens all nested and repeated fields in the query results. allowLargeResults must be true if this is set to false. For standard SQL queries, this flag is ignored and results are never flattened.
    maximumBillingTier number
    [Optional] Limits the billing tier for this job. Queries that have resource usage beyond this tier will fail (without incurring a charge). If unspecified, this will be set to your project default.
    maximumBytesBilled string
    [Optional] Limits the bytes billed for this job. Queries that will have bytes billed beyond this limit will fail (without incurring a charge). If unspecified, this will be set to your project default.
    parameterMode string
    Standard SQL only. Set to POSITIONAL to use positional (?) query parameters or to NAMED to use named (@myparam) query parameters in this query.
    preserveNulls boolean
    [Deprecated] This property is deprecated.

    Deprecated: [Deprecated] This property is deprecated.

    priority string
    [Optional] Specifies a priority for the query. Possible values include INTERACTIVE and BATCH. The default value is INTERACTIVE.
    query string
    [Required] SQL query text to execute. The useLegacySql field can be used to indicate whether the query uses legacy SQL or standard SQL.
    queryParameters QueryParameter[]
    Query parameters for standard SQL queries.
    rangePartitioning RangePartitioning
    [TrustedTester] Range partitioning specification for this table. Only one of timePartitioning and rangePartitioning should be specified.
    schemaUpdateOptions string[]
    Allows the schema of the destination table to be updated as a side effect of the query job. Schema update options are supported in two cases: when writeDisposition is WRITE_APPEND; when writeDisposition is WRITE_TRUNCATE and the destination table is a partition of a table, specified by partition decorators. For normal tables, WRITE_TRUNCATE will always overwrite the schema. One or more of the following values are specified: ALLOW_FIELD_ADDITION: allow adding a nullable field to the schema. ALLOW_FIELD_RELAXATION: allow relaxing a required field in the original schema to nullable.
    tableDefinitions {[key: string]: string}
    [Optional] If querying an external data source outside of BigQuery, describes the data format, location and other properties of the data source. By defining these properties, the data source can then be queried as if it were a standard BigQuery table.
    timePartitioning TimePartitioning
    Time-based partitioning specification for the destination table. Only one of timePartitioning and rangePartitioning should be specified.
    useLegacySql boolean
    Specifies whether to use BigQuery's legacy SQL dialect for this query. The default value is true. If set to false, the query will use BigQuery's standard SQL: https://cloud.google.com/bigquery/sql-reference/ When useLegacySql is set to false, the value of flattenResults is ignored; query will be run as if flattenResults is false.
    useQueryCache boolean
    [Optional] Whether to look for the result in the query cache. The query cache is a best-effort cache that will be flushed whenever tables in the query are modified. Moreover, the query cache is only available when a query does not have a destination table specified. The default value is true.
    userDefinedFunctionResources UserDefinedFunctionResource[]
    Describes user-defined function resources used in the query.
    writeDisposition string
    [Optional] Specifies the action that occurs if the destination table already exists. The following values are supported: WRITE_TRUNCATE: If the table already exists, BigQuery overwrites the table data and uses the schema from the query result. WRITE_APPEND: If the table already exists, BigQuery appends the data to the table. WRITE_EMPTY: If the table already exists and contains data, a 'duplicate' error is returned in the job result. The default value is WRITE_EMPTY. Each action is atomic and only occurs if BigQuery is able to complete the job successfully. Creation, truncation and append actions occur as one atomic update upon job completion.
    allow_large_results bool
    [Optional] If true and query uses legacy SQL dialect, allows the query to produce arbitrarily large result tables at a slight cost in performance. Requires destinationTable to be set. For standard SQL queries, this flag is ignored and large results are always allowed. However, you must still set destinationTable when result size exceeds the allowed maximum response size.
    clustering Clustering
    [Beta] Clustering specification for the destination table. Must be specified with time-based partitioning, data in the table will be first partitioned and subsequently clustered.
    connection_properties Sequence[ConnectionProperty]
    Connection properties.
    continuous bool
    [Optional] Specifies whether the query should be executed as a continuous query. The default value is false.
    create_disposition str
    [Optional] Specifies whether the job is allowed to create new tables. The following values are supported: CREATE_IF_NEEDED: If the table does not exist, BigQuery creates the table. CREATE_NEVER: The table must already exist. If it does not, a 'notFound' error is returned in the job result. The default value is CREATE_IF_NEEDED. Creation, truncation and append actions occur as one atomic update upon job completion.
    create_session bool
    If true, creates a new session, where session id will be a server generated random id. If false, runs query with an existing session_id passed in ConnectionProperty, otherwise runs query in non-session mode.
    default_dataset DatasetReference
    [Optional] Specifies the default dataset to use for unqualified table names in the query. Note that this does not alter behavior of unqualified dataset names.
    destination_encryption_configuration EncryptionConfiguration
    Custom encryption configuration (e.g., Cloud KMS keys).
    destination_table TableReference
    [Optional] Describes the table where the query results should be stored. If not present, a new table will be created to store the results. This property must be set for large results that exceed the maximum response size.
    flatten_results bool
    [Optional] If true and query uses legacy SQL dialect, flattens all nested and repeated fields in the query results. allowLargeResults must be true if this is set to false. For standard SQL queries, this flag is ignored and results are never flattened.
    maximum_billing_tier int
    [Optional] Limits the billing tier for this job. Queries that have resource usage beyond this tier will fail (without incurring a charge). If unspecified, this will be set to your project default.
    maximum_bytes_billed str
    [Optional] Limits the bytes billed for this job. Queries that will have bytes billed beyond this limit will fail (without incurring a charge). If unspecified, this will be set to your project default.
    parameter_mode str
    Standard SQL only. Set to POSITIONAL to use positional (?) query parameters or to NAMED to use named (@myparam) query parameters in this query.
    preserve_nulls bool
    [Deprecated] This property is deprecated.

    Deprecated: [Deprecated] This property is deprecated.

    priority str
    [Optional] Specifies a priority for the query. Possible values include INTERACTIVE and BATCH. The default value is INTERACTIVE.
    query str
    [Required] SQL query text to execute. The useLegacySql field can be used to indicate whether the query uses legacy SQL or standard SQL.
    query_parameters Sequence[QueryParameter]
    Query parameters for standard SQL queries.
    range_partitioning RangePartitioning
    [TrustedTester] Range partitioning specification for this table. Only one of timePartitioning and rangePartitioning should be specified.
    schema_update_options Sequence[str]
    Allows the schema of the destination table to be updated as a side effect of the query job. Schema update options are supported in two cases: when writeDisposition is WRITE_APPEND; when writeDisposition is WRITE_TRUNCATE and the destination table is a partition of a table, specified by partition decorators. For normal tables, WRITE_TRUNCATE will always overwrite the schema. One or more of the following values are specified: ALLOW_FIELD_ADDITION: allow adding a nullable field to the schema. ALLOW_FIELD_RELAXATION: allow relaxing a required field in the original schema to nullable.
    table_definitions Mapping[str, str]
    [Optional] If querying an external data source outside of BigQuery, describes the data format, location and other properties of the data source. By defining these properties, the data source can then be queried as if it were a standard BigQuery table.
    time_partitioning TimePartitioning
    Time-based partitioning specification for the destination table. Only one of timePartitioning and rangePartitioning should be specified.
    use_legacy_sql bool
    Specifies whether to use BigQuery's legacy SQL dialect for this query. The default value is true. If set to false, the query will use BigQuery's standard SQL: https://cloud.google.com/bigquery/sql-reference/ When useLegacySql is set to false, the value of flattenResults is ignored; query will be run as if flattenResults is false.
    use_query_cache bool
    [Optional] Whether to look for the result in the query cache. The query cache is a best-effort cache that will be flushed whenever tables in the query are modified. Moreover, the query cache is only available when a query does not have a destination table specified. The default value is true.
    user_defined_function_resources Sequence[UserDefinedFunctionResource]
    Describes user-defined function resources used in the query.
    write_disposition str
    [Optional] Specifies the action that occurs if the destination table already exists. The following values are supported: WRITE_TRUNCATE: If the table already exists, BigQuery overwrites the table data and uses the schema from the query result. WRITE_APPEND: If the table already exists, BigQuery appends the data to the table. WRITE_EMPTY: If the table already exists and contains data, a 'duplicate' error is returned in the job result. The default value is WRITE_EMPTY. Each action is atomic and only occurs if BigQuery is able to complete the job successfully. Creation, truncation and append actions occur as one atomic update upon job completion.
    allowLargeResults Boolean
    [Optional] If true and query uses legacy SQL dialect, allows the query to produce arbitrarily large result tables at a slight cost in performance. Requires destinationTable to be set. For standard SQL queries, this flag is ignored and large results are always allowed. However, you must still set destinationTable when result size exceeds the allowed maximum response size.
    clustering Property Map
    [Beta] Clustering specification for the destination table. Must be specified with time-based partitioning, data in the table will be first partitioned and subsequently clustered.
    connectionProperties List<Property Map>
    Connection properties.
    continuous Boolean
    [Optional] Specifies whether the query should be executed as a continuous query. The default value is false.
    createDisposition String
    [Optional] Specifies whether the job is allowed to create new tables. The following values are supported: CREATE_IF_NEEDED: If the table does not exist, BigQuery creates the table. CREATE_NEVER: The table must already exist. If it does not, a 'notFound' error is returned in the job result. The default value is CREATE_IF_NEEDED. Creation, truncation and append actions occur as one atomic update upon job completion.
    createSession Boolean
    If true, creates a new session, where session id will be a server generated random id. If false, runs query with an existing session_id passed in ConnectionProperty, otherwise runs query in non-session mode.
    defaultDataset Property Map
    [Optional] Specifies the default dataset to use for unqualified table names in the query. Note that this does not alter behavior of unqualified dataset names.
    destinationEncryptionConfiguration Property Map
    Custom encryption configuration (e.g., Cloud KMS keys).
    destinationTable Property Map
    [Optional] Describes the table where the query results should be stored. If not present, a new table will be created to store the results. This property must be set for large results that exceed the maximum response size.
    flattenResults Boolean
    [Optional] If true and query uses legacy SQL dialect, flattens all nested and repeated fields in the query results. allowLargeResults must be true if this is set to false. For standard SQL queries, this flag is ignored and results are never flattened.
    maximumBillingTier Number
    [Optional] Limits the billing tier for this job. Queries that have resource usage beyond this tier will fail (without incurring a charge). If unspecified, this will be set to your project default.
    maximumBytesBilled String
    [Optional] Limits the bytes billed for this job. Queries that will have bytes billed beyond this limit will fail (without incurring a charge). If unspecified, this will be set to your project default.
    parameterMode String
    Standard SQL only. Set to POSITIONAL to use positional (?) query parameters or to NAMED to use named (@myparam) query parameters in this query.
    preserveNulls Boolean
    [Deprecated] This property is deprecated.

    Deprecated: [Deprecated] This property is deprecated.

    priority String
    [Optional] Specifies a priority for the query. Possible values include INTERACTIVE and BATCH. The default value is INTERACTIVE.
    query String
    [Required] SQL query text to execute. The useLegacySql field can be used to indicate whether the query uses legacy SQL or standard SQL.
    queryParameters List<Property Map>
    Query parameters for standard SQL queries.
    rangePartitioning Property Map
    [TrustedTester] Range partitioning specification for this table. Only one of timePartitioning and rangePartitioning should be specified.
    schemaUpdateOptions List<String>
    Allows the schema of the destination table to be updated as a side effect of the query job. Schema update options are supported in two cases: when writeDisposition is WRITE_APPEND; when writeDisposition is WRITE_TRUNCATE and the destination table is a partition of a table, specified by partition decorators. For normal tables, WRITE_TRUNCATE will always overwrite the schema. One or more of the following values are specified: ALLOW_FIELD_ADDITION: allow adding a nullable field to the schema. ALLOW_FIELD_RELAXATION: allow relaxing a required field in the original schema to nullable.
    tableDefinitions Map<String>
    [Optional] If querying an external data source outside of BigQuery, describes the data format, location and other properties of the data source. By defining these properties, the data source can then be queried as if it were a standard BigQuery table.
    timePartitioning Property Map
    Time-based partitioning specification for the destination table. Only one of timePartitioning and rangePartitioning should be specified.
    useLegacySql Boolean
    Specifies whether to use BigQuery's legacy SQL dialect for this query. The default value is true. If set to false, the query will use BigQuery's standard SQL: https://cloud.google.com/bigquery/sql-reference/ When useLegacySql is set to false, the value of flattenResults is ignored; query will be run as if flattenResults is false.
    useQueryCache Boolean
    [Optional] Whether to look for the result in the query cache. The query cache is a best-effort cache that will be flushed whenever tables in the query are modified. Moreover, the query cache is only available when a query does not have a destination table specified. The default value is true.
    userDefinedFunctionResources List<Property Map>
    Describes user-defined function resources used in the query.
    writeDisposition String
    [Optional] Specifies the action that occurs if the destination table already exists. The following values are supported: WRITE_TRUNCATE: If the table already exists, BigQuery overwrites the table data and uses the schema from the query result. WRITE_APPEND: If the table already exists, BigQuery appends the data to the table. WRITE_EMPTY: If the table already exists and contains data, a 'duplicate' error is returned in the job result. The default value is WRITE_EMPTY. Each action is atomic and only occurs if BigQuery is able to complete the job successfully. Creation, truncation and append actions occur as one atomic update upon job completion.

    JobConfigurationQueryResponse, JobConfigurationQueryResponseArgs

    AllowLargeResults bool
    [Optional] If true and query uses legacy SQL dialect, allows the query to produce arbitrarily large result tables at a slight cost in performance. Requires destinationTable to be set. For standard SQL queries, this flag is ignored and large results are always allowed. However, you must still set destinationTable when result size exceeds the allowed maximum response size.
    Clustering Pulumi.GoogleNative.BigQuery.V2.Inputs.ClusteringResponse
    [Beta] Clustering specification for the destination table. Must be specified with time-based partitioning, data in the table will be first partitioned and subsequently clustered.
    ConnectionProperties List<Pulumi.GoogleNative.BigQuery.V2.Inputs.ConnectionPropertyResponse>
    Connection properties.
    Continuous bool
    [Optional] Specifies whether the query should be executed as a continuous query. The default value is false.
    CreateDisposition string
    [Optional] Specifies whether the job is allowed to create new tables. The following values are supported: CREATE_IF_NEEDED: If the table does not exist, BigQuery creates the table. CREATE_NEVER: The table must already exist. If it does not, a 'notFound' error is returned in the job result. The default value is CREATE_IF_NEEDED. Creation, truncation and append actions occur as one atomic update upon job completion.
    CreateSession bool
    If true, creates a new session, where session id will be a server generated random id. If false, runs query with an existing session_id passed in ConnectionProperty, otherwise runs query in non-session mode.
    DefaultDataset Pulumi.GoogleNative.BigQuery.V2.Inputs.DatasetReferenceResponse
    [Optional] Specifies the default dataset to use for unqualified table names in the query. Note that this does not alter behavior of unqualified dataset names.
    DestinationEncryptionConfiguration Pulumi.GoogleNative.BigQuery.V2.Inputs.EncryptionConfigurationResponse
    Custom encryption configuration (e.g., Cloud KMS keys).
    DestinationTable Pulumi.GoogleNative.BigQuery.V2.Inputs.TableReferenceResponse
    [Optional] Describes the table where the query results should be stored. If not present, a new table will be created to store the results. This property must be set for large results that exceed the maximum response size.
    FlattenResults bool
    [Optional] If true and query uses legacy SQL dialect, flattens all nested and repeated fields in the query results. allowLargeResults must be true if this is set to false. For standard SQL queries, this flag is ignored and results are never flattened.
    MaximumBillingTier int
    [Optional] Limits the billing tier for this job. Queries that have resource usage beyond this tier will fail (without incurring a charge). If unspecified, this will be set to your project default.
    MaximumBytesBilled string
    [Optional] Limits the bytes billed for this job. Queries that will have bytes billed beyond this limit will fail (without incurring a charge). If unspecified, this will be set to your project default.
    ParameterMode string
    Standard SQL only. Set to POSITIONAL to use positional (?) query parameters or to NAMED to use named (@myparam) query parameters in this query.
    PreserveNulls bool
    [Deprecated] This property is deprecated.

    Deprecated: [Deprecated] This property is deprecated.

    Priority string
    [Optional] Specifies a priority for the query. Possible values include INTERACTIVE and BATCH. The default value is INTERACTIVE.
    Query string
    [Required] SQL query text to execute. The useLegacySql field can be used to indicate whether the query uses legacy SQL or standard SQL.
    QueryParameters List<Pulumi.GoogleNative.BigQuery.V2.Inputs.QueryParameterResponse>
    Query parameters for standard SQL queries.
    RangePartitioning Pulumi.GoogleNative.BigQuery.V2.Inputs.RangePartitioningResponse
    [TrustedTester] Range partitioning specification for this table. Only one of timePartitioning and rangePartitioning should be specified.
    SchemaUpdateOptions List<string>
    Allows the schema of the destination table to be updated as a side effect of the query job. Schema update options are supported in two cases: when writeDisposition is WRITE_APPEND; when writeDisposition is WRITE_TRUNCATE and the destination table is a partition of a table, specified by partition decorators. For normal tables, WRITE_TRUNCATE will always overwrite the schema. One or more of the following values are specified: ALLOW_FIELD_ADDITION: allow adding a nullable field to the schema. ALLOW_FIELD_RELAXATION: allow relaxing a required field in the original schema to nullable.
    TableDefinitions Dictionary<string, string>
    [Optional] If querying an external data source outside of BigQuery, describes the data format, location and other properties of the data source. By defining these properties, the data source can then be queried as if it were a standard BigQuery table.
    TimePartitioning Pulumi.GoogleNative.BigQuery.V2.Inputs.TimePartitioningResponse
    Time-based partitioning specification for the destination table. Only one of timePartitioning and rangePartitioning should be specified.
    UseLegacySql bool
    Specifies whether to use BigQuery's legacy SQL dialect for this query. The default value is true. If set to false, the query will use BigQuery's standard SQL: https://cloud.google.com/bigquery/sql-reference/ When useLegacySql is set to false, the value of flattenResults is ignored; query will be run as if flattenResults is false.
    UseQueryCache bool
    [Optional] Whether to look for the result in the query cache. The query cache is a best-effort cache that will be flushed whenever tables in the query are modified. Moreover, the query cache is only available when a query does not have a destination table specified. The default value is true.
    UserDefinedFunctionResources List<Pulumi.GoogleNative.BigQuery.V2.Inputs.UserDefinedFunctionResourceResponse>
    Describes user-defined function resources used in the query.
    WriteDisposition string
    [Optional] Specifies the action that occurs if the destination table already exists. The following values are supported: WRITE_TRUNCATE: If the table already exists, BigQuery overwrites the table data and uses the schema from the query result. WRITE_APPEND: If the table already exists, BigQuery appends the data to the table. WRITE_EMPTY: If the table already exists and contains data, a 'duplicate' error is returned in the job result. The default value is WRITE_EMPTY. Each action is atomic and only occurs if BigQuery is able to complete the job successfully. Creation, truncation and append actions occur as one atomic update upon job completion.
    AllowLargeResults bool
    [Optional] If true and query uses legacy SQL dialect, allows the query to produce arbitrarily large result tables at a slight cost in performance. Requires destinationTable to be set. For standard SQL queries, this flag is ignored and large results are always allowed. However, you must still set destinationTable when result size exceeds the allowed maximum response size.
    Clustering ClusteringResponse
    [Beta] Clustering specification for the destination table. Must be specified with time-based partitioning, data in the table will be first partitioned and subsequently clustered.
    ConnectionProperties []ConnectionPropertyResponse
    Connection properties.
    Continuous bool
    [Optional] Specifies whether the query should be executed as a continuous query. The default value is false.
    CreateDisposition string
    [Optional] Specifies whether the job is allowed to create new tables. The following values are supported: CREATE_IF_NEEDED: If the table does not exist, BigQuery creates the table. CREATE_NEVER: The table must already exist. If it does not, a 'notFound' error is returned in the job result. The default value is CREATE_IF_NEEDED. Creation, truncation and append actions occur as one atomic update upon job completion.
    CreateSession bool
    If true, creates a new session, where session id will be a server generated random id. If false, runs query with an existing session_id passed in ConnectionProperty, otherwise runs query in non-session mode.
    DefaultDataset DatasetReferenceResponse
    [Optional] Specifies the default dataset to use for unqualified table names in the query. Note that this does not alter behavior of unqualified dataset names.
    DestinationEncryptionConfiguration EncryptionConfigurationResponse
    Custom encryption configuration (e.g., Cloud KMS keys).
    DestinationTable TableReferenceResponse
    [Optional] Describes the table where the query results should be stored. If not present, a new table will be created to store the results. This property must be set for large results that exceed the maximum response size.
    FlattenResults bool
    [Optional] If true and query uses legacy SQL dialect, flattens all nested and repeated fields in the query results. allowLargeResults must be true if this is set to false. For standard SQL queries, this flag is ignored and results are never flattened.
    MaximumBillingTier int
    [Optional] Limits the billing tier for this job. Queries that have resource usage beyond this tier will fail (without incurring a charge). If unspecified, this will be set to your project default.
    MaximumBytesBilled string
    [Optional] Limits the bytes billed for this job. Queries that will have bytes billed beyond this limit will fail (without incurring a charge). If unspecified, this will be set to your project default.
    ParameterMode string
    Standard SQL only. Set to POSITIONAL to use positional (?) query parameters or to NAMED to use named (@myparam) query parameters in this query.
    PreserveNulls bool
    [Deprecated] This property is deprecated.

    Deprecated: [Deprecated] This property is deprecated.

    Priority string
    [Optional] Specifies a priority for the query. Possible values include INTERACTIVE and BATCH. The default value is INTERACTIVE.
    Query string
    [Required] SQL query text to execute. The useLegacySql field can be used to indicate whether the query uses legacy SQL or standard SQL.
    QueryParameters []QueryParameterResponse
    Query parameters for standard SQL queries.
    RangePartitioning RangePartitioningResponse
    [TrustedTester] Range partitioning specification for this table. Only one of timePartitioning and rangePartitioning should be specified.
    SchemaUpdateOptions []string
    Allows the schema of the destination table to be updated as a side effect of the query job. Schema update options are supported in two cases: when writeDisposition is WRITE_APPEND; when writeDisposition is WRITE_TRUNCATE and the destination table is a partition of a table, specified by partition decorators. For normal tables, WRITE_TRUNCATE will always overwrite the schema. One or more of the following values are specified: ALLOW_FIELD_ADDITION: allow adding a nullable field to the schema. ALLOW_FIELD_RELAXATION: allow relaxing a required field in the original schema to nullable.
    TableDefinitions map[string]string
    [Optional] If querying an external data source outside of BigQuery, describes the data format, location and other properties of the data source. By defining these properties, the data source can then be queried as if it were a standard BigQuery table.
    TimePartitioning TimePartitioningResponse
    Time-based partitioning specification for the destination table. Only one of timePartitioning and rangePartitioning should be specified.
    UseLegacySql bool
    Specifies whether to use BigQuery's legacy SQL dialect for this query. The default value is true. If set to false, the query will use BigQuery's standard SQL: https://cloud.google.com/bigquery/sql-reference/ When useLegacySql is set to false, the value of flattenResults is ignored; query will be run as if flattenResults is false.
    UseQueryCache bool
    [Optional] Whether to look for the result in the query cache. The query cache is a best-effort cache that will be flushed whenever tables in the query are modified. Moreover, the query cache is only available when a query does not have a destination table specified. The default value is true.
    UserDefinedFunctionResources []UserDefinedFunctionResourceResponse
    Describes user-defined function resources used in the query.
    WriteDisposition string
    [Optional] Specifies the action that occurs if the destination table already exists. The following values are supported: WRITE_TRUNCATE: If the table already exists, BigQuery overwrites the table data and uses the schema from the query result. WRITE_APPEND: If the table already exists, BigQuery appends the data to the table. WRITE_EMPTY: If the table already exists and contains data, a 'duplicate' error is returned in the job result. The default value is WRITE_EMPTY. Each action is atomic and only occurs if BigQuery is able to complete the job successfully. Creation, truncation and append actions occur as one atomic update upon job completion.
    allowLargeResults Boolean
    [Optional] If true and query uses legacy SQL dialect, allows the query to produce arbitrarily large result tables at a slight cost in performance. Requires destinationTable to be set. For standard SQL queries, this flag is ignored and large results are always allowed. However, you must still set destinationTable when result size exceeds the allowed maximum response size.
    clustering ClusteringResponse
    [Beta] Clustering specification for the destination table. Must be specified with time-based partitioning, data in the table will be first partitioned and subsequently clustered.
    connectionProperties List<ConnectionPropertyResponse>
    Connection properties.
    continuous Boolean
    [Optional] Specifies whether the query should be executed as a continuous query. The default value is false.
    createDisposition String
    [Optional] Specifies whether the job is allowed to create new tables. The following values are supported: CREATE_IF_NEEDED: If the table does not exist, BigQuery creates the table. CREATE_NEVER: The table must already exist. If it does not, a 'notFound' error is returned in the job result. The default value is CREATE_IF_NEEDED. Creation, truncation and append actions occur as one atomic update upon job completion.
    createSession Boolean
    If true, creates a new session, where session id will be a server generated random id. If false, runs query with an existing session_id passed in ConnectionProperty, otherwise runs query in non-session mode.
    defaultDataset DatasetReferenceResponse
    [Optional] Specifies the default dataset to use for unqualified table names in the query. Note that this does not alter behavior of unqualified dataset names.
    destinationEncryptionConfiguration EncryptionConfigurationResponse
    Custom encryption configuration (e.g., Cloud KMS keys).
    destinationTable TableReferenceResponse
    [Optional] Describes the table where the query results should be stored. If not present, a new table will be created to store the results. This property must be set for large results that exceed the maximum response size.
    flattenResults Boolean
    [Optional] If true and query uses legacy SQL dialect, flattens all nested and repeated fields in the query results. allowLargeResults must be true if this is set to false. For standard SQL queries, this flag is ignored and results are never flattened.
    maximumBillingTier Integer
    [Optional] Limits the billing tier for this job. Queries that have resource usage beyond this tier will fail (without incurring a charge). If unspecified, this will be set to your project default.
    maximumBytesBilled String
    [Optional] Limits the bytes billed for this job. Queries that will have bytes billed beyond this limit will fail (without incurring a charge). If unspecified, this will be set to your project default.
    parameterMode String
    Standard SQL only. Set to POSITIONAL to use positional (?) query parameters or to NAMED to use named (@myparam) query parameters in this query.
    preserveNulls Boolean
    [Deprecated] This property is deprecated.

    Deprecated: [Deprecated] This property is deprecated.

    priority String
    [Optional] Specifies a priority for the query. Possible values include INTERACTIVE and BATCH. The default value is INTERACTIVE.
    query String
    [Required] SQL query text to execute. The useLegacySql field can be used to indicate whether the query uses legacy SQL or standard SQL.
    queryParameters List<QueryParameterResponse>
    Query parameters for standard SQL queries.
    rangePartitioning RangePartitioningResponse
    [TrustedTester] Range partitioning specification for this table. Only one of timePartitioning and rangePartitioning should be specified.
    schemaUpdateOptions List<String>
    Allows the schema of the destination table to be updated as a side effect of the query job. Schema update options are supported in two cases: when writeDisposition is WRITE_APPEND; when writeDisposition is WRITE_TRUNCATE and the destination table is a partition of a table, specified by partition decorators. For normal tables, WRITE_TRUNCATE will always overwrite the schema. One or more of the following values are specified: ALLOW_FIELD_ADDITION: allow adding a nullable field to the schema. ALLOW_FIELD_RELAXATION: allow relaxing a required field in the original schema to nullable.
    tableDefinitions Map<String,String>
    [Optional] If querying an external data source outside of BigQuery, describes the data format, location and other properties of the data source. By defining these properties, the data source can then be queried as if it were a standard BigQuery table.
    timePartitioning TimePartitioningResponse
    Time-based partitioning specification for the destination table. Only one of timePartitioning and rangePartitioning should be specified.
    useLegacySql Boolean
    Specifies whether to use BigQuery's legacy SQL dialect for this query. The default value is true. If set to false, the query will use BigQuery's standard SQL: https://cloud.google.com/bigquery/sql-reference/ When useLegacySql is set to false, the value of flattenResults is ignored; query will be run as if flattenResults is false.
    useQueryCache Boolean
    [Optional] Whether to look for the result in the query cache. The query cache is a best-effort cache that will be flushed whenever tables in the query are modified. Moreover, the query cache is only available when a query does not have a destination table specified. The default value is true.
    userDefinedFunctionResources List<UserDefinedFunctionResourceResponse>
    Describes user-defined function resources used in the query.
    writeDisposition String
    [Optional] Specifies the action that occurs if the destination table already exists. The following values are supported: WRITE_TRUNCATE: If the table already exists, BigQuery overwrites the table data and uses the schema from the query result. WRITE_APPEND: If the table already exists, BigQuery appends the data to the table. WRIT