Snowflake harvester

Use this harvester to make the tables and views of a Snowflake database explorable in your marketplace without copying their records into Huwise. The harvester turns each table and view into a zero-copy dataset.

See Zero-copy data sharing (virtualization) to learn what users can do with these datasets.

This harvester is part of the zero-copy data sharing add-on, available on Advanced and Ultimate plans. Contact your Customer Success Manager for more information.

Parameters

Name	Description	Example
Server (`server`)	The Snowflake account to connect to	`<account_identifier>.snowflakecomputing.com`
warehouse (`warehouse`)	The Snowflake warehouse (compute resource) that runs the queries	`COMPUTE_WH`
Database (`database`)	The database whose tables and views you want to import. Every schema is included.	`SALES_DB`
Role (`role`)	The Snowflake role used to run the queries. It must be a valid role for the user.	`ANALYST`
Authentication method	How the harvester signs in: Key Pair or Password or Access Token
User ID (`userid`)	Your Snowflake user identifier
Password or Access Token (`password`)	With Password or Access Token: your password or access token
Private key (`key`)	With Key Pair: your private key
Private key password (`password`)	With Key Pair: the password of your private key, if it has one
Include empty tables (`include_empty_tables`)	Turn it on to also import tables that contain no records. Otherwise, they're skipped.

Metadata

Each zero-copy dataset gets its title and description from its table. For example, the orders table in the sales schema becomes a dataset titled sales.orders, with the table's comment as its description.

The harvester fills in the following metadata, and these mappings can't be changed. You can complete the other metadata yourself, for example themes or keywords, before publishing. The technical IDs are provided for those working with the APIs.

Snowflake source	Snowflake source in the API	Huwise metadata	Huwise field ID in the API
The table's schema and name, as `schema.table`	`TABLE_SCHEMA` + `TABLE_NAME`	Title	`asset.title`
The table's comment	`COMMENT`	Description	`asset.description`
The table's creation date	`CREATED`	Creation date	`asset.created_at`
The table's last modification date	`LAST_ALTERED`	Modification date	`asset.updated_at`
Always "Data"	Built by the harvester	Category	`asset.category`