CoolaData JDBC driver allows you to query your data on CoolaData using external applications. It can be integrated with any visualization tool to run over the data stored in CoolaData.
Installation varies between applications. Download the latest version of the driver here:  https://github.com/cooladata/JDBC

The connection URL in all apps for Cooladata’s JDBC is:


Each connection is for a specific project. To connect to multiple projects create another connection with another project_id in the URL.

Special URL parameters

For special functions you can append the following params to the connection URL:

  • Escape Quotes: If your query engine adds double quotes to sql queries, add escapeQuotes=true parameter to connection URL.  This flag deletes all double quotes from SQL queries since CoolaData server works with table and column names without double quotes. For example:
  • Date format: If dates in query results should be presented in GMT timezone (UTC time), add gmtTimezone=true parameter to connection URL. This flag changes default timezone to GMT. Please note: restart for query engine is required after removing gmtTimezone parameter from JDBC URL. For example:
  • Log file and debug level: If you are asked to get a log of what exactly the driver execute and process, you can specify a level of debug and a log file that all debug data will be written to it. add loglevel=debug&logfile=[file path] parameters to connection URL. Please note: using the log file will slow down performance of the driver as it writes a lot of text. For example:

Standard SQL

Cooladata support both sql dialects of BigQuery, Legacy and Standard. By default JDBC uses Legacy format.
To run standard sql in JDBC just add at the beginning of SQL the string #STANDARDSQL .
For example:

select event_time_ts from cooladata where date_range(last 90 days)

Dbeaver Setup

To set up CoolaData’s JDBC driver on Dbeaver please follow these steps:

  1. Open Dbeaver
  2. From the top menu choose: Database>Driver Manager
  3. Click “New”
  4. Give the new driver a name, such as: “CoolaData”
  5. Click “Add File”, locate and select the driver you downloaded
  6. Click “Find Class” and choose the result found
  7. Enter the following URL Template: jdbc:gdata:sql//app.cooladata.com/v2/{PROJECT_ID}?{params}
  8. Click “OK”
  9. 5
  10. Close the driver manager
  11. From the menu choose: Database>New Connection
  12. Select the newly created connection (“CoolaData”)
  13. Click “Next”
  14. Enter your CoolaData username (email) and password
  15. Click “Next”, “Next”, “Finish”
  16. From the menu choose: SQL Editor>SQL Editor
  17. Write your query and hit CTRL+Enter to run it


SQL WorkBench J

  1. Make sure you have Java installed on your desktop: Java SE Runtime Environment can be downloaded from: http://www.oracle.com/technetwork/java/javase/downloads/index.html
  2. Open SQL Workbench J
  3. Set up a new driver: open the “Manage Drivers” menu and create a new entry; name it “CoolaData”, and select the file you downloaded from your computer; click OK to save an exit.
    Manage drivers
  4. From the “Connect window” (Alt + C), add a new connection profile.
  5. Name the new profile.
  6. Enter the following URL (see above for connection parameters): jdbc:gdata:sql//app.cooladata.com/v2/{PROJECT_ID}?{params}
  7. From the “Driver” drop down choose “CoolaData (com.cooladata.driver.CoolaDataDriver)”.
  8. Enter your CoolaData username and password.
  9. Click OK.

sql j



Run the following commands in R Studio:

drv <- JDBC("com.cooladata.driver.CoolaDataDriver", "Path to the JDBC file/jxDBCon-jdbc3-0.9.9.jar", identifier.quote="`")
conn <- dbConnect(drv, "jdbc:gdata:sql//app.cooladata.com/v2/projectid", "username","password")
dbGetQuery(conn, "<query>")
Print Friendly, PDF & Email

Metric Insights

Metric Insights allows you to enjoy the power of personal alerts according to pre-defined rules, based on your data stored in CoolaData.

Configuring Metric Insights

In the Metric Insight dashboard, create a new data source. In the wizard, go to Admin → More → Data → Data Sources → Add New Data Source → Select Plug-In: CoolaData. Enter the name of your data source, and save.

To set parameters for the plug-in, go to Plug-in Configuration → Parameters. Enter the project ID in the Project field, and then go to Admin Console → Projects → Select Project, and copy the last segment in the URL in the admin console. The token is the user token from the admin console.
Next, create a new element, and then configure your metrics as needed.

For more information, see the Metric Insights online help.

Print Friendly, PDF & Email


Slack brings all your team communication into one place.  With email apps, you can skip your inbox and receive publication and alert emails directly in Slack.

Here’s how it works:

  1. See Send emails to Slack to set up an email app. You’ll get a special email address that delivers to the Slack channel of your choice.
  2. Enter this email in any publication, alert, or notification emails list to be notified directly to your Slack channel.
  3. Emails will show up as a message in the Slack channel or DM of your choice, together with the attached files.


Print Friendly, PDF & Email