2 Home

gitea_admin edited this page 2026-03-11 14:40:16 +00:00

Table of Contents

• Snowflake Sink
• Metadata
• Properties
• Dependencies

Snowflake Sink

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"}'

Metadata

Property	Value
Type	sink
Group	SQL
Namespace	Database
Support Level	Preview
Provider	Apache Software Foundation

Properties

Name	Type	Required	Default	Description
instanceUrl	string	✓		The Instance url
username	string	✓		The username to access a secured Snowflake Database.
password	string	✓		The password to access a secured Snowflake Database.
query	string	✓		The query to execute against the Snowflake Database.
databaseName	string			The name of the Snowflake Database.

Dependencies

• camel:jackson
• camel:kamelet
• camel:sql
• mvn:net.snowflake:snowflake-jdbc:3.22.0
• mvn:org.apache.commons:commons-dbcp2:2.13.0