Completing citibike setup #30
Workflow file for this run
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name: dev-pytest | |
| on: | |
| push: | |
| branches: | |
| - dev | |
| - release/** | |
| workflow_dispatch: | |
| pull_request: | |
| types: [opened, reopened] | |
| jobs: | |
| build: | |
| env: | |
| SNOWFLAKE_PASSWORD: ${{ secrets.SCHEMACHANGE_SNOWFLAKE_PASSWORD }} | |
| SNOWFLAKE_USER: ${{ secrets.SCHEMACHANGE_SNOWFLAKE_USER }} | |
| SNOWFLAKE_ACCOUNT: ${{ secrets.SCHEMACHANGE_SNOWFLAKE_ACCOUNT }} | |
| SNOWFLAKE_DATABASE: SCHEMACHANGE_DEMO | |
| SNOWFLAKE_WAREHOUSE: SCHEMACHANGE_DEMO_WH | |
| SNOWFLAKE_ROLE: SCHEMACHANGE_DEMO_DEPLOY | |
| #SNOWFLAKE_CONNECTIONS_MYCONNECTION_PASSWORD: ${{ secrets.SCHEMACHANGE_SNOWFLAKE_PASSWORD }} | |
| #SNOWFLAKE_CONNECTIONS_MYCONNECTION_ACCOUNT: ${{ secrets.SCHEMACHANGE_SNOWFLAKE_ACCOUNT }} | |
| #SNOWFLAKE_CONNECTIONS_MYCONNECTION_USER: ${{ secrets.SCHEMACHANGE_SNOWFLAKE_USER }} | |
| SCHEMACHANGE_BUILD_ID: ${{ github.run_id }} | |
| runs-on: ubuntu-latest | |
| strategy: | |
| fail-fast: false | |
| matrix: | |
| scenario-name: [ 'basics_demo', 'citibike_demo', 'citibike_demo_jinja'] | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - name: Set up Python 3.11 | |
| uses: actions/setup-python@v5 | |
| with: | |
| python-version: "3.11" | |
| - name: Update pip | |
| run: | | |
| python -m pip install --upgrade pip | |
| - name: Install dependencies | |
| run: | | |
| python -m pip install -e .[dev] | |
| - name: Test with pytest | |
| run: | | |
| pytest | |
| #- name: Setup SnowCLI connection file | |
| # run: | | |
| # echo "[connections]" > config.toml | |
| # echo "[connections.myconnection]" >> config.toml | |
| # chmod 0600 config.toml | |
| #- name: Install snowcli | |
| # run: | | |
| # pip install snowflake-cli-labs | |
| #- name: Test Default snowcli connection | |
| # run: | | |
| # snow --version | |
| # echo "::group::Config Contents" | |
| # more config.toml | |
| # echo "::endgroup::" | |
| # snow --config-file config.toml connection test -c myconnection | |
| # echo "Tested SnowCLI connection successfully!" | |
| # echo "Set default connection" | |
| # snow --config-file config.toml connection set-default "myconnection" | |
| - name: Test Schemachange - ${{ matrix.scenario-name }} | |
| env: | |
| SCENARIO_NAME: ${{ matrix.scenario-name }} | |
| run: | | |
| export MY_TARGET_SCHEMA="${SCENARIO_NAME}_${{ env.SCHEMACHANGE_BUILD_ID }}" | |
| echo "::group::Setting up ${MY_TARGET_SCHEMA}" | |
| schemachange --config-folder ./demo/setup/${SCENARIO_NAME} | |
| echo "::endgroup::" | |
| echo "Testing Rendering to ${MY_TARGET_SCHEMA}" | |
| echo "Work in Progress - To be Tested" | |
| echo "::group::Testing Deployment using ${MY_TARGET_SCHEMA}" | |
| schemachange --config-folder ./demo/${SCENARIO_NAME} | |
| echo "::endgroup::" | |
| echo "::group::Tearing down up ${MY_TARGET_SCHEMA}" | |
| schemachange --config-folder ./demo/teardown/${SCENARIO_NAME} | |
| echo "::endgroup::" | |
| #- name: Test Citibike Demo | |
| # run: | | |
| # snow --config-file config.toml sql -f ./demo/setup/setup_citibike_demo.sql | |
| # schemachange --config-folder ./demo/citibike | |
| # snow --config-file config.toml sql -f ./demo/teardown/teardown_citibike_demo.sql | |
| #- name: Test Citibike Demo Jinja Template | |
| # run: | | |
| # snow --config-file config.toml sql -f ./demo/setup/setup_citibike_demo_jinja.sql | |
| # schemachange --config-folder ./demo/citibike_jinja | |
| # snow --config-file config.toml sql -f ./demo/teardown/teardown_citibike_demo_jinja.sql |