Error: Invalid Table ID

Issue

Syncs fail with the following error:

Invalid table ID "<example_file> - Conversion_ILA".

Environment

Destination: BigQuery

Resolution

To resolve this issue, choose one of the following options:

• Rename the source table or file to use only letters, numbers, and underscores.
• Create a new connection and select the Fivetran naming convention during setup to automatically sanitize table and file names.

Cause

This issue occurs when a source table or file name contains characters that BigQuery doesn't support, such as spaces, periods (.), hyphens (-), or other special characters.

BigQuery table IDs can only contain letters, numbers, and underscores. When a source table or file name contains unsupported characters, BigQuery can't create the destination table, resulting in the above error.

For more information, see the BigQuery Identifiers documentation.