This Snap executes a Snowflake SQL Insert statement with given values. Document keys will be used as the columns to insert into, and their values will be the values inserted. Missing columns from the document will have null values inserted into them. 

Expected upstream Snaps:  The data to be written to the table can be defined by providing values upstream. The document generator Snaps JSON Generator can be used upstream.
 
Expected downstream Snaps: The Snap will output one document for every record written, hence any document processing Snap can be used downstream. 

Security Prerequisites: You should have the following permissions in your Snowflake account to execute this Snap: 

• Usage (DB and Schema): Privilege to use database, role, and schema.
• Create table: Privilege to create a new table or insert data into an existing table.

The following commands enable minimum privileges in the Snowflake Console:

grant usage on database <database_name> to role <role_name>;
grant usage on schema <database_name>.<schema_name>;
 
grant "CREATE TABLE" on database <database_name> to role <role_name>;
grant "CREATE TABLE" on schema <database_name>.<schema_name>;

For more information on Snowflake privileges, refer to Access Control Privileges.

This Snap uses the INSERT command internally. It enables updating a table by inserting one or more rows into the table.

Specify the database schema name. In case it is not defined, then the suggestion for the Table Name will retrieve all table names of all schemas. The property is suggestible and will retrieve available database schemas during suggest values.

Default value:  [None]

Specify the name of the table to execute insert-on.

Default value:  [None]