Asset types

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;

GO


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