Dataset Detail

To determine the detailed information of a particular dataset, you can examine the details of the dataset.

You can examine the details of the dataset by following these steps:

  1. Clicking Data on the main navigation bar.
  2. Find the dataset, either by browsing to a known connection and scrolling, or by using Search.
  3. Click the dataset you want to examine.

  4. Dataset side navigation appears, open at Dataset Detail view. Depending on the dataset definition approach, there are two alternatives:

    • Defined on Table
    • Defined on SQL

Note the following information available on Dataset Detail view, under Detail:

Table

This is the qualified name of the data source. Note that it appears in the form DatabaseName.DatabaseTable.

Connection Type

This is the name of the database that hosts the data. Note that it appears in the form DataConnection.

This feature is ideal for enterprise environments, with dashboards developed on test clusters, and then deployed to a production environment. Note that this assumes that the new connection has, at the minimum, the relevant base tables with metadata definitions that match those on the original connection.

Users with appropriate permissions can switch the data connection of a dataset by following these steps.

  1. Click the (edit/pencil) icon.
  2. Choose a different data connection from the menu.
  3. Click Save.

Description

This is an optional field; you may edit it here.

  1. Click the (edit/pencil) icon.
  2. Enter the descirption in the text box.
  3. Click Save.

Associated Logical View

These are available only on Arcadia connections.

A logical view enables you to model a dataset that is comprised of joined tables. This allows 3rd-party application to access complex datasets in the same manner they can access simple tables.

To create a new logical view and associate it with the dataset, follow these steps:

  1. Click the (edit/pencil) icon.
  2. Select the name of the database in the connection, if you want to change it.
  3. Enter the name of the associated view in the text box.
  4. Click Save.

Note that the Analytical View Builder uses both logical views and tables to define analytical views.

Join Elimination

Join elimination improves query execution and visual rendering in Arcadia Data.

Join elimination is available both for left outer and inner joins. It is turned on by default.

Tip.

Before Arcadia Instant Release 4.5.0.0, join elimination worked only for left outer joins. To restore that behavior, edit the settings.py file by adding the following paramter:

JOIN_CULL_LIST = 'left outer join'

When a visual uses fields and expressions that reference only a subset of the joined tables that form the dataset, this feature eliminates the unnecessary joins and access only the necessary subset of the joined tables. This improves query execution speeds, and renders the visuals faster.

  1. Click the (edit/pencil) icon.
  2. Disabling: choose the Disabled option.

    Enabling: choose the Enabled option.

  3. Click Save.

Result Cache

Each dataset inherits the result caching preferences configured for its connection; the value for this field is From Connection by defaut.

However, this may be changed at the level of the dataset:

  1. Click the (edit/pencil) icon.
  2. Disabling: choose the Disabled option.

    Enabling: choose the Enabled option, and specify the Retention Time, in seconds.

  3. Click Save.

To clear the result cache, click the (clear) icon.

Incremental Results

The fetching of incremental results is either disabled (default behavior), or enabled.

  1. Click the (edit/pencil) icon.
  2. Disabling: choose the Disabled option.

    Enabling: choose the Enabled option.

  3. Click Save.

SQL

In datasets initially defined on a SQL Query, you can alter the query at any time to change the list of fields fetched, content of the WHERE clause, ORDER BY, and so on.

  1. Click the (edit/pencil) icon.
  2. Edit the SQL statement.

  3. Click Save.

Information on Creation and Update

The Dataset Detail interface provides information about the creation of the dataset and most recent updates to it:

Created on
This is the date, in timestamp form, when the dataset was created.
Created by
This is the username of the user who created the dataset.
Last updated
This is the date, in timestamp form, of the most recent dataset update.
Last updated by
This is the username of the user who updated the dataset most recently.