schemachange

schemachange copied to clipboard

Curious on the use case of SchemaChange and Terraform

5

** What are you trying to accomplish? ** Decide between SchemaChange and Terraform Snowflake Provider for Snowflake Object Management ** What options have you tried so far ? ** Want...

ankitsr92

SQL Syntax error when Snowflake role name includes special characters such as hyphens

1

The **USE ROLE** and the other USE query template strings here: https://github.com/Snowflake-Labs/schemachange/blob/master/schemachange/cli.py#L213 are not using quoted values for the placeholder values, if there are special characters in the name of...

jonathancisneros

Role names containing dashes

7

https://github.com/Snowflake-Labs/schemachange/blob/2eb5d52b3aa5597465a9478b2a4e35dd913d0e17/schemachange/cli.py#L210C1-L210C1 In case role names contain dashes this leads to a sql error. At the moment additional escaped quotes must be provided in order to get it running. Would be...

TLI-BAY

Hey there! I'm interested in adding two new flags to a fork of the repo that I think would be valuable to others. I'm finding it hard to follow the...

zanebclark

Schemachange render: error: argument --vars: invalid loads value: '{variable1: value1, variable2: value2}'

2

For the life of me, I cannot work out how to pass these variables? I run the following: `schemachange render -a XXX.eu-west-1 -u XXX -r XXX -w XXX --vars '{"variable1":...

lgc-jacovanwyk

Create a custom GitHub Action

4

**Is your feature request related to a problem? Please describe.** To ease integration with GitHub Workflows provide a custom GitHub Action, this will make deploying schema change into sorrow faster...

SPSCS-Simon

Getting "unexpected '<EOF>'" error when trying to deploy migrations on gitlab

9

**Describe the bug** Hi! I am getting the following error everytime I try to run my Gitlab CI/CD pipeline with schemachange on a new SQL migrations file: ``` Traceback (most...

carley-citian

how to create Javascript stored procedure in Schemachange

16

rvishnupriyasiemens

Fail Upon Skipped Versioned Migration

3

# The Problem I use the epoch time as the version number when creating versioned scripts. This _almost_ removes the version-number guesswork from the creation of a new script. Here's...

zanebclark

state that snowflake_database var does not alter where change history table is created

1

Minor alteration to the README to make it clear that using a two part name in the ```CHANGE_HISTORY_TABLE``` argument will result in the METADATA database being used to store the...

RichieBzzzt