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, click on the row of each table, and then select the distinct tabs. Here, click on table census_pop.

The information tabs include the following:

Sample Data

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

Table Statistics

[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

Column Statistics

[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

Datasets

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 dataset interface, where you can rename the dataset, modify fields and other parameters, create joins, and so on.
  2. Start a new dashboards based on the dataset.
  3. Order datasets based on any of the table columns.
  4. Delete datasets.
exploring datasets information
Datasets Information in the Connection Explorer