Hi All, I have ingested some databases from a micr...
# all-things-deployment
a
Hi All, I have ingested some databases from a micrsoft sql server. Can anyone point me in the right direction as to how I enable the lineage tab on the database tables? I watched the lineage 101 seminar run by the datahub team but it only references Snowflake and BigQuery. Am I right in thinking perhaps this feature isn't yet available for MSSQL? Thanks in advance.
e
Hey, we don’t support native lineage support on MSSQL. For snowflake, bigquery, and redshift, we parse the audit logs to get this information. This has not been implemented for other sources yet. External systems like airflow or dbt that deals with the pipeline across tables on MSSQL can be utilized to fetch this information if possible! What system do you use at your company to generate MSSQL tables?
plus1 1
l
If you want to add lineage through some manual effort, this is available for now: https://datahubproject.io/docs/metadata-ingestion/source_docs/file_lineage
m
@adamant-magazine-62649 Were you able to try this file based lineage? Trying to achieve the same lineage issue you were facing, any pointers would be great
a
Hey @mammoth-fall-12031 No I wasn't able to try the file based lineage out. The url shared https://datahubproject.io/docs/metadata-ingestion/source_docs/file_lineage results in a page not found response.
👍 1
m
@adamant-magazine-62649: docs have moved. This particular one is here: https://datahubproject.io/docs/generated/ingestion/sources/file-based-lineage
plus1 1
nav bar looks the same:
a
Thanks @mammoth-bear-12532 I will take a look into this option.