Hi! Can you point me on which file/s I need to mod...
# ingestion
s
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
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
Would love if you could contribute these changes back as well!
s
Thank you! I'll take a look
Done! It was easy 🙂 Did also a PR in Github