Adding an External Table Source
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.By default, StreamLab uses the project schema for the new source. You can also select a schema from the pulldown menu on the left.
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.