Viewing Entity Details

To view details about an entity, click the Action Actions icon at the right of the entity entry, then click View Details.

For all entities, the details include Lineage and Impact sections. The inclusion of other details, such as Preview and Statistics, varies by entity type.

Preview

Preview displays the data of the entity. For a table, the Preview displays the columns of the table and the data in those columns. You can sort the data in the column into ascending or descending order by clicking the up or down arrow to the right of the column name.

Describe

For an analytic view, the Describe tab has information about the entity, and displays the hierarchies, levels, level depth, dimension tables, level columns, and number of distinct values for a level.

Lineage

Lineage displays all known information about the upstream dependencies of the entity, and therefore how the entity was created and how it is linked to other entities.

For example, for a table that you created in your database, the lineage is just the table. For a table that you created by loading a CSV file from cloud storage, the lineage includes the ingest directive for the data load and the CSV file that is the source of the data.

Pointing to the name of an item in the lineage displays the table name, the application that created it, the type of entity, the path to it, and the schema it is in.

Arrows point from an entity to the entity that it derives from. For example, for a table created in a data load job, an arrow points from the table to the ingest job and an arrow points from the ingest job to the CSV file. If you point to an arrow, then a Links Information box appears that shows information about the relationship between the two entities.

To view more details about an item, click the Actions icon for the item, then click Expand. For a table, the columns of the table are displayed. Pointing to the name of the table or of a column displays the name, application, type, path, and schema of the table or column. To collapse the display, click the Actions icon, then click Collapse.

You can increase or decrease the size of the displayed objects by using the + (plus) and - (minus) keys. You can reposition the objects by grabbing a blank spot in the display and dragging vertically or horizontally.

The lineage for some entities, such as analytic views, is more complex. An analytic view entity deployed for a business model has links to columns in a fact table and to hierarchies. The fact table has links to attribute dimensions and, for a data load job, to an ingest directive for the job. The ingest directive has a link to the source file. The attribute dimensions have links to tables for the dimensions. Those tables have links to ingest directives that have link to source files.

Impact

Impact shows all known information about the downstream use of an entity, and therefore how a change in the definition of an entity may affect other entities that depend on it. For example, if a table is used in an analytic view, a change to one of the column definitions in the table may affect the mapping from that column to the analytic view.

Classifications

For an analytic view and its attribute dimensions, hierarchies, and measures, the Classifications tab displays classifications and their values. Classifications are metadata that applications can use to present information about analytic views. When creating a business model, you may specify the values for the Caption and Description classifications.

Optimize

For an analytic view, the Optimize tab has information about caches created for the analytic view. A cache may exist if the advanced option Enable Autonomous Aggregate Cache was selected for the business model for which the analytic view is deployed.

Statistics

Statistics display information about the entity. For example, the statistics for a table include the size of the table and the numbers of rows and columns. They also include the names of the columns, their data types, the number of distinct values and null values, the maximum and minimum values, and other information.

The data is represented in the form of histogram which is column statistic which provides more detailed information about data distribution in a table's columns.

The histograms in the statistics pane can be representative of the following types:
  • Frequency: In a frequency histogram, each distinct column value corresponds to a single bucket of the histogram. Since each value has its own dedicated bucket, some buckets may have many values, whereas others have few.
  • Top-frequency: A top frequency histogram is a variation on a frequency histogram that ignores non-popular values that are statistically insignificant
  • Height-Balanced: In this histogram, column values are divided into buckets so that each bucket contains approximately the same number of rows.
  • Hybrid: A hybrid histogram combines characteristics of both height-based histograms and frequency histograms. This approach enables the optimizer to obtain better selectivity estimates in some situations.

Refer to Gathering Statistics for Tables section for more details.

Job Report

Displays a report of the total rows loaded and failed for a specific table.

The report displays of the total rows loaded and failed.

You can view the name of the table, the time the table was loaded and the time taken to process the load.

Data Definition

Data Definition displays the Oracle Autonomous Database DDL that created the entity.

You can view the following Entity Types from the drop-down:
  • All
  • Table
  • View
  • Analytic View
  • Table,View,Analytic View
  • Analytic Dashboard
  • Attribute (Attribute Dimension)
  • Attribute (Hierarchy)
  • Attribute Dimension
  • Cloud Link (Cloud Link Namespace)
  • Cloud Link Namespace
  • Cloud Object (Cloud Storage Link)
  • Cloud Object (Data Catalog Asset)
  • Cloud Object (Share Link)
  • Cloud Storage Link
  • Cloud Virtual Object (Cloud Storage Link)
  • Column (Table)
  • Column (View)
  • Data Catalog Asset
  • Data Catalog Link
  • Database Link
  • Directory
  • External Location
  • File (Directory)
  • Function
  • Hierarchy
  • Ingest Job
  • Level (Attribute Dimension)
  • Level (Hierarchy)
  • Live Table Feed
  • Measure (Analytic View)
  • Mining Model
  • Package
  • Procedure
  • Schema
  • Share
  • Share Link
  • Share Provider
  • Share Recipient
  • Share Schema (Share)
  • Share Table (Share Schema)

Click the Actions icon next to Table entity to perform the following operations:

  • Select View Details to view details about the table.
  • Select Gather Statistics to display new statistics after you modify the table‚Äôs structure. Refer to the Gathering Statistics for Tables for more detailed information.
  • Select Register to Cloud Link to register the table for remote access for a selected audience you define. See Registering Cloud Links to Access Data section for more information.
  • Select Create Analytic View to create an Analytic View from the selected associated table. See Creating Analytic Views
  • Select Export Data to Cloud to export data to a cloud object store.
  • Select Edit to edit the properties of the table. Refer to Editing Tables for more information.
  • Select Drop to delete the table.

Click the Actions icon next to the Share entity to view the share entity details.

Click the Actions icon next to the Share Provider entity to view the share provider entity details.

Click the Actions icon next to the Share Recipient entity to view the share recipient entity details.

Click the Actions icon next to Cloud Storage Link entity to perform the following operations:

  • Select View Details to view details about the table.
  • Select Objects to view objects available in the selected storage link. You can click a file on the navigator pane to view it on the display area.
  • Selecting Link Tables opens the Link Data page on the Data Load tool with the selected cloud storage link on the Cloud Location URL field. You can link data present in the cloud storage to the Autonomous Database. See Linking to Objects in Cloud Storage.
  • Selecting Load Tables opens the Load Data page on the Data Load tool with the selected cloud storage link on the Cloud Location URL field. You can load data present in the cloud storage to the Autonomous Database. See Loading Data from Cloud Storage.
  • Selecting Create Live Table Feed opens the Create Live Table feed wizard with he selected cloud storage link on the Cloud Location URL field. See Feeding Data to view more details.
  • Select Edit to update any details on the cloud storage location. See Managing Connections to view details on creation of cloud storage location.
  • Select Rename to rename the cloud store location to a different name.
  • Select Delete to delete the cloud store location.