All Downloads are FREE. Search and download functionalities are using the official Maven repository.

target.apidocs.com.google.api.services.bigquery.model.ExternalDataConfiguration.html Maven / Gradle / Ivy

There is a newer version: v2-rev20241222-2.0.0
Show newest version






ExternalDataConfiguration (BigQuery API v2-rev20201022-1.30.10)












com.google.api.services.bigquery.model

Class ExternalDataConfiguration

    • Constructor Detail

      • ExternalDataConfiguration

        public ExternalDataConfiguration()
    • Method Detail

      • getAutodetect

        public Boolean getAutodetect()
        Try to detect schema and format options automatically. Any option specified explicitly will be honored.
        Returns:
        value or null for none
      • setAutodetect

        public ExternalDataConfiguration setAutodetect(Boolean autodetect)
        Try to detect schema and format options automatically. Any option specified explicitly will be honored.
        Parameters:
        autodetect - autodetect or null for none
      • getBigtableOptions

        public BigtableOptions getBigtableOptions()
        [Optional] Additional options if sourceFormat is set to BIGTABLE.
        Returns:
        value or null for none
      • setBigtableOptions

        public ExternalDataConfiguration setBigtableOptions(BigtableOptions bigtableOptions)
        [Optional] Additional options if sourceFormat is set to BIGTABLE.
        Parameters:
        bigtableOptions - bigtableOptions or null for none
      • getCompression

        public String getCompression()
        [Optional] The compression type of the data source. Possible values include GZIP and NONE. The default value is NONE. This setting is ignored for Google Cloud Bigtable, Google Cloud Datastore backups and Avro formats.
        Returns:
        value or null for none
      • setCompression

        public ExternalDataConfiguration setCompression(String compression)
        [Optional] The compression type of the data source. Possible values include GZIP and NONE. The default value is NONE. This setting is ignored for Google Cloud Bigtable, Google Cloud Datastore backups and Avro formats.
        Parameters:
        compression - compression or null for none
      • getConnectionId

        public String getConnectionId()
        [Optional, Trusted Tester] Connection for external data source.
        Returns:
        value or null for none
      • setConnectionId

        public ExternalDataConfiguration setConnectionId(String connectionId)
        [Optional, Trusted Tester] Connection for external data source.
        Parameters:
        connectionId - connectionId or null for none
      • getCsvOptions

        public CsvOptions getCsvOptions()
        Additional properties to set if sourceFormat is set to CSV.
        Returns:
        value or null for none
      • setCsvOptions

        public ExternalDataConfiguration setCsvOptions(CsvOptions csvOptions)
        Additional properties to set if sourceFormat is set to CSV.
        Parameters:
        csvOptions - csvOptions or null for none
      • getGoogleSheetsOptions

        public GoogleSheetsOptions getGoogleSheetsOptions()
        [Optional] Additional options if sourceFormat is set to GOOGLE_SHEETS.
        Returns:
        value or null for none
      • setGoogleSheetsOptions

        public ExternalDataConfiguration setGoogleSheetsOptions(GoogleSheetsOptions googleSheetsOptions)
        [Optional] Additional options if sourceFormat is set to GOOGLE_SHEETS.
        Parameters:
        googleSheetsOptions - googleSheetsOptions or null for none
      • getHivePartitioningOptions

        public HivePartitioningOptions getHivePartitioningOptions()
        [Optional, Trusted Tester] Options to configure hive partitioning support.
        Returns:
        value or null for none
      • setHivePartitioningOptions

        public ExternalDataConfiguration setHivePartitioningOptions(HivePartitioningOptions hivePartitioningOptions)
        [Optional, Trusted Tester] Options to configure hive partitioning support.
        Parameters:
        hivePartitioningOptions - hivePartitioningOptions or null for none
      • getIgnoreUnknownValues

        public Boolean getIgnoreUnknownValues()
        [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 Google Cloud Bigtable: This setting is ignored. Google Cloud Datastore backups: This setting is ignored. Avro: This setting is ignored.
        Returns:
        value or null for none
      • setIgnoreUnknownValues

        public ExternalDataConfiguration setIgnoreUnknownValues(Boolean ignoreUnknownValues)
        [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 Google Cloud Bigtable: This setting is ignored. Google Cloud Datastore backups: This setting is ignored. Avro: This setting is ignored.
        Parameters:
        ignoreUnknownValues - ignoreUnknownValues or null for none
      • getMaxBadRecords

        public Integer getMaxBadRecords()
        [Optional] The maximum number of bad records that BigQuery can ignore when reading data. If the number of bad records exceeds this value, an invalid error is returned in the job result. This is only valid for CSV, JSON, and Google Sheets. The default value is 0, which requires that all records are valid. This setting is ignored for Google Cloud Bigtable, Google Cloud Datastore backups and Avro formats.
        Returns:
        value or null for none
      • setMaxBadRecords

        public ExternalDataConfiguration setMaxBadRecords(Integer maxBadRecords)
        [Optional] The maximum number of bad records that BigQuery can ignore when reading data. If the number of bad records exceeds this value, an invalid error is returned in the job result. This is only valid for CSV, JSON, and Google Sheets. The default value is 0, which requires that all records are valid. This setting is ignored for Google Cloud Bigtable, Google Cloud Datastore backups and Avro formats.
        Parameters:
        maxBadRecords - maxBadRecords or null for none
      • getSchema

        public TableSchema getSchema()
        [Optional] The schema for the data. Schema is required for CSV and JSON formats. Schema is disallowed for Google Cloud Bigtable, Cloud Datastore backups, and Avro formats.
        Returns:
        value or null for none
      • setSchema

        public ExternalDataConfiguration setSchema(TableSchema schema)
        [Optional] The schema for the data. Schema is required for CSV and JSON formats. Schema is disallowed for Google Cloud Bigtable, Cloud Datastore backups, and Avro formats.
        Parameters:
        schema - schema or null for none
      • getSourceFormat

        public String getSourceFormat()
        [Required] The data format. For CSV files, specify "CSV". For Google sheets, specify "GOOGLE_SHEETS". For newline-delimited JSON, specify "NEWLINE_DELIMITED_JSON". For Avro files, specify "AVRO". For Google Cloud Datastore backups, specify "DATASTORE_BACKUP". [Beta] For Google Cloud Bigtable, specify "BIGTABLE".
        Returns:
        value or null for none
      • setSourceFormat

        public ExternalDataConfiguration setSourceFormat(String sourceFormat)
        [Required] The data format. For CSV files, specify "CSV". For Google sheets, specify "GOOGLE_SHEETS". For newline-delimited JSON, specify "NEWLINE_DELIMITED_JSON". For Avro files, specify "AVRO". For Google Cloud Datastore backups, specify "DATASTORE_BACKUP". [Beta] For Google Cloud Bigtable, specify "BIGTABLE".
        Parameters:
        sourceFormat - sourceFormat or null for none
      • getSourceUris

        public List<String> getSourceUris()
        [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.
        Returns:
        value or null for none
      • setSourceUris

        public ExternalDataConfiguration setSourceUris(List<String> sourceUris)
        [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.
        Parameters:
        sourceUris - sourceUris or null for none

Copyright © 2011–2020 Google. All rights reserved.





© 2015 - 2025 Weber Informatics LLC | Privacy Policy