Datatable Properties Dialog: Difference between revisions
Line 26: | Line 26: | ||
== Columns == | == Columns == | ||
Columns tab shows a list of all columns in the datatable. | Columns tab shows a list of all columns in the datatable. Following operations can be done: | ||
* Columns can be created. | |||
* Columns can be deleted. Note that when a column is deleted, data in the column is also deleted. | |||
* Column name can be modified. Note that there cannot be duplicate column names. | |||
* Key columns can be defined. Datatable has an optional key, consiting of one or many columns. Defining a key gives a hint to analytics queries which combination of columns uniquely identifies rows in the datatable. | |||
* Columns can be reordered with drag-and-drop using the handle in the left side of the row. | |||
Note that column data type can only be set when the column is created, and the column data type cannot be modified afterwards. The reason is that changing the data type would also require to convert the data in the column. Column datatype can be changed by creating a new column, converting the data and deleting the original column. |
Revision as of 00:24, 2 November 2023
Datatable Properties Dialog is for viewing and modifying datatable properties.
General
General tab shows following information:
- Description: Editable description text for the datatable.
- Source object type: Either Table or View. QPR ProcessAnalyzer is able to create and modify database table, but view is not modified by QPR ProcessAnalyzer. The database table is also deleted when the datatable is deleted only when using the default table. If desired to use datatablel view for the datatable, the view needs to be created to the data source (e.g., Snowflake).
- Datatable id: System assigned numerical id of the datatable.
- Row count: Number of rows in the datatable.
- Column count: Number of columns in the datatable.
- Last imported: Timestamp when the data was last time imported to the datatable.
- Last imported by: User who last time imported data to the datatable.
- Settings changed: Timestamp when the datatable settings was last time modified.
- Settings changed by: User who last time modified the datatable settings.
- Created: Timestamp when the datatable was created.
- Created by: User who created the datatable.
- Used by models: List models which are using this datatable. Also the role (cases or events) is mentioned.
Data location
Data Location tab configures the underlying Snowflake table or view for the datatable. There are following options:
- Default table: Use the system assigned table. The table name has the following format: qprpa_dt_<databaseid>_<datatableid>. The databaseid can be configured in the system settings.
- Custom table: Use user-defined table which is located in the default database and schema (defined in the Snowflake connection string configured to the system). When this setting is enabled, the table name needs to be defined.
- Custom schema: Use user-defined table and schema which is located in the default database. When this setting is enabled, the table and schema name needs to be defined.
- Custom database: Use user-defined table, schema and database. When this setting is enabled, the table, schema and database name needs to be defined.
When desired to use database view for the datatable, create the view to Snowflake and configure the view name in the datatable settings. When using a view, data cannot be imported to it and columns cannot be modified.
Columns
Columns tab shows a list of all columns in the datatable. Following operations can be done:
- Columns can be created.
- Columns can be deleted. Note that when a column is deleted, data in the column is also deleted.
- Column name can be modified. Note that there cannot be duplicate column names.
- Key columns can be defined. Datatable has an optional key, consiting of one or many columns. Defining a key gives a hint to analytics queries which combination of columns uniquely identifies rows in the datatable.
- Columns can be reordered with drag-and-drop using the handle in the left side of the row.
Note that column data type can only be set when the column is created, and the column data type cannot be modified afterwards. The reason is that changing the data type would also require to convert the data in the column. Column datatype can be changed by creating a new column, converting the data and deleting the original column.