Limitations for Google Sheets connector - AWS Glue

Limitations for Google Sheets connector

The following are limitations for the Google Sheets connector:

  • Google Sheets connector does not support Filters. Hence, filter based partitioning cannot be supported.

  • In Record Base Partitioning, there is no provision to return exact record count by SAAS. As a result, there can be scenarios where files with empty records are created.

  • Since the Google Sheets connector does not support filter-based partitioning, partitionField, lowerbound, and upperbound are not valid connection options. If these options are provided, the AWS Glue job is expected to fail.