Snowflake RunSQL Action

Execute a single SQL statement against Snowflake and print JSON results.

A lightweight GitHub Action that connects to Snowflake using your provided credentials, runs one SQL statement, and prints the full JSON result (rows, query ID, session ID, and context). Perfect for quick smoke tests or automating Snowflake admin tasks without wiring up a full client.

Usage

• uses: marcelinojackson-org/Snowflake.RunSQLAction@v1
  with:
  sql: "select current_user() as current_user"
  env:
  SNOWFLAKE_ACCOUNT: ${{ secrets.SNOWFLAKE_ACCOUNT }}
  SNOWFLAKE_ACCOUNT_URL: ${{ secrets.SNOWFLAKE_ACCOUNT_URL }}
  SNOWFLAKE_USER: ${{ secrets.SNOWFLAKE_USER }}
  SNOWFLAKE_PASSWORD: ${{ secrets.SNOWFLAKE_PASSWORD }} or ${{ secrets.SNOWFLAKE_PAT }}
  SNOWFLAKE_ROLE: ${{ secrets.SNOWFLAKE_ROLE }}
  SNOWFLAKE_WAREHOUSE: ${{ secrets.SNOWFLAKE_WAREHOUSE }}
  SNOWFLAKE_DATABASE: ${{ secrets.SNOWFLAKE_DATABASE }}
  SNOWFLAKE_SCHEMA: ${{ secrets.SNOWFLAKE_SCHEMA }}