idea Re: Option for Replicate Task to run Pre-Statements with Snowflake as a Target. in Suggest an Idea

Option for Replicate Task to run Pre-Statements with Snowflake as a Target.

spachunuri — Thu, 28 May 2020 17:59:27 GMT

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

Re: Option for Replicate Task to run Pre-Statements with Snowflake as a Target. - Status changed to: Open - Collecting Feedback

Ola_Mayer — Mon, 15 Jun 2020 13:40:26 GMT

Can you please clarify your request?

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

Re: Option for Replicate Task to run Pre-Statements with Snowflake as a Target.

spachunuri — Tue, 30 Jun 2020 09:04:54 GMT

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.

Re: Option for Replicate Task to run Pre-Statements with Snowflake as a Target.

spachunuri — Wed, 16 Dec 2020 09:20:58 GMT

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.

Re: Option for Replicate Task to run Pre-Statements with Snowflake as a Target.

spachunuri — Wed, 16 Dec 2020 10:20:07 GMT

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

Re: Option for Replicate Task to run Pre-Statements with Snowflake as a Target.

choudarybabu — Thu, 29 Sep 2022 16:23:01 GMT

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

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

Meghann_MacDonald — Wed, 02 Aug 2023 15:51:35 GMT

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.

Re: Option for Replicate Task to run Pre-Statements with Snowflake as a Target. - Status changed to: Closed - Archived

Ideation — Wed, 02 Aug 2023 15:51:37 GMT