Snowflake Source

Provided by: "Apache Software Foundation"

Support Level for this Kamelet is: "Preview"

Query data from a Snowflake Database.

Configuration Options

The following table summarizes the configuration options available for the snowflake-source Kamelet:

Property	Name	Description	Type	Default	Example
instanceUrl	Instance URL	Required The Instance url.	string		instance.snowflakecomputing.com
password	Password	Required The password to access a secured Snowflake Database.	string
query	Query	Required The query to execute against the Snowflake Database.	string		INSERT INTO accounts (username,city) VALUES (:#username,:#city)
username	Username	Required The username to access a secured Snowflake Database.	string
consumedQuery	Consumed Query	A query to run on a tuple consumed.	string		DELETE FROM accounts where user_id = :#user_id
databaseName	Database Name	The name of the Snowflake Database.	string
delay	Delay	The number of milliseconds before the next poll.	integer	500

Property

Name

Description

Type

Default

Example

instanceUrl

Instance URL

Required The Instance url.

string

instance.snowflakecomputing.com

password

Password

Required The password to access a secured Snowflake Database.

string

query

Query

Required The query to execute against the Snowflake Database.

string

INSERT INTO accounts (username,city) VALUES (:#username,:#city)

username

Username

Required The username to access a secured Snowflake Database.

string

consumedQuery

Consumed Query

A query to run on a tuple consumed.

string

DELETE FROM accounts where user_id = :#user_id

databaseName

Database Name

The name of the Snowflake Database.

string

delay

Delay

The number of milliseconds before the next poll.

integer

500

Dependencies

At runtime, the snowflake-source Kamelet relies upon the presence of the following dependencies:

camel:jackson
camel:kamelet
camel:sql
mvn:net.snowflake:snowflake-jdbc:3.14.5
mvn:org.apache.commons:commons-dbcp2:2.12.0

Camel JBang usage

Prerequisites

You’ve installed JBang.
You have executed the following command:

jbang app install camel@apache/camel

Supposing you have a file named route.yaml with this content:

- route:
    from:
      uri: "kamelet:snowflake-source"
      parameters:
        .
        .
        .
      steps:
        - to:
            uri: "kamelet:log-sink"

You can now run it directly through the following command

camel run route.yaml

Kamelet source file

https://github.com/apache/camel-kamelets/blob/main/kamelets/snowflake-source.kamelet.yaml