Removed drop data share due to insufficient privileges #38
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: Python application | |
| on: | |
| push: | |
| branches: [ "main" ] | |
| pull_request: | |
| branches: [ "main" ] | |
| permissions: | |
| contents: read | |
| jobs: | |
| build: | |
| runs-on: ubuntu-latest | |
| steps: | |
| - name: Set up Snowflake connection by putting secrets into config file | |
| env: | |
| SNOWCLI_CONFIG: ${{secrets.SNOWCLI_CONFIG}} | |
| shell: bash | |
| run: | | |
| echo "$SNOWCLI_CONFIG" > config.toml | |
| # Snowflake CLI requires the config.toml file to limit its file permissions to read and write for the file owner only | |
| chown $USER config.toml | |
| chmod 0600 config.toml | |
| - name: Snowflake CLI installation | |
| uses: Snowflake-Labs/snowflake-cli-action@v1 | |
| with: | |
| cli-version: "latest" | |
| default-config-file-path: "config.toml" | |
| - name: Fetch the latest update from Github | |
| run: | | |
| snow sql -q "ALTER GIT REPOSITORY SFLAB_DEMO_NB FETCH;" | |
| - name: Test Notebook - My First Notebook Project | |
| run: | | |
| snow sql -q "EXECUTE NOTEBOOK GH_ACTION_FIRST_NB();" | |
| - name: Test Notebook - Visual Data Stories | |
| run: | | |
| snow sql -q "EXECUTE NOTEBOOK GH_ACTION_VISUAL_NB();" | |
| - name: Test Notebook - Ingest Public JSON | |
| run: | | |
| snow sql -q "EXECUTE NOTEBOOK GH_ACTION_PUBLIC_JSON_NB();" | |
| - name: Test Notebook - Load CSV from S3 | |
| run: | | |
| snow sql -q "EXECUTE NOTEBOOK GH_ACTION_CSV_S3_NB();" | |
| - name: Test Notebook - Working with Files | |
| run: | | |
| snow sql -q "EXECUTE NOTEBOOK GH_ACTION_FILES_NB();" | |
| - name: Test Notebook - Hyperparameter Tuning with sklearn | |
| run: | | |
| snow sql -q "EXECUTE NOTEBOOK GH_ACTION_SKLEARN_NB();" | |
| - name: Test Notebook - Import from Stage | |
| run: | | |
| snow sql -q "EXECUTE NOTEBOOK GH_ACTION_STAGE_IMPORT_NB();" | |
| - name: Test Notebook - Create Objects with Python API | |
| run: | | |
| snow sql -q "EXECUTE NOTEBOOK GH_ACTION_PYTHONAPI_NB();" | |
| - name: Test Notebook - Cortex ML Function | |
| run: | | |
| snow sql -q "EXECUTE NOTEBOOK GH_ACTION_CORTEX_MLFUNC_NB();" | |
| - name: Test Notebook - End-to-End Machine Learning with Snowpark ML | |
| run: | | |
| snow sql -q "EXECUTE NOTEBOOK GH_ACTION_SPML1_NB();" | |
| snow sql -q "EXECUTE NOTEBOOK GH_ACTION_SPML2_NB();" | |
| snow sql -q "EXECUTE NOTEBOOK GH_ACTION_SPML3_NB();" | |
| # - name: Test Notebook - Create and Manage Snowflake Objects like a Pro | |
| # run: | | |
| # snow sql -q "EXECUTE NOTEBOOK GH_ACTION_PRO_NB();" | |
| - name: Test Notebook - Data Engineering Pipelines with Snowpark Python | |
| run: | | |
| snow sql -q "EXECUTE NOTEBOOK GH_ACTION_DE_SNOWPARK_NB();" |