snowflake sink Snowflake Sink

Provided by: "Apache Software Foundation"

Support Level for this Kamelet is: "Preview"

Send data to a Snowflake Database.

This Kamelet expects a JSON-formatted body. Use key:value pairs to map the JSON fields and parameters. For example, here is a query:

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

Here is example input for the example query:

'{ "username":"oscerd", "city":"Rome"}'

Configuration Options

The following table summarizes the configuration options available for the snowflake-sink 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

databaseName

Database Name

The name of the Snowflake Database.

string

Dependencies

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

  • camel:jackson

  • camel:kamelet

  • camel:sql

  • mvn:net.snowflake:snowflake-jdbc:3.17.0

  • 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:timer-source"
      parameters:
        period: 10000
        message: 'test'
      steps:
        - to:
            uri: "kamelet:snowflake-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-sink.kamelet.yaml

Back to top