Snowflake Data Asset Source

Create a Data Asset Through Snowflake

To create a data asset through Snowflake Source, configure parameters as follows:

Connection Name #

Connections are the service identifiers.

A connection name can be selected from the list if you have created and saved connection details for Snowflake earlier.

Or create one as explained in the topic - Snowflake Connection →

Warehouse Name #

Warehouse list for the selected Snowflake connection.

Schema Name #

Snowflake schema list of the DB of selected Snowflake connection.

Query #

Write Snowflake SQL query. Table name in query should be fully qualified name with DB and Schema name.

For example: select * from DBName.SchemaName.TableName

Maximum Records to Fetch #

Specify the maximum number of sample records you wish to keep in the data asset.

This feature helps in obtaining a manageable subset of data for testing and design purposes, facilitating efficient application development while optimizing resource usage.

Sampling Method #

This option offers flexibility in how you retrieve sample data.

Following are the ways:

• Top N: Retrieve the specified number of initial records from the data source based on the specified maximum number of rows. This is particularly useful when you want to analyze or design with a specific set of initial records.

• Random Sample: Fetch a random subset of records from your sample data, ensuring a diverse representation. This approach is valuable when you require a more comprehensive assessment of your data’s characteristics.

More Configurations #

Expand the More Configurations option to see the additional configuration parameters.

Inspect Query #

Provide same as Query but limit the records count. Used only during inspect and schema detection.

Pre Action Query #

A semicolon-separated list of SQL commands that are executed before reading data from Snowflake.

Post Action Query #

A semicolon-separated list of SQL commands that are executed after reading data from Snowflake.

Metadata #

Select the Snowflake table for metadata.

Table #

Table names in the database.