Skip to main content Skip to complementary content
Qlik Resources
Loading SearchUnify's search If you need assistance with your product, please contact Qlik Support.
Qlik Customer Portal
Loading SearchUnify's search If you need assistance with your product, please contact Qlik Support.
Qlik Customer Portal

Centralizing Snowflake metadata

Use the Snowflake metadata wizard to connect to Snowflake and retrieve table schemas.

About this task

Information noteNote:

The Snowflake metadata wizard does not support Snowflake views.

Procedure

  1. In the Repository tree view, expand the Metadata node, right-click Db Connections, and click Create connection.
    Create connection option selected by right-clicking.
  2. Select Snowflake from the list and click Finish.
  3. In the Create Snowflake dialog box, enter a name for the connection and click Next.
    Create Snowflake dialog box.
  4. Specify the following connection settings:
    • Account: enter the account name that has been assigned to you by Snowflake.
    • User ID: enter your Snowflake user ID.
    • Password: enter the password associated with the user ID.
    • Warehouse: enter the name of the Snowflake warehouse.
    • Schema: enter the name of the database schema.
    • Database: enter the name of the Snowflake database.
    Information noteNote:

    The Warehouse, Schema, and Database names are case-sensitive and typically uppercase in Snowflake.

  5. Click Check connection to verify the configuration.
    If the connection information is correct, a confirmation dialog box appears. Click OK to close the dialog box.
  6. Click Next.
  7. Specify or update the values for the following advanced properties and click Finish to close the dialog box.
    Edit Snowflake dialog box.
    • Login Timeout: specify how long to wait for a response when connecting to Snowflake before returning an error.
    • Tracing: select the log level for the Snowflake JDBC driver. If enabled, a standard Java log is generated.
    • Role: enter the default access control role to use to initiate the Snowflake session.

      This role must already exist and has been granted to the user ID you are using to connect to Snowflake. If this field is left empty, the PUBLIC role is automatically granted. For more information about the Snowflake access control model, see Understanding the Access Control Model.

    The newly created Snowflake connection is displayed under Snowflake in the Db Connections node in the Repository tree view, along with the schemas of the tables you retrieved.
  8. Right-click the Snowflake connection and click Retrieve schema to select the tables to include.
    Retrieve schema option.
  9. In the Filter for the Table dialog box, set the filter conditions and click Next.
  10. Select the tables whose schema you want to retrieve and click Next.
    Select Schema to create dialog box.
  11. Edit the table schemas and click Finish.
    Add a Schema on repository dialog box.

Results

You can add a Snowflake component to the design workspace by dragging and dropping the Snowflake connection or any retrieved table from the Repository view to reuse the connection or schema information. For more information, see Using centralized metadata in a Job and the related Snowflake component documentation.

In the Repository tree view, you can also:

  • To modify the connection, right-click the connection node under Db Connections and select Edit this Snowflake from the context menu.
  • To edit a table schema, right-click the table node and select Edit Schema from the context menu.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here