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

[Michael_Litz]

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.

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:

Related Content

Control Tables
Global Rules