Snowflake Publish Assistant

snowflake-publish-assistant

Supports publishing extracted data and metadata to Snowflake

This assistant allows the publishing of metadata, data, and data structures to Snowflake for further data transformation. The data passed should be stored in a parquet file format.

You can list a component in the marketplace, and define if you want it to be a template.

✅ Available in Marketplace

✅ Can be used as a template to create a new component

What is an Assistant?

Assistants are the building blocks of the automation system. They are the components that decides the actual work of the automation system. They can be used to perform a wide variety of tasks, from sending notifications, building pipelines and organizing workflow.

Options

Below are the options for this assistant.

Option Name	Default	Required?	Type	Description
snowflake_account		False	string	The Snowflake account to publish to
snowflake_username		True	string	The Snowflake username to use for publishing
snowflake_password		True	password	The Snowflake password to use for publishing
snowflake_database		True	string	The Snowflake database to use for publishing
snowflake_schema		True	string	The Snowflake schema to use for publishing
snowflake_staging_area		True	string	The Snowflake staging area to use for publishing
role		False	string	The Snowflake role to use for publishing
filename_expression	document_family.path + "-" + taxon.external_name + ".parquet"	False	string	The expression to use for the filename
data_store	None	True	tableStore	Data store to extract from
add_label	None	False	string	The label to add to the document after publishing successfully
delete_after_publish	False	False	boolean	Delete the document and extracted data after publishing

## Reactive

This assistant can be triggered by content based events on stores which it is monitoring.