Datatable Properties Dialog

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.