Qlik Community

Ask a Question

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY

Replicate CT Tables Header_Columns Upper Case

SandilyaDongar
Contributor II
Contributor II

Replicate CT Tables Header_Columns Upper Case

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)

ReplicateCT_HeaderColumns.png

Thank you,

Sandilya Dongar.

2 Comments
Shelley_Brennan
Employee
Employee

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

Status changed to: Open - New
SandilyaDongar
Contributor II
Contributor II

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.