snowpark-12.yaml

e2etest-job:
  stage: e2etest
  only: 
    - branches
  image: zyanakiev/snowpark-devops:latest
  script:
    - |
      jq -c -r '.assertions[]' tests/e2e_tests.json | while read test; do 
        name=$(jq -r '.name' <<< $test)
        sql=$(jq -r '.value' <<< $test)

        echo "Running test: $name"
        rowCount=$(~/bin/snowsql -s $SF_SCHEMA -q "$sql" -o friendly=false -o exit_on_error=true -o output_format=json -o timing=false | jq '. | length')
        if [[ $rowCount -ne 0 ]]; then
          echo "Test failed! $rowCount rows returned" 1>&2
          exit 1
        else
          echo "Test Passed! $rowCount rows returned"
        fi
      done