ASSETS table
The ASSETS table is a unified asset registry that consolidates all assets across SQL, BI, pipeline, data quality, and object domains. It serves as the central lookup source for resolving GUIDs to human-readable names, types, and associated metadata including ownership details.
This table is designed to be the starting point for all queries on the Gold namespace.
For complete entity type definitions and properties, refer to the Atlan Developer documentation.
Columns
The ASSETS table includes the following columns:
| Column | Description |
|---|---|
guid | The asset's globally-unique identifier |
asset_type | The asset's type (for example, Table, Column, Dashboard) |
status | The asset's status (for example, ACTIVE, DELETED) |
asset_name | The asset's name |
display_name | Human-readable display name of the asset, often differs from the technical name |
asset_qualified_name | The asset's unique, fully-qualified name |
description | The asset's system-generated or source-catalog description |
user_description | User-provided description of the asset, as authored in Atlan (separate from system description) |
readme_guid | The GUID for the asset's readme |
created_at | Time (epoch) at which the asset was created, in milliseconds |
created_by | The user or account that created the asset |
updated_at | 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 | 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 |
source_created_at | Time (epoch) at which this asset was created in the source system, in milliseconds |
source_created_by | Name of the user who created this asset in the source system |
source_updated_at | Time (epoch) at which this asset was last updated in the source system, in milliseconds |
source_updated_by | Name of the user who last updated this asset, in the source system |
owner_users | List of users who own this asset |
owner_groups | List of groups who own this asset |
term_guids | List of glossary term GUIDs associated with the asset |
popularity_score | The asset's popularity score |
has_lineage | Whether this asset has lineage (true) or not (false) |
domain_guids | List of DataDomain GUIDs associated with the asset |
product_guids | List of DataProduct GUIDs associated with the asset |
asset_ai_generated_description | AI-generated description for the asset (Data Steward) |
user_defined_type | The user-defined type name for CustomEntity assets; NULL for all native asset types |
Common filters
Use the assets table to filter down to the assets you care about before joining to detail tables. This keeps queries focused and improves performance.
| What you want | Column to filter | Example value |
|---|---|---|
| Specific connector | connector_name | 'snowflake', 'bigquery', 'tableau' |
| Specific asset type | asset_type | 'Table', 'Column', 'Dashboard' |
| Active assets only | status | 'ACTIVE' |
| Certified assets | certificate_status | 'VERIFIED' |
| Assets with owners | owner_users | ARRAY_SIZE(owner_users) > 0 |
| Popular assets | popularity_score | > 50 |
| Assets with lineage | has_lineage | = true |
| Assets with terms | term_guids | ARRAY_SIZE(term_guids) > 0 |
| Assets in a domain | domain_guids | ARRAY_SIZE(domain_guids) > 0 |
| Specific database | asset_qualified_name | LIKE '%/DATABASE_NAME/%' |