FAQs about Data Sources

  • Add multiple schemas per data source connection
    Chartio offers multiple schema support so you can reflect data from different schemas in your data source.
  • Amazon S3 CSV integration
    Although you can connect CSVs to Chartio directly, you may also first upload a CSV to Amazon Redshift. This can be done by uploading the CSV to Amazon S3.
  • Change a column's data type
    To use a column in a different data type than your schema, use custom columns to change the column's data type.
  • Create team views for data source connections
    You can change the settings of a data source to personalize the Chartio view and features available to a certain team.
  • Data Source FAQs
    Some common questions about Data Sources in Chartio - renaming, settings, etc.
  • Data source swaps and migrations
    Chartio can perform data source swaps for charts, dashboards, and data stores from the backend, but beforehand you need to confirm table and field names.
  • Filter data based on the viewer
    Implement row level permissions in Chartio when embedding dashboards and when sharing dashboards internally.
  • Foreign keys explained
    Foreign keys between two tables tell Chartio how to join the tables together.
  • Google Analytics tips & tricks
    Some issues that users have with Google Analytics are common. In this help page we show some of these common issues and how to deal with them.
  • How data source time zones work
    If you specify a timezone for a database, then the database performs all math internally without requiring UTC offset.
  • Import data from an unsupported data source
    If you would like to import data from a data source not currently supported by Chartio, export your data as a CSV, which can then be uploaded to Chartio.
  • Import your data using Stitch and Panoply
    Step-by-step instructions on connecting your cloud applications and databases to Chartio using Stitch and Panoply.
  • Join data across databases
    To query data across multiple data sources, create Datasets for each data source, and merge the Datasets with a join.
  • Join data across tables
    Bring in data from various tables within your Data Source by setting up Foreign Keys. Join paths will automatically be generated but can also be adjusted.
  • Redshift Driver Update FAQ
    Chartio is updating to the latest Redshift driver on February 13, 2020. This will help improve performance and may need an update to user permissions.
  • Repurpose Custom Columns
    Create Custom Columns to standardize calculations and remove the possibility of differing metric definitions.
  • Restart the tunnel connection client
    Restart the tunnel connection client by logging into the database server and running commands to start the Chartio client.
  • Restricted commands in SQL Mode
    To prevent malicious queries and use of your data, Chartio blocks certain commands in SQL Mode.
  • Search charts by table query usage
    In Chartio, you can search what charts query certain tables by downloading the query log as a CSV file and then re-uploading that CSV as a data source.
  • Select encoding type for CSV export in Excel
    Excel may not recognize the UTF-8 encoding Chartio uses if your data contains special characters so you may need to manually specify the encoding.
  • Upload a CSV file
    To upload a CSV file to Chartio, you will need to make sure it is properly formatted.