Versions Compared
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 | ||||||
|---|---|---|---|---|---|---|
|
...
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
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
Detailed Table List
In the detailed table list, the following fields are shown for each table:
HELPDEVTODO: confirm this in the new gui
| 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. |
Table actions
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. |
...
The following actions are possible from a table attribute list:
HELPDEVTODO: this currently not working in new gui
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.
...
See Also
...
| Live Search | ||||||||
|---|---|---|---|---|---|---|---|---|
|
| Panel | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
|
Learn More
For links to all pages in this topic, see Analysis Models for Batch Processing Data.
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|