How are ' Views' represented in Collibra

Question

Are Table Views entered into Collibra Similar to Tables or what are the best practices for this type of asset?

Former User · Answer

The Catalog ingestion for MS SQL Server uses the Table Type to denote if it is a view. Is Collibra planning to start using this “Database View” asset type instead for their ingestions?

arthurburkhardt · Answer

There are multiple out of the box ways to support it, unfortunately.

The OOTB asset type 00000000-0000-0000-0000-000000031007 (Table) has a “Table type” attribute that flag views.
There is another OOTB asset type 00000000-0000-0000-0001-000400000009 (Database view), which is a subtype of the Table asset type

So take your pick, there are multiple ways to implement it.

Former User · Answer

Ronald, Thank you very much for your response. I will pass it along to my team. Steve.

Ronald Schaareman · Answer

Hi @steve.smith , Not sure what Catalog or the data lineage solution will make of it as we are not using either (yet), but we have created a View asset type and a View Column asset type analogue to the Table and Table Column counterparts. The big difference is that on views we have a separate attribute to indicate how the view is derived from its counterparts. Note that there are also out-of-the-box asset types for views (Tableau View and Database Views) but those did not suit our needs. I can imagine there are other ways to do this, but I hope this gives you an idea. Kind regards, Ronald

1	Grant Rollerson SUNCORP CORPORATE SERVICES PTY LTD
2	Tom Friesen Algonquin College
3	SB S Benson Plus3 IT
4	S stefan_busch
5	Brian Lloyd USA TODAY Co.
6	D daverichard