[4] The Data Library Page

The Data Library page allows creation and management of reusable data tables outside workbooks. Data tables from the data library can be used by multiple workbooks server wide.

Some important concepts to remember:

A data table contains metadata for data source connection settings, data query, schema definition, calculated columns, transforms, etc.
One data table can use only one data connector to connect to a data source.
Two or more data tables can be joined to create a new joined data table.
Data table permissioning and sharing between users or groups is done similarly like workbooks (i.e., using folder tree).

There are four types of data tables. The first three resides at the Data Library.

Data Table Type	Description
Data Store	Users can opt to store data closer to Panopticon server in an embedded database.
Live	Direct connection to source data.
Joined	Two or more different types of data tables joined together creating a new data table.
Uploaded	Uploaded files through any of the file connectors, that consequently becomes a Data Store, after importing to data store.

The Data Library page is composed of the following sections.

Property	Description
1	Folders List of folders where data tables can be saved, exported, or imported.
2	Folder Context Menu Allows you to: Create a data table and joined data table Assign folder permissions on your workspace Import or export data table bundles Create, rename, or remove folders
3	Search Data Table Entering text will filter data tables which can include: Those that are available in data store Live data tables Joined data tables Extracts
4	Toolbar Allows you to: Display the data tables list either on List View or Grid View Copy or move data tables to other folders Import data table to data store Clear and import data table to data store Clear data table from data store Delete data tables
5	New Legacy Extract Allows accessing data by retrieving only the required results into memory, by querying on demand, pushing aggregation, and filtering tasks to underlying big data repositories, or queryable data extracts.
6	New Joined Data Table Allows you to join data tables created in the data library.
7	New Data Table Allows you to create a data table.
8	List of Data Tables and Data Extracts Data tables and data extracts created in the data library. Specifies if one or several data policies are applied to the data table. Also allows you to create or edit these data policies.
9	Data Table Context Menu Allows you to: Export data table bundles Copy or move data tables to other folders Rename or remove data tables View details of the data table Set the data policy for data tables in the Data Library Convert data extract to data table and import to data store

Intellectual Property Rights Notice | Technical Support