Create a custom table

Custom tables can be especially useful for flattening two tables.

Start by navigating to your database schema, and click Add custom table at the top of the schema page.

Click Add custom table to add a table to a database

Name your table, and add your SQL. In our example, we’re joining three tables to get a rollup of User information. Click Add table when finished.

SQL example

Chartio will evaluate your SQL and will display any error messages in the schema viewer.