Enterprise Data Catalog User Guide > Part II: Analytics > Analyze Reports > Data Asset Analytics Database Views for Reports
  

Data Asset Analytics Database Views for Reports

You can use Data Asset Analytics database views to build custom reports and charts using reporting tools such as Tableau, Microstrategy etc.
Each view displays different types of information. You can transform data based on business requirements and use any business intelligence reporting tool that supports queries and provides a user interface to view the reports. When you build a custom report, you specify a query based on one or more views that provide the information you need.
All the reports types provided in Data Asset Analytics use one of these views.
Note: You must connect to the database as a user with read only access to the Data Asset Analytics views. You can also connect to the database using a JDBC or ODBC driver based on the database type of the Data Asset Analytics repository to import the view data into a reporting tool.

DAA_ASSET_ENRICHMENT_SV

Displays the asset name, asset type, name of the resource to which the asset belongs, and the type of enrichment performed.
The Asset Enrichment report uses this view. The following table describes the view columns:
View Column
Description
ASSET_DELETE_TIME
The time when the asset was deleted
ASSET_ID
The path of the asset in the Catalog
RESOURCE_NAME
The name of the resource to which the asset belongs
RESOURCE_TYPE
The type of the resource
ASSET_NAME
The name of the asset on which enrichment is performed
ASSET_TYPE
The type of the asset
ENRICHMENT_TYPE
The type of enrichment performed on the asset. It can be one of the following:
  • - Business description
  • - Business term association
  • - Classification
  • - Business title association
  • - Asset certification
  • - Data domain association
  • - Data owner and data steward association
ENRICHMENT_METHOD
The method by which, the enrichment is performed. For example, manual, inferred, etc.
ENRICHED_BY
The user who performed the enrichment
ENRICHED_TIME
The time when the enrichment was performed
ASSET_CREATE_TIME
The time when the asset was created in the Catalog

DAA_ASSET_COUNT_SV

Displays the asset count by grouping the assets by asset type for each resource.
The Asset Count report uses this view. The following table describes the view columns:
View Column
Description
RESOURCE_NAME
The name of the resource to which the asset belongs
RESOURCE_TYPE
The type of the resource
ASSET_TYPE
The type of the asset
ASSET_COUNT
The number of assets of a particular asset type
SCAN_BY
The name of the user who initiated the resource scan
SCAN_TIME
The time at which the scan was performed

DAA_ASSET_LINEAGE_FRM_TO_LINKS_SV

Displays details of the assets that contain lineage.
The Asset Lineage Links report uses this view. The following table describes the view columns:
View Column
Description
FROM_RESOURCE_NAME
The resource from where the lineage link is created
FROM_RESOURCE_TYPE
The type of the resource from where the lineage link is created
FROM_ASSET_NAME
The name of the asset from where the lineage link is created
FROM_ASSET_TYPE
The type of the asset from where the lineage link is created
FROM_ASSET_ID
The path to the asset from where the lineage link is created
TO_RESOURCE_NAME
The resource to which the lineage link is associated
TO_RESOURCE_TYPE
The type of the resource to which the lineage link is associated
TO_ASSET_NAME
The name of the asset to which the lineage link is associated
TO_ASSET_TYPE
The type of the asset to which the lineage link is associated
TO_ASSET_ID
The path to the asset to which the lineage link is associated
LINEAGE_ENRICH_TIME
The time when the lineage link was created
LINEAGE_DELETE_TIME
The time when the lineage link was deleted

DAA_ASSET_LINEAGE_IMPACT_SV

Displays all the assets that have lineage and impact.
The Assets with Lineage and Impact report uses this view. The following table describes the view columns:
View Column
Description
RESOURCE_NAME
The name of the resource to which the asset belongs
RESOURCE_TYPE
The type of the resource to which the asset belongs
ASSET_NAME
The name of the asset that has lineage or impact
ASSET_TYPE
The type of the asset
HAS_LINEAGE
Specifies if the asset has lineage
HAS_IMPACT
Specifies if the asset has impact
ASSET_ID
The path of the asset in the Catalog
ASSET_CREATE_TIME
The time at which the asset was created in the Catalog
ASSET_DELETE_TIME
The time at which the asset was deleted from the Catalog

DAA_ASSET_USAGE_SV

Displays the usage details for each asset such as the name of the user who accessed the asset and the list of Enterprise Data Catalog features used.
The Asset Usage report uses this view. The following table describes the view columns:
View Column
Description
USER_LOGIN_NAME
The username of the user who accessed the asset
SECURITY_DOMAIN
The security domain to which the user belongs
RESOURCE_NAME
The name of the resource to which the asset belongs
RESOURCE_TYPE
The type of the resource to which the asset belongs
ASSET_USED
The name of the asset used
ASSET_ID
The path of the asset in the Catalog
ASSET_TYPE
The type of the asset
FEATURE_USED
Specifies one of the following Enterprise Data Catalog features that were used:
  • - Overview
  • - Data Element Details
  • - Metric Groups
  • - Keys and Joins
  • - Lineage and Impact
  • - Relationships
  • - Data Quality
  • - Reviews and Ratings
  • - Questions and Answers
  • - Change Summary
  • - Data Preview
  • - Data Provisioning
EVENT_TIME
The time when the asset was accessed

DAA_BUSINESS_TERM_ASSOC_SV

Displays details about the business terms that are associated with assets during enrichment.
The Business Term Association Report uses this view. The following table describes the view columns:
View Column
Description
BUSINESS_TERM
The name of the associated business term
BUSINESS_GLOSSARY
The name of the business glossary or Axon glossary to which the term belongs
GLOSSARY_SOURCE
Specifies whether the business term belongs to business glossary or Axon glossary
RESOURCE_NAME
The name of the resource to which the asset belongs
RESOURCE_TYPE
The type of the resource to which the asset belongs
ASSET_NAME
The name of the enriched asset
ASSET_TYPE
The type of the enriched asset
ASSOCIATION_TYPE
The type of enrichment performed. For example, business title, business description, etc.
BUSINESS_TERM_CREATE_TIME
The time when the business term was created in the Catalog
BUSINESS_TERM_DELETE_TIME
The time when the business term was deleted from the Catalog
ENRICHED_BY
The name of the user who has performed the enrichment
ENRICHMENT_METHOD
Specifies how the enrichment was performed. For example, manual, inferred, etc.
ENRICHED_TIME
The time when the enrichment was performed
ENRICHMENT_DELETE_TIME
The time when the enrichment was deleted
ASSET_ID
The path of the asset in the Catalog
BT_ASSET_ID
The path of the business term in the Catalog

DAA_DATA_DOMAIN_ASSOC_SV

Displays details about the data domains that are associated with assets.
The Data Domain Association report uses this view. The following table describes the view columns:
View Column
Description
DATA_DOMAINS
The name of the data domain that is associated
DOMAIN_TYPES
The type of the data domain that is associated
RESOURCE_NAME
The name of the resource to which the asset belongs
RESOURCE_TYPE
The type of the resource to which the asset belongs
ASSET_NAME
The name of the asset associated with the data domain
ASSET_TYPE
The type of the asset associated with the data domain
ENRICHED_BY
The name of the user who has performed the data domain association
ENRICHMENT_METHOD
Specifies how the asset is associated with the data domain
ENRICHED_TIME
The time when the data domain enrichment was performed
ENRICHMENT_DELETE_TIME
The time when the data domain enrichment was deleted
DATA_DOMAIN_CREATE_TIME
The time when the data domain was created in the Catalog
DATA_DOMAIN_DELETE_TIME
The time when the data domain was deleted from the Catalog
ASSET_ID
The path of the asset in the Catalog

DAA_RESOURCE_SCAN_HIST_SV

Displays the scan details of the resource such as the type of scan and the name of the user who initiated the scan. The view also displays the resource configuration.
The Resource Scan History report uses this view. The following table describes the view columns:
View Column
Description
RESOURCE_NAME
The name of the scanned resource
RESOURCE_TYPE
The type of the resource
SCAN_TYPE
The type of scan. For example, manual, offline, scheduled, etc.
SCAN_BY
The name of the user who has initiated the scan
SCAN_TIME
The time when the resource was scanned
IS_SOURCE_METADATA
Specifies whether source metadata is enabled
IS_COMPOSITE_DOMAIN_DISCOVERY
Specifies whether domain discovery is enabled
IS_DATA_DISCOVERY
Specifies whether data discovery is enabled
IS_BUSINESS_TERM_ASSOCIATION
Specifies whether business term association is enabled
IS_DATA_PROVISIONING
Specifies whether data provisioning is enabled
IS_CUSTOM_ATTRIBUTE_APPLIED
Specifies whether custom attributes are enabled

DAA_USER_COLLABORATION_SV

Displays details related to the collaboration activities performed by users.
The User Collaboration report uses this view. The following table describes the view columns:
View Column
Description
USER_NAME
The name of the user who has collaborated on the asset
RESOURCE_NAME
The name of the resource to which the collaborated asset belongs
RESOURCE_TYPE
The type of the resource to which the collaborated asset belongs
ASSET_NAME
The name of the asset on which the user has collaborated
ASSET_TYPE
The type of the asset
COLLABORATION_ACTION
The type of collaboration performed. For example, review, question and answer, etc.
REFERENCE_ACTION
The reference collaboration activity on which the collaboration is done
COLLABORATION_TIME
The time when the collaboration is done
ASSET_ID
The path of the asset in the Catalog

DAA_USER_GROUPS_SV

Displays user specific information such as the group that the user is associated with, the group association and disassociation times, and the user creation and deletion times.
The User and User Groups report uses this view. The following table describes the view columns:
View Column
Description
USER_LOGIN_NAME
The name of the user
Note: If a user belongs to multiple user groups, the view displays multiple records of the same user with a different user group name.
USER_GROUP_NAME
The user group to which the user belongs
IS_ADMIN
Specifies whether the user is an administrator
SECURITY_DOMAIN
The name of the security domain to which the user belongs
USER_CREATE_TIME
The time when the user was created
Note: The user created and deleted dates depend on the time you synchronize the user information into Data Asset Analytics.
USER_DELETE_TIME
The time when the user was deleted
USR_GRP_ASSOC_CREATE_TIME
The time when the user was associated with the user group
USR_GRP_ASSOC_DELETE_TIME
The time when the user was deleted from the associated user group

DAA_USER_LOGIN_SV

Displays the login information for users and their group association and disassociation times.
The User Logins report uses this view. The following table describes the view columns:
View Column
Description
USER_LOGIN_NAME
The name of the users who logged in to Enterprise Data Catalog applications.
Note: If a user belongs to multiple user groups, Data Asset Analytics displays multiple records of the same user with a different user group name.
USER_GROUP_NAME
The name of the user group to which the user belongs
LOGIN_APP_NAME
Specifies whether the user has logged into enterprise data catalog or the catalog administrator application
LOGIN_TIME
The time when the user logged into the application
SECURITY_DOMAIN
The name of the security domain to which the user belongs
USR_GRP_ASSOC_CREATE_TIME
The time when the user was associated with the user group
USR_GRP_ASSOC_DELETE_TIME
The time when the user was removed from the associated user group

DAA_USER_SEARCH_SV

Displays information about the catalog searches performed by users.
The User Searches report uses this view. The following table describes the view columns:
View Column
Description
USER_LOGIN_NAME
The name of the user who performed the search
USER_GROUP_NAME
The name of the user group to which the user belongs
SEARCH_STRING
The search string used by the user for searching
SEARCH_TIME
The time when the search was performed
USR_GRP_ASSOC_CREATE_TIME
The time when the user was associated with the user group
USR_GRP_ASSOC_DELETE_TIME
The time when the user was removed from the associated user group