BI_ASSETS view

The BI_ASSETS view contains all assets that pertain to BI tools, such as Tableau, Power BI, Looker, and other business intelligence platforms.

Overview

The BI_ASSETS view provides a simplified, curated view of all business intelligence assets in your Atlan tenant. This view includes entities from the BI class of assets in the Atlan metamodel.

Entity types included

This view includes all entity types under the BI class of assets in the Atlan metamodel, such as:

BIReport - BI reports and dashboards
BIChart - Charts and visualizations
BIDashboard - BI dashboards

For complete entity type definitions and properties, refer to the Atlan Developer documentation.

Common columns

The BI_ASSETS view includes the common columns for domain-specific views:

Column	Description
`GUID`	The asset's globally-unique identifier
`TYPE`	The asset's type
`NAME`	The asset's name
`QUALIFIED_NAME`	The asset's unique, fully-qualified name
`DESCRIPTION`	The asset's description
`README`	The asset's readme
`STATUS`	The asset's status (for example, active or archived)
`CREATED_AT`	The time (epoch) at which the asset was created, in milliseconds
`CREATED_BY`	The user or account that created the asset
`UPDATED_AT`	The time (epoch) at which the asset was last updated, in milliseconds
`UPDATED_BY`	The user or account that last updated the asset
`CERTIFICATE_STATUS`	The asset's certification status
`CERTIFICATE_UPDATED_BY`	The user or account that last updated the asset's certification status
`CERTIFICATE_UPDATED_AT`	The time (epoch) at which the asset's certification status was last updated, in milliseconds
`CONNECTOR_NAME`	The type of connector through which this asset is accessible
`CONNECTOR_QUALIFIED_NAME`	The unique, fully-qualified name of the connection through which this asset is accessible
`OWNER_USERS`	List of users who own this asset
`POPULARITY_SCORE`	The asset's popularity score
`TAGS`	List of tags attached to this asset
`GLOSSARY_TERMS`	List of glossary terms associated with this asset
`HAS_LINEAGE`	Whether this asset has lineage (true) or not (false)
`INPUT_GUIDS_TO_PROCESSES`	Processes to which this asset is used as an input
`OUTPUT_GUIDS_TO_PROCESSES`	Processes from which this asset is produced as output

For detailed information about these properties, refer to the Atlan metamodel reference.

Relationships

The BI_ASSETS view can be joined with other semantic views:

Relationship	Target view	Join condition	Type
BI to SQL	SQL_ASSETS	`BI_ASSETS.input_guid = SQL_ASSETS.guid`	Many-to-many
BI to Glossary	GLOSSARY_ASSETS	`BI_ASSETS.guid = GLOSSARY_ASSETS.asset_guid`	Many-to-many
BI to Tags	ASSET_TAGS	`BI_ASSETS.guid = ASSET_TAGS.asset_guid`	One-to-many
BI to Custom Metadata	CUSTOM_METADATA	`BI_ASSETS.guid = CUSTOM_METADATA.asset_guid`	One-to-many

Example queries

Find all BI reports by connector

SELECT 
  connector_name,
  COUNT(*) AS report_count,
  COUNT(DISTINCT owner_users) AS unique_owners
FROM semantic_views.bi_assets
WHERE type = 'BIReport'
  AND status = 'ACTIVE'
GROUP BY connector_name
ORDER BY report_count DESC;

Find BI assets without descriptions

SELECT 
  name,
  qualified_name,
  type,
  connector_name
FROM semantic_views.bi_assets
WHERE (description IS NULL OR description = '')
  AND status = 'ACTIVE'
ORDER BY connector_name, name;

Find certified BI dashboards

SELECT 
  name,
  qualified_name,
  certificate_status,
  owner_users,
  popularity_score
FROM semantic_views.bi_assets
WHERE type = 'BIDashboard'
  AND certificate_status = 'VERIFIED'
ORDER BY popularity_score DESC;

View definition

The BI_ASSETS view is derived from the ENTITY_METADATA namespace, aggregating data from BI entity type tables in the Atlan metamodel. The view includes only high-signal columns and excludes low-signal or null columns to minimize cognitive overhead.

AI semantic context

For AI tools like Snowflake Cortex and Databricks Genie, semantic context files are available:

YAML file: Snowflake Cortex semantic model specification
Markdown file: Databricks Genie and other AI tool instructions

These files include logical table definitions, relationships, dimensions, measures, and sample SQL queries. Download the semantic context files from the Lakehouse documentation.

Overview​

Entity types included​

Common columns​

Relationships​

Example queries​

Find all BI reports by connector​

Find BI assets without descriptions​

Find certified BI dashboards​

View definition​

AI semantic context​

See also​