Skip to content

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.