Data Catalog Views
Data Catalog integration with Autonomous Database provides numerous tables and views.
These tables and views help you understand:
- Available Data Catalog assets. Get information about any type of Data Catalog asset - including databases, object stores, and more.
- Information about the Data Catalog Object Storage assets and entities that have been synchronized with Autonomous Database. This includes details about how Data Catalog items (assets, folders and entities) map to Autonomous Database objects (i.e. schemas and external tables).
- Metadata sync executions. Review details about sync jobs, including any issues that may have occurred during synchronization.
Topics
ALL_DCAT_GLOBAL_ACCESSIBLE_CATALOGS View
This view lists all accessible catalogs across all regions, along with the level of access privileges for each catalog.
Column | Datatype | Description |
---|---|---|
|
VARCHAR2(4000) |
Catalog OCID |
CATALOG_NAME |
VARCHAR2(4000) |
Name of the catalog |
CATALOG_REGION |
VARCHAR2(4000) |
Name of the catalog region |
CATALOG_SCORE |
NUMBER |
The catalog score is a numeric value calculated from the privileges configured for the Data Catalog access credential. A higher catalog score means greater privileges, which may equate to a higher likelihood that this catalog is intended for use with this Autonomous Database instance. |
ALL_DCAT_LOCAL_ACCESSIBLE_CATALOGS View
This view lists all accessible catalogs in the current region, along with the level of access privileges for each catalog.
Column | Datatype | Description |
---|---|---|
|
VARCHAR2(4000) |
Catalog OCID |
CATALOG_NAME |
VARCHAR2(4000) |
Name of the catalog |
CATALOG_SCORE |
NUMBER |
The catalog score is a numeric value calculated from the privileges configured for the Data Catalog access credential. A higher catalog score means greater privileges, which may equate to a higher likelihood that this catalog is intended for use with this Autonomous Database instance. |
ALL_DCAT_ASSETS View
The Data Catalog assets that this database is authorized to access.
Column | Datatype | Description |
---|---|---|
|
VARCHAR2(4000) |
Asset key |
DISPLAY_NAME |
VARCHAR2(4000) |
Asset display name |
DESCRIPTION |
VARCHAR2(4000) |
Asset description |
CATALOG_ID |
VARCHAR2(4000) |
OCID for the Data Catalog containing the asset |
EXTERNAL_KEY |
VARCHAR2(4000) |
Base Object Storage URI for the asset |
URI |
VARCHAR2(4000) |
Asset URI for the Data Catalog API |
TIME_CREATED |
TIMESTAMP(6) WITH TIMEZONE |
The date and time the data asset was created |
TYPE_KEY |
VARCHAR2(4000) |
The key of the data asset type (currently, only Object Storage data assets are supported). Type keys can be found via the '/types' Data Catalog endpoint. |
LIFECYCLE_STATE |
VARCHAR2(4000) |
The current state of
the data asset. For more information on possible life cycle states, see
the Data Catalog
DataAsset
Reference for a list of possible states for
lifecycleState .
|
ALL_DCAT_FOLDERS View
Metadata for the Object Storage buckets containing the data files for the Logical Entities.
Column | Datatype | Description |
---|---|---|
|
VARCHAR2(4000) |
Folder key |
|
VARCHAR2(4000) |
Folder display name |
BUSINESS_NAME |
VARCHAR2(4000) |
Folder business name |
DESCRIPTION |
VARCHAR2(4000) |
Folder description |
DATA_ASSET_KEY |
VARCHAR2(4000) |
Key for the data asset containing the folder |
PARENT_FOLDER_KEY |
VARCHAR2(4000) |
Key for the parent folder (currently, this is the data asset key) |
PATH |
VARCHAR2(4000) |
Full path for the folder |
EXTERNAL_KEY |
VARCHAR2(4000) |
Object Storage URI for the bucket |
TIME_EXTERNAL |
TIMESTAMP(6) WITH TIMEZONE |
The last modified timestamp of this folder |
TIME_CREATED |
TIMESTAMP(6) WITH TIMEZONE |
The date/time the folder was created |
URI |
VARCHAR2(4000) |
URI to the folder instance in the Data Catalog API. |
LIFECYCLE_STATE |
VARCHAR2(4000) |
The current state of
the folder. For more information on possible life cycle states, see the
Data Catalog
Folder Reference for a list of
possible states for lifecycleState .
|
ALL_DCAT_ENTITIES View
The Data Catalog logical entities this database is authorized to access.
Column | Datatype | Description |
---|---|---|
|
VARCHAR2(4000) |
Entity key |
DISPLAY_NAME |
VARCHAR2(4000) |
Entity display name |
BUSINESS_NAME |
VARCHAR2(4000) |
Entity business name |
DESCRIPTION |
VARCHAR2(4000) |
Logical entity description |
|
VARCHAR2(4000) |
Asset key |
|
VARCHAR2(4000) |
Folder unique key |
FOLDER_NAME |
VARCHAR2(4000) |
Folder name (bucket) |
EXTERNAL_KEY |
VARCHAR2(4000) |
External key for the logical entity |
PATTERN_KEY |
VARCHAR2(4000) |
Key of the associated pattern for the logical entity |
REALIZED_EXPRESSION |
VARCHAR2(4000) |
The regular expression used to obtain the files for this logical entity |
PATH |
VARCHAR2(4000) |
Full path for the logical entity |
TIME_CREATED |
TIMESTAMP(6) WITH TIME ZONE |
Date and time the entity was created |
TIME_UPDATED |
TIMESTAMP(6) WITH TIME ZONE |
Last time a change was made to the data entity |
UPDATED_BY_ID |
VARCHAR2(4000) |
OCID of the user who updated this object in the Data Catalog |
URI |
VARCHAR2(4000) |
URI of the entity instance in the API |
LIFECYCLE_STATE |
VARCHAR2(4000) |
The current state of
the entity. For more information on possible life cycle states, see the
Data Catalog
Entity Reference for a list of
possible states for lifecycleState .
|
ALL_DCAT_ATTRIBUTES View
The Data Catalog attributes this database is authorized to access.
Column | Datatype | Description |
---|---|---|
|
NUMBER |
Attribute key |
|
VARCHAR2(4000) |
Attribute display name |
BUSINESS_NAME |
VARCHAR2(4000) |
Attribute business name |
DESCRIPTION |
VARCHAR2(4000) |
Attribute description |
DATA_ASSET_KEY |
VARCHAR2(4000) |
Data asset key |
FOLDER_KEY |
VARCHAR2(4000) |
Folder key |
ENTITY_KEY |
VARCHAR2(4000) |
Entity key |
EXTERNAL_KEY |
VARCHAR2(4000) |
Unique external key for the attribute |
LENGTH |
NUMBER |
Maximum allowed length of the attribute value |
PRECISION |
NUMBER |
Precision of the attribute value (usually applies to float data type) |
SCALE |
NUMBER |
Scale of the attribute value (usually applies to float data type) |
IS_NULLABLE |
NUMBER |
Identifies if this attribute can be assigned null values |
URI |
VARCHAR2(4000) |
URI to the attribute instance in the Data Catalog API |
LIFECYCLE_STATE |
VARCHAR2(4000) |
The current state of
the attribute. For more information on possible life cycle states, see
the Data Catalog
Attribute Reference for a list
of possible states for lifecycleState .
|
TIME_CREATED |
TIMESTAMP(6) WITH TIME ZONE |
The date and time the attribute was created |
EXTERNAL_DATA_TYPE |
VARCHAR2(4000) |
Data type of the attribute as defined in the external system |
MIN_COLLECTION_COUNT |
NUMBER |
Minimum number of elements, if the type of the attribute is a collection type |
MAX_COLLECTION_COUNT |
NUMBER |
Maximum number of elements, if the type of the attribute is a collection type |
DATATYPE_ENTITY_KEY |
VARCHAR2(4000) |
Entity key that represents the datatype of this attribute, applicable if this attribute is a complex type |
EXTERNAL_DATATYPE_ENTITY_KEY |
VARCHAR2(4000) |
External entity key that represents the datatype of this attribute, applicable if this attribute is a complex type |
PARENT_ATTRIBUTE_KEY |
VARCHAR2(4000) |
Attribute key that represents the parent attribute of this attribute, applicable if the parent attribute is of complex datatype |
EXTERNAL_PARENT_ATTRIBUTE_KEY |
VARCHAR2(4000) |
External attribute key that represents the parent attribute of this attribute, applicable if the parent attribute is of complex type |
PATH |
VARCHAR2(4000) |
Full path of the attribute |
ALL_DCAT_CONNECTIONS View
A view that contains information about the data catalog(s) connected to this instance.
Column | Datatype | Description |
---|---|---|
|
VARCHAR2(4000) |
OCID for the compartment where the Data Catalog instance resides |
INSTANCE_ID |
VARCHAR2(4000) |
OCID for the Data Catalog instance |
|
VARCHAR2(4000) |
Region for the Data Catalog instance |
ENDPOINT |
VARCHAR2(4000) |
Endpoint for the Data Catalog instance |
CREATED |
TIMESTAMP |
When the Data Catalog instance was created |
NAME |
VARCHAR2(4000) |
Name of the Data Catalog instance |
LAST_UPDATED |
TIMESTAMP |
Timestamp of the last update of the connection to the Data Catalog instance |
LATEST_OPERATION_ID |
NUMBER |
The id of the last synchronization operation |
DATA_CATALOG_CREDENTIAL |
VARCHAR2(128) |
Credential used for accessing the Data Catalog |
OBJECT_STORE_CREDENTIAL |
VARCHAR2(128) |
Credential used by the external table driver for accessing the Object Store |
DCAT_ENTITIES View
Describes the mapping of logical entities to external tables.
Column | Datatype | Description |
---|---|---|
|
VARCHAR2(4000) |
Data Catalog asset key |
|
VARCHAR2(4000) |
Data Catalog entity key |
|
VARCHAR2(4000) |
Data Catalog folder key |
ORACLE_TABLE_NAME |
VARCHAR2(128) |
Mapped table name |
ORACLE_SCHEMA_NAME |
VARCHAR2(128) |
Mapped schema name |
ENTITY_ORACLE_DB_SCHEMA |
VARCHAR2(4000) |
The entity's oracle-db-schema custom property used to derive the schema |
ASSET_ORACLE_DB_SCHEMA |
VARCHAR2(4000) |
The data asset's oracle-db-schema custom property used to derive the schema |
FOLDER_ORACLE_DB_SCHEMA |
VARCHAR2(4000) |
The folder's oracle-db-schema custom property used to derive the schema |
DCAT_ATTRIBUTES View
Lists the mapping of logical entity attributes to external table columns.
Column | Datatype | Description |
---|---|---|
|
VARCHAR2(4000) |
Data Catalog asset key |
|
VARCHAR2(4000) |
Data Catalog entity key |
|
VARCHAR2(4000) |
Data Catalog attribute key |
ORACLE_COLUMN_NAME |
VARCHAR2(128) |
Mapped column name |