Chartio is a great resource to bring all your disparate data sources together into one place allowing you to gain insights across your many sources.
These sources may be many different types of databases. The great thing about Chartio is that you can connect datasets from different types of databases on the same chart using our Datasets. Add a dataset for each separate query you want to include in your chart.
If you’re writing SQL against your data source using our SQL editor, Chartio will detect what database type you are using and accept the SQL syntax appropriate to that data source.
For example, if you are querying a PostgreSQL database, then the syntax used in SQL mode would be PostgreSQL. The same would be true for MySQL, Google Analytics, etc. When querying against a data store or CSV, these would use PostgreSQL syntax.
Google Sheets uses its own somewhat unique SQL syntax in Chartio based on the driver we’re using: http://cdn.cdata.com/help/RLC/jdbc/pg_select.htm. There are a couple of things to note regarding the syntax for Google Sheets as well:
- Use Oracle’s syntax for date formatting using the FORMAT() function.
- Strings must be quoted using single quotes (e.g., ‘John Doe’).
When creating a dropdown or date slider, you would also use the syntax that the original database is in.
If you are using our Interactive Mode, you don’t need to worry about the data source type, Chartio will automatically detect the appropriate type for you.
In the pipeline, the syntax is SQLite regardless of the type of the original datasource. If creating custom formulas in a pipeline step such as Add Column, the syntax will be SQLite.
In the example above, a new column is created by modifying the existing MRR column to create an Annualized Revenue column that is cast as an Integer for this chart.