Prepare Snowflake SQL-API <source ID> configuration file

When you create technical lineage for Snowflake by using the SQL-API ingestion method, you can create a <source ID> configuration file to configure the metadata that Collibra Data Lineage collects.

{
     "displaySampleQueries": true
}	

Steps

1. Create a new JSON file in the lineage harvester config folder.
2. Name the JSON file as <sourceId>.conf, where <sourceId> is the same as the value of the sourceId property in the lineage harvester configuration file and the file extension must be .conf.
   Example If the value of the sourceId property in the lineage harvester configuration file is my-snowflake, the name of your JSON file must be my-snowflake.conf.
3. For each database in Snowflake, add the following content to the JSON file:

   Property	Description	Required?
   displaySampleQueries	Indicates whether to display transformations with a question mark (?) or with actual values from queries in the Source code pane in the technical lineage graph. For example, you can choose to display WHERE amount < 100 or WHERE amount < ?. Specify one of the following values: true Actual values from queries are displayed. false A question mark (?) is displayed. This is the default value	No

4. Save the <source ID> configuration file.