Apama 10.11.3 | Building and Using Apama Dashboards | Building Dashboard Clients | Attaching Dashboards to Correlator Data | Dashboard data tables | SQL-based instance table
 
SQL-based instance table
An SQL-based data table is a special data table designed to ease implementation of complex filtering and improve performance for dashboards that must handle a large number of DataView items. It contains the current values of all fields for all items of a single DataView definition.
A separate table exists for each DataView definition. Within a table, a row exists for each item of the DataView definition. The columns of the table correspond to the fields of the DataView.
See Using SQL-based instance tables for more information on using SQL-based instance tables.
When you specify a data attachment, this kind of table is available only if you started Builder with the -Y or --enhancedQuery command-line option.
Important:
When SQL-based data tables are in use for deployed dashboards, authorization for DataView items does not use scenario authorities (see Administering Dashboard Security). By default, all users have access to all instances or items. Authorization must be built into attachment queries. See Using SQL-based instance tables for more information.