Data Schema Editor

When Chartio connects to your database, it automatically extracts your database schema and organizes it into a dropdown list of tables and columns. For more detail on the chart creation page, please visit here. In addition to pulling in this data, Chartio intelligently sorts your data into measures and dimensions (a quick explanation of this difference is available here). Our tool gives you powerful control over your data schema through the "Edit Schema" page. To find the edit schema, visit the settings page, which is visible in the right half of the top navigation bar. The setting page looks like this.

The arrow above points to the edit schema link. Once you click, you'll be taken to the edit schema page in all its glory.

As shown in the above image, this page lets you visualize your tables and gives you the power to:

  1. Determine which tables are displayed in the chart creation page. Simply uncheck the "display" checkbox to stop displaying the particular table.

  2. Within the tables on the chart creation page, you have granular control of which columns appear. Like tables, simply uncheck the "display" checkbox to prevent their display.

You can also edit the table and column name aliases. Note: SQL names cannot be changed as they mirror the actual table and column names in your schema. To edit, simply double click on the alias and a text box will appear.

In addition, Chartio automatically sorts your data into three data types:

  1. Number - This represents either type int or float (e.g., 50 or 3.2). It is represented by the "graph" icon.
  2. Text -This represents text in your database and is represented by a chat bubble.
  3. Date - This refers to datetime types in your database and is represented by a clock.

For example, if your database stores timestamps in UNIX time, you will need to convert those types to DATETIME columns, by switching the "Number" icon (as represented by the graph) to the "Date" icon, as represented by the clock.

To edit these data types, simply click on the pulldown, as pictured below.

Finally, you can re-organize the way Chartio displays your columns in the chart creation page by switching columns between "measures" and "dimensions" (more on measures and dimensions). Again, you simply have to click on the pulldown to make the switch.