Snowflake troubleshooting

Change data not available

The start timestamp is prior to the data retention period

Check if the StartTimestamp mentioned is within the Data Retention Period in Snowflake and update the StartTimestamp property accordingly.

Check the retention period configured using:

SHOW PARAMETERS LIKE 'DATA_RETENTION_TIME_IN_DAYS' IN ACCOUNT;

You can also increase the data retention time using the following command to avoid similar issues in future:

ALTER TABLE {table name} SET DATA_RETENTION_TIME_IN_DAYS={NUMBER_OF_DAYS};

Three part name is not supported

Three part name is mentioned in the Tables/Excluded Tables Property but SnowflakeReader supports reading only from Single Database and expects DatabaseName to be available as a part of the Connection URL and not as a part of Tables/Excluded Tables property

Please mention the Database Name in the Connection URL and only the Schema and Table Name in the Tables/Excluded Tables property

Invalid CDDLAction

Provided value for the property CDDLAction is invalid

Check for empty spaces in CDDLAction property.

Supported CDDLActions are :

Process, Ignore, Quiesce, Quiesce_Cascade, Halt

Insufficient Privileges

The role associated with the user doesn't have OWNERSHIP privilege on the interested tables to enable change tracking

If you prefer SnowflakeReader to enable change tracking, please execute the following command in Snowflake to grant ownership privilege to the current role on the interested tables:

GRANT OWNERSHIP PRIVILEGE ON TABLE {table name} TO ROLE {current role};

If you prefer to enable change tracking yourself, please execute the following command in Snowflake and modify the startTimestamp property accordingly:

ALTER TABLE {table name} SET CHANGE_TRACKING = TRUE;

Database Name Not Found

Database Name is not mentioned in the ConnectionURL

Mention the DatabaseName in the ConnectionURL since Tables/Excluded Tables property supports only two part name

Table Not Found

Table specified in the Tables/Excluded Tables property does not exist in the Source Database

Invalid Tables Property

Syntax errors in Tables Property.

Check for syntax errors and empty spaces in Tables/Excluded Tables property.

Invalid Polling Interval

Syntax errors in Polling Interval Property.

Check for syntax errors and empty spaces in the PollingInterval property. Accepted input formats are : {value}s / {value}m .

Polling Interval Property is altered on restart

PollingInterval once set should not be altered when recovery is turned ON. Provide the appropriate PollingInterval and restart the application.

Invalid Connection Retry Policy

Syntax errors in Connection Retry Policy

Check for syntax errors and empty spaces in ConnectionRetryPolicy property, also make sure to provide the valid values.

Accepted input format is :

initialRetryDelay={value}, retryDelayMultiplier={value}, maxRetryDelay={value}, maxAttempts={value}, totalTimeout={value}

Invalid StartTimestamp

Syntax error in StartTimestamp Property

Check for syntax errors in the StartTimestamp property.

Accepted input formats are :

a. {schemaname}.{tablename}:'YYYY-MM-DDThh:mmTZD'

b. {schemaname}.{tablename}:'YYYY-MM-DDThh:mm:ssTZD'

c. {schemaname}.{tablename}:'YYYY-MM-DDThh:mm:ss.sssTZD'

Invalid value for ThreadPoolSize

Provided value for the property ThreadPoolSize in SnowflakeConfiguration is invalid or less than 1

Make sure to provide the valid numeric value greater than 0 for ThreadPoolSize in SnowflakeConfiguration Property.

Schema Mismatch has been Identified

Schema change has been identified on the Source Table but CDDL Capture is not enabled.

Please set CDDLCapture to true to capture Column level DDL changes.

Drop Table Change has been Identified

Table has been dropped in the Source Database, but Drop Table DDL Capture is not supported

-