Managing Tables and Columns
After you have imported your data into Sisense, it’s time to shape it into a data model that can support your dashboard and provide accurate information to your Viewers.
You can modify your data on two levels: the Table level and the Column level.
Any changes you make to your schema are reflected in the ElastiCube only and do not affect the data in your data source.
For a short video overview of managing the tables and columns in your data model, see below:
You can manage tables imported into the ElastiCube through the Navigation Pane or through the table itself in the schema.
The table below describes the menu options available from the Navigation Pane and the corresponding icons available in the table’s menu. Either method allows you to modify and manage your tables.
|Navigation Pane||Table Icon||Description|
|Preview & Edit||Displays a preview of your table’s data. See Previewing your Data for more information.|
|Relationships||>||Displays related tables together side by side. See Creating Relationships for more information.|
|Rename||>||Allows you to rename the table.|
|Duplicate||>||Allows you to duplicate the table.|
|Refresh Schema||>||Allows you to update a table’s columns if there was a change on the data source without having to add the table again.|
|Tags & Description||>||Allows you to tag a table with metadata that you can use to organize your data and search for it later. See Tagging Your Data for more information.|
|Hide||>||Allows you to hide a table. Hidden tables are not seen by Dashboard Viewers, but might be used for custom calculations. Hidden tables are built with the rest of the ElastiCube.|
|Add Custom Column||>||Allows you to add a custom column to the ElastiCube. See Adding Custom Columns for more information.|
|Build Behavior||>||Allows you to define the build behavior for a specific table. See Build Settings and Data Accumulation Behavior for more information.|
|Delete||>||Allows you to delete a table.|
|--||By default, tables are pinned when you import your data. You can click this icon to unpin your tables so your tables are organized by Sisense around other pinned tables.|
To view your table’s meta, including its name, path, provider, location, and the number of columns it contains, hover over the table in the schema or in the Navigation Pane.
You can manage tables imported into the ElastiCube through the Navigation Pane. Columns that are part of a table are displayed below the table. On the left side of the column is an icon that indicates what type of data is in the column, Numeric, Date, or Text. You can click this icon to convert the column into another data type.
On the right side of the column’s name is an icon that indicates if the column is conducted to another column through a relationship. You can hover over the icon to view more details or disconnect the relationship.
For each column, you can hover over its name to display a menu from where you view the following options for managing your columns:
|Relationships||Displays related columns together side by side. See Creating Relationships for more information.|
|Edit Relationship||Allows you to edit a column’s relationship. This option is only available when the column is connected to another table.|
|Rename||Allows you to rename the column.|
|Duplicate||Allows you to duplicates the column in the table. This is useful if you need the same column with some modifications.|
|Hide||Allows you to hide a column. Click this option if you want to import the data associated with this column, but do not want this column available to dashboard designers and viewers.|
|Indexed||Allows you to index the column data for quicker processing in subsequent builds.|
|Drop||Allows you to remove column from the table.
After dropping a column, you can view all your dropped columns by previewing the table. In Preview mode, you can restore the column by opening the column's menu and clicking Restore.
|Change Data Type||Allows you to change the data type of your column in the ElastiCube. This does not change the column type in the original data source.|
|Description||Allows you to tag a column with metadata that you can use to organize your data and search for it later. See Tagging Your Data for more information.|
|Is Accumulated by||Allows you to enable accumulative behavior for date and integer fields in tables imported by the JDBC connector. See Enabling Accumulative Build for JDBC Connector for more information.|