Database Table
- Former user (Deleted)
- Anthony George
- Chris Welford
- Fiona Sargeant (Unlicensed)
This page is for data modellers who want to configure a database table.
Overview
From a PhixFlow datasource, you can open a window listing the tables in that database. For example, in the datasource properties tab, in the toolbar click onĀ Ā Show Tables. The list shows the tables that theĀ users defined in the datasource instances have permission to view. For each table, you can display:
- the data in the table
- a list of the attributes defined in that table
Depending on where you open the table list from, it will be either a simple list with only the name of each table, or a detailed list.
The database tables list has a toolbar withĀ common buttons. You can export data from a detailed list using theĀ Download data to fileĀ button.
For information about the toolbar options, see the Common Properties page, Toolbars and Controls section.Property Pane Toolbar
Detailed Table List
In the detailed table list, the following fields are shown for each table:
Field | Description |
---|---|
Owner | The table owner |
Name | The name of the table |
Tablespace Name | That tablespace this table is contained in |
Rows | Approximate number of rows in this table. Note that this information is based on stats collected by the database, and in some cases may not be fully up-to-date. |
You can do the following things:
- To show data in table, double-click on the table.
- To display a simple list of the table attributes, right-click to display the context menu and select Show Table Attributes.
- To display a detailed list of attributes, right-click and select Show Attribute Details; seeĀ Table Attribute Details below.
- To export data from a table, use theĀ Download data to fileĀ button; seeĀ Download CSV or Excel Data.
- To create a collector for the table:Ā
- either drag the table onto a model view
- or right-click and select Create a Collector.
Table Attribute DetailsĀ
Depending on how you display them, database table attributes may be
- either in a simple list, with only the name of each attribute
- or inĀ detailed list.
In the detailed list, the following fields are shown for each attribute:
Field | Description |
---|---|
TABLENAME | The name of the table. |
COLUMNID | The internal id for the column. |
COLUMNNAME | The name of the attribute |
DATATYPE | The data type. |
CHARLENGTH | For character types, the column length in characters (not necessarily the same as the length in bytes depending on character sets). |
DATAPRECISION | For numeric types, the data precision. |
DATASCALE | For numeric types, the data scale. |
NULLABLE | Whether or not the column allows null values. |
DEFAULTLENGTH | The default length of the column. |
You can select several attributes and drag them onto a model window. PhixFlow creates a database collector to read the selected fields from that table.
Learn More
For links to all pages in this topic, seeĀ Analysis Models for Batch Processing Data.
Terminology changes in progress As part of the redesign of PhixFlow, we are changing the following terms: dashboard → screen
stream → table
stream attributes → attributes
stream item → record
stream set → recordset
stream view → view
stream item action → record-action
stream action → table-action
driver class → database driver