This is a component for management over Snowflake database on elastic.io platform. Snowflake supports the following constraint types from the ANSI SQL standard:
NOT NULLImportant: - 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:
No required Environment variables.
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
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
This component has no trigger functions. This means it will not be accessible to select as a first component during the integration flow design.
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