How do I create a Table using Custom SQL?

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. Create your Table.

  1. Name of the Table (Max length is 44 characters and can not include a back tick [ ` ])
  2. Enter a description for your table, this can be left blank.
  3. Select the folder where the table will live.
  4. Select Custom SQL from the table type drop down.
  5. Select Next.
Create your Table.

7. Create the SQL for the table.

1) Choose a table that the basis of the SQL table will be built off of.

2) This is where the SQL statement will be written.  You can modify as needed or skip step 1 and write your own.

3) Save

Create the SQL for the table.

8. Congratulations, the table has been saved!

Congratulations, the table has been saved!