schemachange

schemachange copied to clipboard

How to execute Package SQL in schemachange

3

Hi Team, In SnowSql we have command to execute the master script to execute internal scripts using !load command. when we are trying to execute that from Schemachange its failing...

lakshmiprasannaguntuka

Add Query Tag to Change History table

1

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...

tsceurman-ara

sql compilation error for default variables missing double quotes

2

I am deploying schemachange in azure devops however stuck in execution of the repeatable script(very first step) Can you please help debugging this? its a simple deployment, using library for...

apsram

Option to output a list of files that will be run during a dry run.

1

I would love to be able to easily connect SQLFluff or another linting tool that only checks for files that are about to be deployed (rather than scanning an entire...

drew-hansen

Need to be able to ignore certain scripts when running CICD to prevent developers reverting R__ scripts.

1

We use Schemachange for deploying into all of our environments (DEV, STG, and PRD). We have been running into timing issues with R__ scripts causing them to be reverted to...

CermitDFrog

snowchange appears to truncate my del statement

4

Hi, Im trying to execute `USE DATABASE {{db_name}}; alter session set QUERY_TAG = 'DDL'; {%- set str_schema_name = 'DATA_MART' -%} {%- set str_table_name = 'DIM_CLIENT' -%} {%- set str_column_name =...

TimNapierVST

Replaced the small piece of code that uses Pandas, removed it as a dependency.

naruvimama

**Describe the bug** When using Azure Dev Ops & schemachange, I get an error of "Empty SQL Statement". **To Reproduce** Complete a pull request in Azure Dev Ops. CI CD...

GeorgeAtMOD

Update of Numpy to 2.0 has broken schemachange

8

**Describe the bug** A ValueError occurs when attempting to run SchemaChange, this did not occur last Friday (6/14) but is occurring this Monday (6/17). **To Reproduce** Steps to reproduce the...

cuddebtj

Please rectify schemachange dry run output

1

**Describe the bug** The schemachange dry run is used as a check before the actual implementation run to display the order of execution of the change scripts. **To Reproduce** Steps...

Jeevan-Raju