Covered in this article
Related pages
Latest Changelog
Version 1.2.1 ()
Snowflake component

Snowflake Component

A component for management over Snowflake database.

General information

Description

This is a component for management over Snowflake database on elastic.io platform. Snowflake supports the following constraint types from the ANSI SQL standard:

  • UNIQUE
  • PRIMARY KEY
  • FOREIGN KEY
  • NOT NULL Important: - Snowflake supports defining and maintaining constraints, but does not enforce them, except for NOT NULL constraints, which are always enforced. Overview of Snowflake Constraints It means that:
  • Multiple rows can be created with the same UNIQUE value
  • Multiple rows can be created with the same PRIMARY KEY value
  • etc

Environment variables

No required Environment variables.

Credentials

Account name

The full name of your account (provided by Snowflake). Note that your full account name might include additional segments that identify the region and cloud platform where your account is hosted

Credentials

  • Username: Snowflake user login name to connect with

  • Password: Password for the user

  • User role: Security role to use for the session after connecting

  • Warehouse: The default virtual warehouse to use for the session after connecting

  • Database Name: Database name

Triggers

  1. Get Rows Polling Trigger

Actions

Snowflake component includes the following actions:

  1. Execute custom query action - Action to execute custom SQL query from provided request string.

  2. Insert action - This action will execute insert query into the specified table.

  3. Lookup row by primary key action - This action will lookup row by it’s primary key

  4. Delete row by primary key action - This action will delete row by it’s primary key

  5. Upsert row by primary key action - This action will execute upsert row by it’s primary key.

  6. Select action -The action will execute an SQL query that can return multiple results.

  7. Execute stored procedure action - This action calls stored procedure

Get your free 14-day elastic.io trial account to use this component.