Fetch the Lineage from QlikSense(hosted) using Qlik Lineage Connector via QlikCloud

[ravinirmal-alation]

Hello Team,

Here is the setup I did in QlikSense (hosted)

1. Created an App with two data sources.
• CSV file (Static file based data source)
• Snowflake table (Table resides inside Snowflake cloud)
2. Created few sheets/reports:
• First sheet "cat_file" from CSV file
• Second sheet "snow_table" from Snowflake table
• Third sheet "cat_snow" from CSV file + Snowflake Table (combined)

My end-goal is to get the lineage:

1. Mapping of sheet with the data source
   • e.g. I need to know "cat_file" is created from CSV file
   • I need to know "cat_snow" is created from CSV file + Snowflake Table

To achieve this, we got an instruction from Qlik team to use the Qlik Lineage Connector, we followed below steps:

1. Create a Managed Space under “Analytics” in QlikCloud
2. On QlikSense(hosted):
   • Installed Qlik Lineage Connector
   • Setup target as QlikCloud with the Managed Space created above
   • Setup connector(source) for QlikSense
   • Created necessary rule
   • Run job to extract lineage from source and push into target

After this, we are getting lineage in QlikCloud, however the lineage is only between QVD file and QlikSense App, here is the screenshot:

What we are looking for?

1. On the left side, we need to know the QVD file is created from CSV file or Snowflake table, and further for Snowflake table we need to know the host, port and FQN of the table used.
2. On the right side, we need to know the sheet which is using which of the table/table columns, so we can map the sheet with the data source.

Request you to help with this, if we are not following the steps then please let us know the necessary steps.

Thanks,

Ravi N