Snowflake
This connector is used to connect to Snowflake databases.
The connector needs a running or an auto-starting Snowflake Virtual Warehouse. It uses ACCOUNT_USAGE from the internal imported ‘SNOWFLAKE’ metadata database and INFORMATION_SCHEMA from each database available.
For ease of setup, it is recommended to use the ACCOUNTADMIN role as this will provide access to all relevant tables, but a custom role can be created.
Account: Snowflake account name
Host: Full host name of the Snowflake instance
User: Snowflake username
Password: Snowflake password
Role: Queries will be executed by the user using this Snowflake role
Warehouse: Snowflake computing warehouse to use when running queries
Snowflake rules
Extract Tables: When enabled, Qlik Lineage Connectors gather tables and fields definitions from the system table, together with some metadata surrounding them.
Extract Views: When enabled, Qlik Lineage Connectors go through the defined views in the database, and parses the definitions.
-
Create view dependencies: If enabled, extract views not only gather the output from said views, but also the internal lineage and creates connections to the raw tables used in each view.
Extract Procedures: When enabled, Qlik Lineage Connectors go through the defined procedures in the database, and parses the definitions.
-
Create procedure dependencies: If enabled, Qlik Lineage Connectors analyse the SQL statements in the procedure definitions and generates lineage on field level to other database entities.
Extract Functions: When enabled, Qlik Lineage Connectors go through the defined functions in the database, and parses the definitions.
-
Create function dependencies: If enabled, Qlik Lineage Connectors analyse the SQL statements in the function definitions and generates lineage on field level to other database entities.
Include Databases: A semicolon separated list of databases to act upon with the above ruleset. Does not support wildcard.
Schema Filter: The schema filter is used to decide what schemas to include. For example, you could use the definition *.dbo.* ; AdventureWorks.Sales.* to gather all tables from the dbo schema of all your databases, but also the tables from the Sales schema on the AdventureWorks catalog.
Folder Alias
A folder alias will synchronize the different references that a connector may read from. For example, an application may refer to a folder as \\mssql01-prod\sources but in a script it is referred to as \\mssql01-prod.company.com\sources. In this case, the two different references point to the same folder, but it will not appear like that in the lineage graphs. By adding the alias, the resource name will be synchronized, and the graphs will reconcile.