Error: Invalid Schema or Table Name
Issue
While completing the setup form, the Destination schema field pre-populates with my schema name in light gray, which adheres to Fivetran's naming convention. However, the following error appears:
Invalid schema or table name. Schema and table shouldn't be empty, should contain only letters, numbers, or underscores, and cannot begin with a number.
Environment
Connector: Google Sheets
Resolution
To resolve this issue, manually enter your destination schema name in the Destination schema field, then click Save & Test.
Cause
Though we populate the destination schema name in light gray in the Destination schema field, you must still enter it manually.