Versions Compared

Version Old Version 1 New Version Current
Changes made by

Former user

Zoe Baldwin

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Forms: Table

A Table is a reference to an external database table object.

Form: Table Details List

There are two forms of the Table list:

  • Detailed list - Shows the table name plus other (database specific) details
  • Simple list - Just shows the table names

In both cases the lists show all the tables for the parent Datasource that the user defined in the Datasource Instance has permission to view.

The list below gives the column headers returned for an Oracle database.

...

Insert excerpt
_Banners
_Banners
nameanalysis
nopaneltrue

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
nopaneltrue
. 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
nopaneltrue
 button.

Insert excerpt
_property_toolbar
_property_toolbar
nopaneltrue

Detailed Table List

In the detailed table list, the following fields are shown for each table:

FieldDescription
OwnerThe table owner
NameThe name of the table

...

...

Tablespace Name

...

That tablespace this table is contained in
RowsApproximate 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

The following actions are possible from a Table list:

  • Double clicking on a Table entry pops up a Data Grid showing the first page of data returned from the table.
  • Dragging a table and dropping it on a modelling pane creates a Database Collector which is linked to the original Datasource. The Collector will be set up to fetch all the table fields and all the table data.
  • From the right-click context menu you can choose to view the table attributes (a simple or detailed list). See Table Attributes.

See Also

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
    nopaneltrue
     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
list
list
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:

FieldDescription
TABLENAMEThe name of the table.
COLUMNIDThe internal id for the column.
COLUMNNAMEThe name of the attribute
DATATYPEThe data type.
CHARLENGTHFor character types, the column length in characters (not necessarily the same as the length in bytes depending on character sets).
DATAPRECISIONFor numeric types, the data precision.
DATASCALEFor numeric types, the data scale.
NULLABLEWhether or not the column allows null values.
DEFAULTLENGTHThe 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
spaceKey@self
additionalnone
placeholderSearch all help pages
typepage

Panel
borderColor#00374F
titleColorwhite
titleBGColor#00374F
borderStylesolid
titleSections on this page

Table of Contents
maxLevel3
indent12px
stylenone

Learn More

For links to all pages in this topic, see Analysis Models for Batch Processing Data.

Insert excerpt
_terms_changing
_terms_changing
nopaneltrue