idea Re: Replicate CT Tables Header_Columns Upper Case in Suggest an Idea

Replicate CT Tables Header_Columns Upper Case

SandilyaDongar — Tue, 23 Mar 2021 21:26:38 GMT

Hi,

As a part of our requirement, we would like to have all columns including CT table columns asUpper Case. But in the task settings for Change Processing, Replicate is creating all of the Header columns in CT tables as lower case. We would like to have them as Upper Case as we need to double quote them to query unless they are created with Upper Case. Is there a way to create them Upper Case with Global Transformation or something?

I've also checked with support, they've requested me to post this as an Ideation topic for future enhancement (Case - 02165229)

Thank you,

Sandilya Dongar.

Re: Replicate CT Tables Header_Columns Upper Case - Status changed to: Open - New

Shelley_Brennan — Thu, 08 Apr 2021 12:18:58 GMT

Thank you for the suggestion. What sources and targets do you need this for? What is the use case for this requirement? Thank you!

Re: Replicate CT Tables Header_Columns Upper Case

SandilyaDongar — Thu, 08 Apr 2021 20:55:05 GMT

Hi Shelley,

Source/Target:

Our source is 'SQL Server' and target is 'Snowflake on Azure'.

Use Case:

If we want to query header columns from CT tables, we had to double-quote the values as they were created in lower-case which is not recommended by our developing team to use double-quotes around few objects & not around few (cause we are converting all of our tables/columns to uppercase with Global Transformations). So we would like this feature enabled to able to create header columns as uppercase in order to have consistent coding standards.

While moving objects to Snowflake, Replicate automatically enables double-quotes around objects (there is no option to disable it in replicate) and hence these header columns are created in lower-case. Moreover Replicate sets the session paramerter 'quoted_identifiers_ignore_case' to 'false' by default(can't be updated to 'true') which rules out the option of case-sensitivity from Snowflake standpoint.

So, inorder to not use double-quotes for these header columns - only option is to create them with uppercase and there is no way around to do that in Replicate currently.

Thank you,

Sandilya D.

Re: Replicate CT Tables Header_Columns Upper Case

Shelley_Brennan — Wed, 21 Apr 2021 15:48:28 GMT

Hi Sandilya,

We do plan to expose an internal parameter for Snowflake with the upcoming May release to control QUOTED_IDENTIFIERS_IGNORE_CASE parameter.

Would this alleviate the issue for you? You can try this with the Technical Preview that is currently available and add the internal parameter "setIgnoreCaseFlag" to true.

Thanks,

Shelley

Re: Replicate CT Tables Header_Columns Upper Case

SandilyaDongar — Wed, 21 Apr 2021 15:56:00 GMT

Hi Shelley,

Could you let me know how to get hands on with the 'Tehnical Preview' and how to set the parameter to try what you've suggested?

Thank you,

Sandilya D.

Re: Replicate CT Tables Header_Columns Upper Case

Shelley_Brennan — Wed, 21 Apr 2021 16:09:05 GMT

Yes, you'll find information and downloads for the Technical Preview here: https://community.qlik.com/t5/Technical-Previews/ct-p/productinsight

When Managing Endpoint Connections, you should see a link to add internal parameters on the Advanced tab.

Thanks!

Re: Replicate CT Tables Header_Columns Upper Case

SandilyaDongar — Wed, 21 Apr 2021 21:11:33 GMT

Hi Shelley,

After installing 'Technical Preview', we're unable to access the above parameter as mentioned.

Could you guide us through what needs to be done after installing it inorder to able to see that param.

Thanks,

Sandilya D.

Re: Replicate CT Tables Header_Columns Upper Case

Shelley_Brennan — Thu, 22 Apr 2021 12:36:55 GMT

This parameter is only available for Snowflake targets - it looks like you have another endpoint selected?

Re: Replicate CT Tables Header_Columns Upper Case

SandilyaDongar — Thu, 22 Apr 2021 14:01:02 GMT

Nope, our target is Snowflake on Azure.

Re: Replicate CT Tables Header_Columns Upper Case

Shelley_Brennan — Thu, 22 Apr 2021 14:14:01 GMT

Are you editing the parameters for the Snowflake target though? The internal parameters are set for each individual endpoint, and in your screenshot it looks like you have another endpoint selected (a SQL source).

Re: Replicate CT Tables Header_Columns Upper Case

SandilyaDongar — Thu, 22 Apr 2021 14:28:09 GMT

That makes sense. Thank you I was able to find it. Will test it and let you know how it goes.

Re: Replicate CT Tables Header_Columns Upper Case

SandilyaDongar — Thu, 22 Apr 2021 14:46:52 GMT

This worked like a charm. Now every table and column is in uppercase by enabling this parameter.

Thank you so much Shelley.

I know this is a technical preview, but when can we expect an actual release?

Re: Replicate CT Tables Header_Columns Upper Case

Shelley_Brennan — Thu, 22 Apr 2021 16:25:55 GMT

Great! It should be GA on May 11th. Look for announcements in Qlik Community here.

Re: Replicate CT Tables Header_Columns Upper Case - Status changed to: Open - In Development

Shelley_Brennan — Thu, 22 Apr 2021 16:26:19 GMT

Re: Replicate CT Tables Header_Columns Upper Case

SandilyaDongar — Thu, 22 Apr 2021 16:27:00 GMT

Thank you!

Re: Replicate CT Tables Header_Columns Upper Case - Status changed to: Delivered

Shelley_Brennan — Thu, 13 May 2021 15:29:39 GMT

Now available with the May 2021 release.

Re: Replicate CT Tables Header_Columns Upper Case

SandilyaDongar — Thu, 13 May 2021 18:12:18 GMT

Thank you!