Snowflake Browser

Contents:

• Your Trifacta deployment must be connected to a running instance of Snowflake.

• The Snowflake browser appears when:
  • You select the Snowflake connection to create a dataset. See Import Data Page.
  • You choose to add a publishing location in Snowflake. See Run Job Page.

  • When exporting results, you can choose to write to a Snowflake database. See Publishing Dialog.

• For more information on interacting with Snowflake, see Using Snowflake.

Figure: Snowflake Browser

Browse Snowflake

Use the links and icons to browse for Snowflake databases, schemas, and tables. When you select a Snowflake database, you can select one of the available schema objects. Selecting a schema displays the tables that use that schema.

Identifier	Type	Description
	Schema	Click a schema link to display the tables that use the schema.
	Table	Click the Plus icon to select this Snowflake table as your source.
	Page navigation	Use these links to navigate between pages of databases and tables. NOTE: In some cases, subsequent pages of tables may be blank, and counts of tables may not match displayed figures. This is a known issue.
	Breadcrumb	Click the links in the breadcrumb trail to navigate.

Search List

To filter the list of databases or tables, enter a string in the Search box. The filter is applied as you type and matches anywhere in the name of a currently displayed database or table name.

Preview Table Data

Database tables are displayed by name only. To preview the data in the table, click the Eye icon next to the name of the table. 

Create Dataset with SQL

As needed, you can pre-filter the selected table inside the database. By entering a custom SQL statement, you can remove unnecessary data from the dataset that is extracted from the database, which enables faster and more meaningful imports of your database data. See Create Dataset with SQL.