Hi,
Source: SQL Server, Target: Snowflake on Azure
We're trying to remove case-sensitivity issue on our Target and ignore double-quotes while creating objects from Replicate. This requires session parameter 'QUOTED_IDENTIFIERS_IGNORE_CASE' needs to be set to 'true' within Snowflake while creating objects to ignore double-quotes for case-insensitivity.
But when we've changed the logs to Verbose in Replicate and loaded the data. Seems Replicate is defaulting the parameter 'QUOTED_IDENTIFIERS_IGNORE_CASE' to 'False'. Is there anyway to override this to 'True' on the fly? If so, that might resolve our issue.
Log where Replicate is forcing as false:
'00000796: 2020-11-10T12:41:18:57578 [TARGET_LOAD ]V: Execute immediate: 'alter session set QUOTED_IDENTIFIERS_IGNORE_CASE=FALSE' (ar_odbc_stmt.c:4811)'
Thanks,
Sandilya Dongar.