Export.table.toBigQuery

  • The Export.table.toBigQuery function creates a batch task to export a FeatureCollection to BigQuery.

  • This feature is in Preview and its API and behavior may change.

  • The function requires a collection argument of type FeatureCollection and has several optional arguments for controlling the export behavior, such as description, table, overwrite, append, selectors, maxVertices, and priority.

Creates a batch task to export a FeatureCollection to BigQuery. Tasks can be started from the Tasks tab.

Note that this feature is in Preview, and the API and behavior may change significantly. For more information, see https://developers.google.com/earth-engine/guides/export_to_bigquery

UsageReturns
Export.table.toBigQuery(collection, description, table, overwrite, append, selectors, maxVertices, priority)
ArgumentTypeDetails
collectionFeatureCollectionThe feature collection to export.
descriptionString, optionalA human-readable name of the task. Defaults to "myExportTableTask".
tableString, optionalThe fully-qualifed BigQuery destination table in the following format: "project_id.dataset_id.table_id".
overwriteBoolean, optionalWhether the existing table should be overwritten by the result of this export. Defaults to false. The `overwrite` and `append` parameters cannot be `true` simultaneously. The export fails if the table already exists and both `overwrite` and `append` are `false`.
appendBoolean, optionalWhether table data should be appended if the table already exists and has a compatible schema. Defaults to false. The `overwrite` and `append` parameters cannot be `true` simultaneously. The export fails if the table already exists and both `overwrite` and `append` are `false`.
selectorsList<String>|String, optionalA list of properties to include in the export; either a single string with comma-separated names or a list of strings.
maxVerticesNumber, optionalMax number of uncut vertices per geometry; geometries with more vertices will be cut into pieces smaller than this size.
priorityNumber, optionalThe priority of the task within the project. Higher priority tasks are scheduled sooner. Must be an integer between 0 and 9999. Defaults to 100.