Snowflake: Qlik Replicate should create it's Control Tables in Snowflake using Transient schema property
In Snowflake, there are built-in features to backup updated/deleted data called "time travel" and "failsafe" and while these are useful for your organization's data, for Qlik we do not need to keep history for the Control tables such as "attrep_status" and "attrep_txn_state". We can control this by creating the schema where these control tables are placed with an attribute of "Transient" and "DATA_RETENTION_IN_DAYS = 0" but this is a manual intervention. As Qlik Replicate usually creates these schemas on our behalf, we would like this to be an option when connecting to Snowflake as a target. This way we're not being charged for storage on updated/deleted rows in these Qlik control tables.
It gives us a workaround. It allows us to create the schema ahead of time, with the properties we want. However this is a manual task per schema, and we replicate into lots of schemas.
In my experience, Qlik creates a control schema in every target it replicates to (every database in Snowflake). If you have it set up to maintain all of your control tables in one place, can you share where this is configured? We have about 20-30 Qlik Replicate tasks, each targeting a different Snowflake database.
NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.
