Merge pull request #15 from anecdotes-ai/update-snowflake-connector #51
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: Sanity Tests | |
on: push | |
jobs: | |
test_multiple_queries: | |
runs-on: ubuntu-latest | |
name: Test Function Multiple Queries | |
steps: | |
# Run Queries | |
- name: Checkout Repository | |
uses: actions/checkout@v2 | |
- name: Run Queries | |
uses: ./ | |
id: run_queries | |
with: | |
snowflake_account: ${{ secrets.SNOWFLAKE_ACCOUNT }} | |
snowflake_warehouse: ${{ secrets.SNOWFLAKE_WAREHOUSE }} | |
snowflake_username: ${{ secrets.SNOWFLAKE_USERNAME }} | |
snowflake_password: ${{ secrets.SNOWFLAKE_PASSWORD }} | |
queries: 'call system$wait(1); | |
select CURRENT_VERSION(); | |
select CURRENT_CLIENT()' | |
# Validations | |
- name: Query Client validation | |
run: | | |
${{contains(steps.run_queries.outputs.queries_results, 'PythonConnector')}} | |
- name: Waiting Query Validation | |
run: | | |
${{contains(steps.run_queries.outputs.queries_results, 'waited 1 seconds')}} | |
test_matrix_query: | |
runs-on: ubuntu-latest | |
name: Test Matrix Multiple Queries | |
strategy: | |
matrix: | |
sleep: [1, 2, 3] | |
steps: | |
# Run Queries | |
- name: Checkout Repository | |
uses: actions/checkout@v2 | |
- name: Run Queries | |
uses: ./ | |
id: run_queries | |
with: | |
snowflake_account: ${{ secrets.SNOWFLAKE_ACCOUNT }} | |
snowflake_warehouse: ${{ secrets.SNOWFLAKE_WAREHOUSE }} | |
snowflake_username: ${{ secrets.SNOWFLAKE_USERNAME }} | |
snowflake_password: ${{ secrets.SNOWFLAKE_PASSWORD }} | |
queries: 'call system$wait(${{matrix.sleep}})' | |
- name: Waiting Query Validation | |
run: | | |
${{contains(steps.run_queries.outputs.queries_results, format('waited {0} seconds', matrix.sleep))}} |