This is a component for management over Snowflake database on elastic.io platform. Snowflake supports the following constraint types from the ANSI SQL standard:
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:
PRIMARY KEY value
No required Environment variables.
Username: Snowflake user login name to connect with
Password: Password for the user
Account Name: The full name of your account (provided by Snowflake). Please enter the name without
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
Snowflake component includes the following actions:
Execute custom query action - Action to execute custom SQL query from provided request string.
Insert action - This action will execute insert query into the specified table.
Lookup row by primary key action - This action will lookup row by it’s primary key
Delete row by primary key action - This action will delete row by it’s primary key
Upsert row by primary key action - This action will execute upsert row by it’s primary key.
Execute stored procedure action - This action calls stored procedure