schemachange

schemachange copied to clipboard

Need option to pass sfurl

1

We need option to pass url along with other arguments

10631A1236

I'm still testing is schemachange can be a replacement for how we deploy code using snowsql today. In snowsql when code is run, our process automatically prefixes the code with...

kjn70

Execution a migration that calls scripts outside of the migration folder?

10

We have multiple development teams on many projects. Database code is organized by project with run-time scripts (in SQL folder) and migration scripts (in a Deploy folder). The migration script...

kjn70

Number of columns in file (2) does not match that of the corresponding table (16)

3

I cloned the repo, added all the necessary (authentication) configs to the yaml and ran the script. The only thing that I changed in the SQL were these two lines:...

zegenerative

Unit Test to verify version uniqueness

3

One issue we've run into is multiple users will use the same version, as an arbitrary example 20220127.1, within the branch and it causes problems when they want to merge...

james-camacho-ab

Incorporate logging module instead of print function

4

I wanted to share few of my thoughts and get your thoughts on it. - Can we use logger instead of print statements in this tool? - Can we leverage...

tsingh2k15

Show snowflake output of the scripts executed by schemachange

3

We've recently found out that a script that had executed "successfully", in practice was not working. The script was executing a GRANT with an role that had insufficient privileges. Essentially...

LeoPastaBuddy

Unicode issue when µ is included in a function

2

Trying to create this function below via schema change gives me an error when running via Azure DevOps pipeline ``` CREATE FUNCTION PUBLIC.CONVERT_TO_UMOL_SCALE("ITEM" VARCHAR(16777216)) RETURNS FLOAT LANGUAGE JAVASCRIPT AS '...

lgc-jacovanwyk

Implementing CICD on Azure Devops

1

Hi, I have used schemachange on azure devops pipeline, below are some of the questions 1. I am deploying scripts based on V1.#.# naming convention, For Example: V1.1.1__Create_schema.sql use database...

venkata-nikhit-mulkala

Max high water mark

1

Hi, We would be interested in a max water mark to supply with others deliverables or within build artifacts to execute the corresponding db changes instead of using pull requests...

2ndway