schemachange

schemachange copied to clipboard

schemachange cli command returns Error: Empty SQL statement if .sql file ends with comments

1

**Describe the bug** When creating a new .sql file to implement a change in our Snowflake database, the `schemachange` cli command returns an error: SQL compilation error: Empty SQL statement...

ArnauMunsOrenga

Adding Skip Failures parameter for proceeding to the next script even if the previous script failed

7

**Is your feature request related to a problem? Please describe.** I'm using SchemaChange as part of Azure DevOps Pipeline where I'm trying to deploy several sql scripts. In most of...

zroytman

Failure to redact a multi-line secret

8

**Describe the bug** Given this config file ``` config-version: 1 vars: secrets: azure_ad_certificate: |- foobarfoobarfoobar foobarfoobarfoobar ``` schemachange does print out the secret unredacted to stdout. **To Reproduce** Steps to...

rwberendsen

**Problem** When given a multi-line secret in the schemachange-config YAML, it would not be redacted, because just before calling `SecretManager.global_redact`, the config vars section would be serialised as YAML, adding...

rwberendsen

Flag for error on ignored versioned migration and versioned script regex

4

This pull request started out as a feature addition. It ended up being a bit of a repo refactor. - Format with Black. There's already an open PR on this:...

zanebclark

debug/ developer tooling accomodations

6

Developer tooling. I wrote a simple PowerShell script to run the render command over all the files and redirect them into a subfolder that is listed in the .gitignore Can...

MACKAT05

Full command line for parameters vs. config file.

3

** What are you trying to accomplish? ** I have been able to successfully deploy sql scripts using schema change when taking advantage of the configuration file and executing the...

dataalias

Default Warehouse Not Selected

2

Based on the versions of schemachange I've installed be it 3.6.1, 3.6.0 and 3.5.4 I've received an error when just starting a project: `SQL query: SELECT CREATED, LAST_ALTERED FROM METADATA.INFORMATION_SCHEMA.TABLES...

allstream

Added ability to configure some [Jinja Environment](https://jinja.palletsprojects.com/en/3.0.x/api/#high-level-api) settings within the schemachange configuration via a new "jinja" section. This section would allow users to customize several parsing and rendering options in...

rosspb3

Add in repeatable migration batching process. This allows for repeatable migrations to be batched together to speed up deployment. The number of migrations batched together can be controlled via the...

nickpileggi947