Suggest an Idea

[spachunuri]

Recently we have upgraded to Replicate 6.4 to 6.6. 

We are trying to move the data from SQL Server to Snowflake. At our Source- SQL Server we have tables and columns with case sensitive. We have made changes to Snowflake database at Account level to be case Insensitive. But Replicate is generating a pre-statement at session level QUOTED_IDENTIFIERS_IGNORE_CASE = FALSE; to negate what i did at Account level. This is causing an issue as it worked in Replicate 6.4 version but in 6.6 it is doing this pre-statement. We need an option at Task level to pass the session level pre-statements. This will help the customer to change as need basis.

Case number for the same request: 01982778

[Ola_Mayer]

Can you please clarify your request?

Are you looking to work case sensitive on the account level?

[spachunuri]

Hi Ola Mayer. Let me know when you have 15 mins to chat so that i can show you exactly what i am talking about. 

[spachunuri]

Hi Ola Yes. We are looking to enable QUOTED_IDENTIFIERS_IGNORE_CASE = FALSE at session level but not at ACCOUNT level. Is there any way i can pass this parameter before making a connection to snowflake.

[spachunuri]

This is similar Idea as "Session Parameter Override within Replicate"

[choudarybabu]

Can you set that parameter QUOTED_IDENTIFIERS_IGNORE_CASE  to false for that snowflake user at user level?

Other way could be to set it at odbc level in registry editor !

i dont think you can choose this parameter at Replicate task level, not that i am aware of 

[Meghann_MacDonald]

From now on, please track this idea from the Ideation portal. 

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.