snowpark-08.yaml

deploy-job:
  stage: deploy
  image: zyanakiev/snowpark-devops:latest
  environment:
    name: $CI_COMMIT_REF_SLUG
    on_stop: delete-schema-job
  only:
    - branches
  script:
    - |
      echo "Upload artifact to SnowSQL"
      ~/bin/snowsql -s $SF_SCHEMA -q "create stage if not exists deploy" -o friendly=false -o exit_on_error=true
      ~/bin/snowsql -s $SF_SCHEMA -q "put file://$(pwd)/app.zip @deploy overwrite=true auto_compress=false" -o friendly=false -o exit_on_error=true
    - |
      echo "Create resources and seed schema"
      ~/bin/snowsql -s $SF_SCHEMA -f ./setup/00_init_schema.sql -o friendly=false -o exit_on_error=true