Documentation and SupportV5 User Manual Creating Tables Using ConnectorsHow do I create a table using a PostgresSQL Connector?

How do I create a table using a PostgresSQL Connector?

1. Navigate to the Table(s) Tools.

If you have already created a table, the Table(s) icon will be available.

Navigate to the Table(s) Tools.

2. Click the 'Add New' bubble.

Click the 'Add New' bubble.

3. If this is your first table, you must navigate to the System Tools.

If this is your first table, you must navigate to the System Tools.

4. Navigate to the Table System Tools.

Navigate to the Table System Tools.

5. Click the 'Add New' bubble.

6. Enter the Table Data.

Enter the Table Data.

6.1. Name

Name of the Table (Max length is 44 characters and can not include a back tick [ ` ])

6.2. Description

Any information to help identify the use of this table can be typed here.

6.3. Folder

The folder the table will be under. You can use the [+] button to add a new folder.

6.4. Type

What type of table this will be. For Streak, you'll want to choose 'From Connection'.

7. Enter the Schedule Details and choose a Table.

Enter the Schedule Details and choose a Table.

7.1. Connection

The connection used to create the table. We'll pick the PostgresSQL Connection we created earlier.

7.2. Table Update Frequency

How often the table will pull new data. An option of 'Once' runs only the first time.

7.3. Table

Select the Table you want to import.

8. Select which fields you would like to import.

Select which fields you would like to import.

9. Select any fiter you wish to add.

Select any fiter you wish to add.

10. Make any adjustments to the select statement and hit save.

Make any adjustments to the select statement and hit save.