Snowflake-Labs / schemachange

A Database Change Management tool for Snowflake
Apache License 2.0
481 stars 219 forks source link

Add Query Tag to Change History table #163

Open tsceurman-ara opened 1 year ago

tsceurman-ara commented 1 year ago

For traceability/audit trail, we are specifying a Query Tag through the CLI. Would like to see the Query Tag value in the Change History table, so that we can easily show which entries in the table match against the query history in Snowflake. If no Query Tag value was specified when executing schemachange, either leave empty or use a default value/pattern.

sfc-gh-tmathew commented 9 months ago

Hello @tsceurman-ara

Thank you for the suggestion. We will have to see how to add this enhancement to alter the change history table structure and get the query tag in it without affecting existing users.

Will plan on review this idea in a future release.