ASSETS table
The ASSETS table is a central lookup table that lists all assets in Atlan and important attributes. This table is designed to be the starting point for all queries on the Gold layer.
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 |
ASSET_NAME | The asset’s name |
ASSET_QUALIFIED_NAME | The asset’s unique, fully-qualified name |
DESCRIPTION | The asset’s description |
README_GUID | The GUID for 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 |
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 |
POPULARITY_SCORE | The asset’s popularity score |
TAGS | List of tags attached to this asset |
CUSTOM_METADATA | List of custom metadata attributes (name/value pairs) attached to this asset |
HAS_LINEAGE | Whether this asset has lineage (true) or not (false) |
For detailed information about these properties, refer to the Atlan metamodel reference.
Common filters
Use the ASSETS table to filter down to the assets you care about before joining to detail views. 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 with tags | TAGS | ARRAY_SIZE(TAGS) > 0 |
| Specific database | ASSET_QUALIFIED_NAME | LIKE '%/DATABASE_NAME/%' |