RELATIONAL_ASSET_DETAILS table

The RELATIONAL_ASSET_DETAILS table is a unified relational asset view that consolidates metadata for databases, schemas, tables, views, columns, queries, materialized views, functions, and procedures into a single registry with domain-specific attributes.

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

Columns

The RELATIONAL_ASSET_DETAILS table includes the following columns:

Column	Description
guid	The asset's globally-unique identifier
asset_type	The type of asset (for example, Database, Schema, Table, View, Column)
status	The asset's status (for example, ACTIVE, DELETED)
database_name	Name of the database this asset belongs to
database_qualified_name	Fully-qualified name of the database this asset belongs to
database_schemas	GUIDs for schemas that exist within this database
schema_name	Name of the schema this asset belongs to
schema_qualified_name	Fully-qualified name of the schema this asset belongs to
source_read_query_cost	Total cost of read queries at source
source_total_cost	Total cost of all operations at source
source_cost_unit	The unit of measure for cost at source (for example, credits)
column_datatype	Data type of this column
column_is_nullable	Whether or not the values in this column can be null
column_queries	Queries that access this column
column_recent_users	List of usernames of the most recent users who read this column
column_table_name	Table in which this column exists
column_total_read_count	Total count of all read operations at source
column_view_name	View in which this column exists
function_language	Language of this function
function_return_type	Data type of the value returned by the function
function_schema	Schema in which this function exists
function_type	Type of this function
materialised_view_columns	List of GUIDs of columns that exist within this materialised view
materialised_view_definition	Definition of this materialized view
procedure_definition	Definition of this procedure
query_columns	List of GUIDs for columns this query accesses
query_parent	Collection or folder in which this query exists
query_raw_query_text	Raw query text
query_tables	List of GUIDs for tables this query accesses
query_views	List of GUIDs for views this query accesses
schema_materialised_views	GUIDs for materialised views that exist within this schema
schema_procedures	GUIDs for stored procedures that exist within this schema
schema_tables	GUIDs for tables that exist within this schema
schema_views	GUIDs for views that exist within this schema
table_columns	List of GUIDs of columns that exist within this table
table_column_count	Number of columns that exist within this table
table_queries	Queries that access this table
table_recent_users	List of usernames of the most recent users who read this table
table_row_count	Number of rows in this table
table_size_bytes	Size of this table, in bytes
table_total_read_count	Total count of all read operations at source
view_columns	List of GUIDs of columns that exist within this view
view_definition	SQL definition of this view
view_queries	Queries that access this view
view_recent_users	List of usernames of the most recent users who read this view
view_total_read_count	Total count of all read operations at source

See also

• Gold namespace
• PIPELINE_DETAILS table
• Atlan metamodel reference