Snowflake-Labs / schemachange

A Database Change Management tool for Snowflake
Apache License 2.0
502 stars 224 forks source link

Log session ID in the output #243

Closed opodoprigora closed 2 months ago

opodoprigora commented 5 months ago

Is your feature request related to a problem? Please describe. It's difficult to troubleshoot SC runs when no session id is available and query history table needs to be searched for text instead.

Describe the solution you'd like Log session id in the output. Additionally it would be helpful to have this available via a default execution and to not have to use verbose argument.

Describe alternatives you've considered Searching for SQL text in the query history table.

Additional context Session ID can be retrieved using SELECT CURRENT_SESSION().

opodoprigora commented 5 months ago

PR opened

sfc-gh-tmathew commented 2 months ago

Thank you for your contribution @opodoprigora. The changes have been pushed to 3.7.0