Schema

Admin permissions are required to edit a data sources’s schema.

When Chartio connects to your database, it automatically extracts your database schema. Chartio provides an editor for that schema we import, which allows you to perform the following actions:

  • Rename certain columns to make them more reader friendly
  • Hide tables and columns to simplify your data source for users
  • Add foreign keys if needed, and set custom join types
  • Change dimension and measure groupings
  • Create custom columns or tables
  • Set default aggregations for measures
  • Delete columns and tables (from your Chartio schema, not your actual database)