Export.table.toBigQuery

  • Exports a FeatureCollection to a BigQuery table using a batch task, accessible via the Tasks tab.

  • This feature is currently in Preview, so the API and behavior are subject to change.

  • Users can customize export options, such as table name, overwriting or appending data, selecting properties, and setting task priority.

  • Refer to the provided link for detailed information and guidance on exporting to BigQuery.

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.