Can Lineage Harvester Read queries created outside the database
Hi,
I have been trying to extract lineage from redshift database, the lineage harvester has been able to get the lineage from the database for most of the tables. But some of the tables don’t have the lineage information and it says no source code found.
I have spoken to my database team and they mentioned that some of the tables and columns were created in a external database called Solita but the SQl queries are still visible when we open the Redshift database.
So, wanted to check if the lineage harvester can read SQL queries that are created or modified in Solita but are stored in the redhsift database, or do the queries need to be created in the Redshift database only?
sontamkeerthana
Posted 3 years ago · Edited 2 years ago
0 comments