Skip to main content

Qlik Replicate Snowflake Target: PUBLIC schema still referenced after global rule to rename schema name

100% helpful (1/1)
cancel
Showing results for 
Search instead for 
Did you mean: 
Michael_Litz
Support
Support

Qlik Replicate Snowflake Target: PUBLIC schema still referenced after global rule to rename schema name

Last Update:

Apr 2, 2024 4:44:24 AM

Updated By:

Sonja_Bauernfeind

Created date:

Apr 2, 2024 4:44:24 AM

After adding a Global Rule to rename the target Schema (example: from PUBLIC to QLIK_TEST), the task may fail with an error indicating it was still trying to use the previous (example: PUBLIC) schema.

rename schema.png

Reviewing the task JSON file to check the Global Rule definition shows no issues.

However, messages in the task logs indicate the table being created in the PUBLIC schema is not a task table. The table is an attrep change table:

00002308: 2024-03-25T16:51:38 [METADATA_MANAGE ]E: Failed (retcode -1) to execute statement: 'create or replace file format "PUBLIC"."ATTREP_FF_DEV_OS_STG_c1a25c9f_deef_f647_817b_db90dadf622b"

Resolution

Since the table mentioned in the error is not the actual target table, but a control table the resolution is to configure the control tables screen to also use the new schema (example: QLIK_TEST).

Screen Shot of the Control Tables Settings after setting schema to QLIK_TEST:

control table schema.png

 

Related Content

Control Tables
Global Rules

 

Labels (1)
Version history
Last update:
3 weeks ago
Updated by: