Versions Compared
Version | Old Version 20 | New Version 21 |
---|---|---|
Changes made by | ||
Saved on |
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Insert excerpt | ||||||||
---|---|---|---|---|---|---|---|---|
|
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
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
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
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
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
button; see Download CSV or Excel Data.Insert excerpt _excel_export _excel_export nopanel true 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
Anchor | ||||
---|---|---|---|---|
|
Anchor | ||||
---|---|---|---|---|
|
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.
Live Search | ||||||||
---|---|---|---|---|---|---|---|---|
|
Panel | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
|
Learn More
For links to all pages in this topic, see Analysis Models for Batch Processing Data.
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|