### How to apply changes manually
1) Create .env file (fill in missing values)
```
SNOWFLAKE_ACCOUNT
SNOWFLAKE_USER
SNOWFLAKE_ROLE=SYSADMIN
SNOWFLAKE_WAREHOUSE
SNOWSQL_PWD=
SNOWCHANGE_TABLE=
ROOT_FOLDER=/usr/src/snowchange
```
SNOWCHANGE_TABLE should look like METADATA.SNOWCHANGE.<databasename>

2) find and substitute these macroses in all SQL files:
#{database}
#{explorationStageS3}
#{grasStageS3}
#{explorationStageIntegration}
#{grasStageIntegration}

3) Run migrations with docker:

```bash
docker run -it --rm --env-file=.env -v <path_to_the_repo>/delphi-exploration-snowflake/snowchange:/usr/src/snowchange -w /usr/src/snowchange python:3 /bin/bash -c 'pip install --upgrade snowflake-connector-python schemachange && env && schemachange -f $ROOT_FOLDER -a $SNOWFLAKE_ACCOUNT -u $SNOWFLAKE_USER -r $SNOWFLAKE_ROLE -w $SNOWFLAKE_WAREHOUSE -c $SNOWCHANGE_TABLE'
```