Blueprints

Query data in Snowflake

Source

yaml
id: snowflake-query
namespace: company.team

tasks:
  - id: query
    type: io.kestra.plugin.jdbc.snowflake.Query
    url: jdbc:snowflake://accountID.snowflakecomputing.com?warehouse=COMPUTE_WH
    username: yourSnowflakeUser
    password: "{{ secret('SNOWFLAKE_PASSWORD') }}"
    fetchType: FETCH_ONE
    sql: |
      SELECT * FROM SNOWFLAKE_SAMPLE_DATA.TPCH_SF1.CUSTOMER
See more

About this blueprint

Snowflake SQL

This flow runs a query within a Snowflake data warehouse. The fetchType property value FETCH_ONE will retrieve only the first row, while using the FETCH value will retrieve all rows. Setting fetchType: STORE will provide the results as a downloadable file.

The flow assumes the password is stored as a secret.

Query

More Related Blueprints

Ingest Snowflake Data SQL

Snowflake ETL: load files to internal stage, copy from stage to a table and run analytical SQL queries

New to Kestra?

Use blueprints to kickstart your first workflows.

Get started with Kestra