idea Qlik Replicate Postgres to Snowflake - Remove or allow configuration of Quoted Identifiers created on all Snowflake tables and columns in Suggest an Idea https://community.qlik.com/t5/Suggest-an-Idea/Qlik-Replicate-Postgres-to-Snowflake-Remove-or-allow/idi-p/1958030 <P>Hi, when replicating from AWS Aurora Postgres to Snowflake, Qlik Replicate tasks create all objects in Snowflake with quoted identifiers. From the source, none of our tables/columns have quoted or require quotes. Example target table on Snowflake:</P> <P>create or replace TABLE TESTDB."testschema"."test_table"</P> <P>( "test_table_id" NUMBER(38,0) NOT NULL,</P> <P>"col1" VARCHAR(36) NOT NULL,</P> <P>"col2" NUMBER(38,0) NOT NULL</P> <P>, "created_date" TIMESTAMP_NTZ(6) NOT NULL</P> <P>, "created_by" VARCHAR(100) NOT NULL</P> <P>,"updated_date" TIMESTAMP_NTZ(6) NOT NULL</P> <P>, "updated_by" VARCHAR(100) NOT NULL</P> <P>, constraint test_table_key_PK primary key ("test_table_id") );</P> <P>This adds quite a bit of overhead when coding in Snowflake.&nbsp; We would like to make this either a parameter or a way to exclude quoting all objects.</P> Wed, 20 Jul 2022 02:05:21 GMT MarcBExp22 2022-07-20T02:05:21Z From now on, please track this idea from the Ideation por... https://community.qlik.com/t5/Suggest-an-Idea/Qlik-Replicate-Postgres-to-Snowflake-Remove-or-allow/idc-p/2100990#M14236 <P>From now on, please track this idea from the Ideation portal.&nbsp;</P><P><STRONG><A title="Link to new idea" href="https://ideation.qlik.com/app/#/case/280009" target="_blank" rel="noopener">Link to new idea</A></STRONG></P><P>Meghann</P><P data-unlink="true"><EM>NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you <STRONG>only</STRONG> see 1 tab with the login page, please try clicking this link first: <STRONG><A title="Authenticate me!" href="#" target="_blank" rel="noopener">Authenticate me!</A></STRONG>&nbsp;t</EM><EM>hen try the link above again. Ensure pop-up blocker is off.</EM></P> Wed, 02 Aug 2023 16:04:15 GMT https://community.qlik.com/t5/Suggest-an-Idea/Qlik-Replicate-Postgres-to-Snowflake-Remove-or-allow/idc-p/2100990#M14236 Meghann_MacDonald 2023-08-02T16:04:15Z Re: Qlik Replicate Postgres to Snowflake - Remove or allow configuration of Quoted Identifiers created on all Snowflake tables and columns - Status changed to: Closed - Archived https://community.qlik.com/t5/Suggest-an-Idea/Qlik-Replicate-Postgres-to-Snowflake-Remove-or-allow/idc-p/2100991#M14237 Wed, 02 Aug 2023 16:04:17 GMT https://community.qlik.com/t5/Suggest-an-Idea/Qlik-Replicate-Postgres-to-Snowflake-Remove-or-allow/idc-p/2100991#M14237 Ideation 2023-08-02T16:04:17Z