Google Sheets connection options - Amazon Glue
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Google Sheets connection options

The following are connection options for Google Sheets:

  • ENTITY_NAME(String) - (Required) Used for Read. The SpreadSheet ID and sheetTabName in Google Sheets. Example: {SpreadSheetID}#{SheetTabName}.

  • API_VERSION(String) - (Required) Used for Read. Google Sheets Rest API version you want to use.

  • SELECTED_FIELDS(List<String>) - Default: empty(SELECT *). Used for Read. Columns you want to select for the object.

  • FILTER_PREDICATE(String) - Default: empty. Used for Read. It should be in the Spark SQL format.

  • QUERY(String) - Default: empty. Used for Read. Full Spark SQL query.

  • NUM_PARTITIONS(Integer) - Default: 1. Used for Read. Number of partitions for read.