Data Table Detail

In Arcadia Enterprise, you can preview table details directly in the Connection Explorer interface.

To see more information about data tables in the Connection Explorer, follow these steps:

  1. Click on a table row to see more information about each table. Here, click on table census_pop
  2. Below the list of tables, a new Sample Data tab appears. It is a preview of data stored in census_pop.

    exploring table data in connection explorer
    Previewing Data Tables in the Connection Explorer
  3. [For Arcadia connections only]

    Click the Table Statistics tab, and note the information reported for the table: #Rows, #Files, Size, Bytes Cached, Cache Replication, Format, Incremental stats, and Location of the table.

    exploring table data in connection explorer
    Table Statistics in the Connection Explorer
  4. [For Arcadia connections only]

    Click the Column Statistics tab, and note the information reported for data characteristics in the table: Column, Type, #Distinct Values, Max Size, and Avg Size.

    exploring column statistics
    Column Statistics in the Connection Explorer
  5. Click the Datasets tab, and note the information reported for datasets based on this table: Title/Table, Created date, Last Updated date, Modified by username, and # Visuals for a link to the dashboards and visuals based on the dataset.

    Notice that you can also perform the following actions:

    1. Navigate directly to the information page of a specific dataset.
    2. Start new dashboards and new visuals based on each of the reported datasets.
    3. Order datasets based on any of the table columns.
    4. Delete datasets.
    exploring datasets information
    Datasets Information in the Connection Explorer