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 |
|---|
| _datasource_show_tables |
|---|
| _datasource_show_tables |
|---|
| nopanel | true |
|---|
|
. 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
| Insert excerpt |
|---|
| _excel_export |
|---|
| _excel_export |
|---|
| nopanel | true |
|---|
|
button.
| Insert excerpt |
|---|
| _property_toolbar |
|---|
| _property_toolbar |
|---|
| nopanel | true |
|---|
|
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
| Insert excerpt |
|---|
| _excel_export |
|---|
| _excel_export |
|---|
| nopanel | true |
|---|
|
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
| Anchor |
|---|
| databaseTableAttributesDetailedList |
|---|
| databaseTableAttributesDetailedList |
|---|
|
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.