By default, 2 data asset types are provided.
Asset Type 1 for Tables
Asset Type 2 for Views
Customize your data asset types
You can add additional Asset types in sidecar or remove and modify the existing ones.
The asset types other than table and view will not be taken into consideration by the feature “Discover Assets”.
To do so, you need to update the table [dbo].[Asset_Type] .
The following fields are populated automatically:
[Asset_Type_Id] : Primary key
[SYS_LastModified] : date of the insert or update
[SYS_LastModifiedBy] : SQL user that made the last modification
If you delete or truncate the table, you need to initialize the table
SET IDENTITY_INSERT dbo.Asset_Type ON;
INSERT INTO dbo.Asset_Type (Asset_Type_Id, Asset_Type_Name,Asset_Type_Desc,SYS_LastmodifiedBy)
VALUES (-1,'Not defined','Allows to associate undefined asset types',SYSTEM_USER);
SET IDENTITY_INSERT dbo.Asset_Type OFF;
Info: [SYS_IsDeleted] need to be set to 0
This column allows you to do a soft delete of a record [SYS_IsDeleted]=1
The record will stay in the table but will not be displayed in sidecar. In case of error, you can revert the change by inserting the value 0