Version you are viewing: Zoomdata v4

Zoomdata v5

Zoomdata v3

Tables/Indices Tab

Use the Tables or Indices tab in the data source configuration wizard to select the data table you want to use for this data source configuration. The name of this tab varies, depending on the data source you select.

You must be logged in as an administrator or as a user with the group privilege Can Create new Data Sources to see the Tables/Indices tab of the data source configuration wizard.

The structure and options on this tab vary by data source. The following general structure is used:

  • In the left column of the tab, select a schema, index, table, or collection to use for the data source configuration. In some cases, you can select All to select all schemas for the configuration.
  • In the upper half of the right column, a Field table shows you the fields you can select from the schema, index, table, or collection that should be used for the configuration.
  • In the lower half of the right column, the Preview section shows a preview of the first ten records in the data you have selected.

Different options appear on this tab for different data sources types. The options include the following, but may not be available for every data source:

  • Custom SQL — If you want to use specific fields from the table, you can write an SQL query to select them. If you select this option, the Field table in the upper half of the right column becomes an editing pane that you can use to write the SQL query.

  • Caching — Use this switch to indicate whether Zoomdata should cache the aggregated results of queries from this source. See How Zoomdata Caches Data.

  • Lookup Values — If you are using Solr, Cloudera Search, or Elasticsearch data sources, you can use this switch to refresh the distinct values in the metadata store. Otherwise, the data source is queried directly each time.

  • Enable Filter by Type — For Elasticsearch data sources, you can select this checkbox to filter the available indices by type. When you select this checkbox,

  • Request Handler — For Cloudera Search and Solr data sources, you can use this box at the top of the Field table to specify a request handler plug-in that defines the logic used when executing a search request.

Click to proceed to the Fields Tab in the data source configuration wizard. Click to return to the previous tab (either the Connection Tab or the General Tab, depending on the privileges assigned to your user account).