Documentation

SQL Box Overview

With datapine’s SQL Query Box it is easy to build dynamic charts and graphs from statements you might have already used to generate your daily reports. You can thereby use any common database dialect to run these scripts directly in datapine.

 

You’ll find the SQL Box on the Chart Creators toolbar. Here you can switch to the SQL mode by clicking on the SQL box icon.

 

datapine's SQL Query Box

 

In the SQL Box you can paste or type in your SQL Queries, specify the data sources used in your script and build your chart using the variables defined in your Select command. Please follow this guide to learn how to create a SQL chart in datapine.