SQL Server BIGINT Columns Are Converted to TEXT in Snowflake

Issue

Columns defined as the BIGINT data type in SQL Server are unexpectedly converted to TEXT in Snowflake, causing issues with downstream data processing.

Environment

• Connector: SQL Server
• Destination: Snowflake

Resolution

To resolve this issue, drop the affected table in Snowflake and perform a table-level re-sync in Fivetran. To learn more, see How to Trigger Historical Re-Syncs for Fivetran Connections and Tables.

If the issue persists, contact Fivetran support with schema details and any relevant logs.

Cause

We don't support narrowing data type changes, such as from VARCHAR to BIGINT, but we do support widening conversions, such as from BIGINT to VARCHAR. If a column was previously defined as a broader type, we may retain a more compatible type, such as TEXT in Snowflake, to preserve compatibility.

For more information on our SQL Server data type transformation and mapping, see our SQL Server schema information.