Adding table and column comments in Snowflake with Qlik Replicate

[raffaelec]

Hello,

I have configured a replication task from an Oracle source to a Snowflake target. I would like to add descriptions to the tables and their fields using the COMMENT command.

• Is there a way to execute this command during the table creation phase on the Snowflake target?
• And is it possible to dynamically retrieve the comments by running a query on the source database?

Thank you in advance for your help.

Best regards

[Dana_Baldwin · Accepted solution]

Hi @raffaelec 

There is not a way within Replicate to modify the target table metadata for this need. Replicate has a default syntax that can be modified to some extent, but if it could be used it would not meet your need as all tables created by that target endpoint would have the same hard-coded description/comment.

In order to look up information from the source you would need to add a column to the target table and define a source look up. I know that is not a perfect solution either, as you will have the same table description/comment in every row - and you may want to filter that out of end user queries of the target data. But that is what is available today. Please refer to:

Functions | Qlik Replicate Help

and

Qlik Replicate Transformation: Source Lookup - CLO... - Qlik Community - 1987353

If this is a feature you would like to see in the product, I encourage you to please submit a feature request here which goes directly to our Product Management team. Other users will have the opportunity to vote on it to increase the chances at adoption and to set the priority: https://community.qlik.com/t5/Ideas/idb-p/qlik-ideas

Thanks,

Dana

[DesmondWOO]

Hi @raffaelec ,

Qlik Replicate does not support this feature. You can query Oracle views, such as all_col_comments, to retrieve the information needed for generating a script for the Snowflake's COMMENT command.

Regards,
Desmond