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.
Below are the options for this assistant.
|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.