Datatable Properties Dialog: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
Line 4: Line 4:
General tab shows following information:
General tab shows following information:
* '''Description''': Editable description text for the datatable.
* '''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.  
* '''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.
* '''Datatable id''': System assigned numerical id of the datatable.
* '''Row count''': Number of rows in the datatable.
* '''Row count''': Number of rows in the datatable.

Revision as of 00:07, 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 is used to set underlying Snowflake table for the datatable. There are following options:

  • wef
  • wef
  • wef
  • wef

Columns

Columns tab shows a list of all columns in the datatable.