Join Slack
Powered by
Hi! Can you point me on which file/s I need to mod...
# ingestion
s
stale-jewelry-2440
06/07/2021, 2:42 PM
Hi! Can you point me on which file/s I need to modify to have ingested also the views, and not only the tables, in MSSQL?
g
gray-shoe-75895
06/07/2021, 4:51 PM
Sure thing: you’d want to modify this file
https://github.com/linkedin/datahub/blob/master/metadata-ingestion/src/datahub/ingestion/source/sql_common.py
, since most of the sql-based sources use the common logic there. If you want to expand the metadata model, it’s super easy to do so
https://datahubproject.io/docs/advanced/no-code-modeling/
. Additionally, I expect you’ll find this SQLAlchemy method useful
https://docs.sqlalchemy.org/en/14/core/reflection.html#sqlalchemy.engine.reflection.Inspector.get_view_names
gray-shoe-75895
06/07/2021, 4:52 PM
Would love if you could contribute these changes back as well!
s
stale-jewelry-2440
06/08/2021, 6:54 AM
Thank you! I'll take a look
stale-jewelry-2440
06/08/2021, 2:12 PM
Done! It was easy 🙂 Did also a PR in Github
Open in Slack
Previous
Next