Adding an External Table Source

<< Click to Display Table of Contents >>

Navigation:  Using StreamLab > StreamLab Sources Overview >

Adding an External Table Source

Previous pageReturn to chapter overviewNext page

External tables are database tables in an external source, such as tables in a PostgreSQL database. Before you can add an external table as a source, you first need to create an external connection with the database. See the topic StreamLab External Connections Overview for more details.

1.On the Sources page, drag an External Table source from the left column into the center area.
2.Click the new External Table source.

The Edit External Table Source page opens.

3.Select a schema from the pulldown menu on the left.

sl_add_stream_source_sel_schema

4.Select a stream from the pulldown menu on the right. This is the stream into which lines from the external table source will be read.
5.Select an External Connection, such as a PostgreSQL_DB.
6.Enter the database schema for the external table. (That is, the PostgreSQL schema.)
7.Enter the name of the external table (That is, the PostgreSQL table name.)
8.Next, enter columns for the table. Column names need to match those in the external database. You can also click the Discover Columns button to add columns automatically. Note that you can also using the Paste option for column Lists.
9.Test the source by clicking the Sample 5 Rows from Source button.
10.Click the Go Up arrow to exit the Edit Source page.

    sl_go_up_arrow

11.To parse the newly added source, add a guide using the newly added Line source.