Skip to content

rename

rename #11

name: snowflake-devops-demo
# Controls when the action will run.
on:
push:
branches:
- main
paths:
- 'migrations/**'
# Allows you to run this workflow manually from the Actions tab
workflow_dispatch:
jobs:
deploy-snowflake-changes-job:
runs-on: ubuntu-latest
steps:
# Checks-out your repository under $GITHUB_WORKSPACE, so your job can access it
- name: Checkout repository
uses: actions/checkout@v2
- name: Use Python 3.8.x
uses: actions/[email protected]
with:
python-version: 3.8.x
- name: Run schemachange
env:
SF_ACCOUNT: ${{ secrets.SF_ACCOUNT }}
SF_USERNAME: ${{ secrets.SF_USERNAME }}
SF_ROLE: ${{ secrets.SF_ROLE }}
SF_WAREHOUSE: ${{ secrets.SF_WAREHOUSE }}
SF_DATABASE: ${{ secrets.SF_DATABASE }}
SF_SCHEMA: ${{ secrets.SF_SCHEMA }}
SNOWFLAKE_PASSWORD: ${{ secrets.SNOWFLAKE_PASSWORD }}
run: |
echo "GITHUB_WORKSPACE: $GITHUB_WORKSPACE"
python --version
echo "Step 1: Installing schemachange"
pip install schemachange
echo "Step 2: Running schemachange"
schemachange deploy \
--verbose \
-f $GITHUB_WORKSPACE/migrations \
-a $SF_ACCOUNT \
-u $SF_USERNAME \
-r $SF_ROLE \
-w $SF_WAREHOUSE \
-d $SF_DATABASE \
-s $SF_SCHEMA \
-c $SF_DATABASE.SCHEMACHANGE.CHANGE_HISTORY \
--create-change-history-table