We’re expecting an RSA Private Key (PKCS#1) PEM file (Base64 encoding of an ASN.1 DER serialized structure), if the first line of the file isn’t, it’s probably not the format we’re supporting:



File Should be Unencrypted

If the file is encrypted (there will be some extra lines and the word “ENCRYPTED” will be visible), you can use OpenSSL to decrypt it (you will be prompt for the password):

openssl rsa -in [ENCRYPTED_KEY] -out [UNENCRYPTED_KEY]

OpenSSH to RSA

Newer version for OpenSSH will create a different format (OpenSSH Key), which we’re not currently supporting, you will need to transform it to a “PEM” file (this will overwrite the file, so make a copy):

ssh-keygen -p -f [UNENCRYPTED_OPENSSH_KEY] -m PEM -N ""

Putty (PPK) to RSA (Windows)

If you’re using PPK, you will need to transform it to an RSA Key (PEM). You can use Puttygen, load the key and select “Conversions” and then “Export OpenSSH key”:

Cooladata Winter 2019 Release Notes

In this product update you will find updates on:

  • Path analysis visualization (Sankey)
  • New enhanced date picker
  • Additional customized chart color palettes
  • Improved KPI report functionality: added Having and Sort by capabilities
  • Firebase support
  • Google Standard SQL support (We continue to support Legacy SQL)
  • Date condition for merging Aggregation and Models tables
  • UI / UX improvements
  • Shipment and cache notifications
  • Ability to download models logs


New / Improved Features:

  • Path analysis visualization (Sankey)
    We are aware that the best way to get insights is by visualizing the data, so we’ve looked for a better way to present the users journey: Meet our new Sankey visualization!
    It allows you to read the users actions in a simple and easy way and can help you maximize your conclusions about your users’ flow. It available in Path builder and CQL editor and the colors of the graph can be controlled through the visualization setting
  • New enhanced date picker
    We designed a new date picker that expands the querying abilities and improves the user experience.
    now you can query your data with more time functions including:
    – “Last N Days“: counting days back, not including the current day. In order to include the current day just set the “Include today” toggle ON.
    – “Previous N Weeks / Months / Quarters / Years“: Calculates calendar time period, that do not include the current ones.
    – “Current Week / Month / Quarter / Year“: calculates the current calendar time period.

    Custom date range by hours: adds the option to define start hour at the start date and end hour at the end date.
  • Additional customized chart color palettes
    We expanded our charts color palette and as from today, each report could be set with a different color palette to allow the best fit for your site’s design.
    In order to choose a new palette, open the report and change the color palette on the visualization setting.

  • Improved KPI report functionality: added Having and Sort by capabilities
    Cooladata added an advanced menu to the KPI report which enables you to add “HAVING” and “SORT BY” SQL function to the KPI query.
    The advanced menu will be shown at the bottom of the builder once the KPI report has at least one custom step and a breakdown.
    This ability allows you to filter aggregated reports  easily.

    For more information see our KPI documentation.
  • Firebase support
    Based on customer feedback and spotting an underserving in firebase analytics we released special features to help companies that rely on firebase as a development platform.

    1. JSON flattening at the ETL level for deserializing nested JSON and matching it to the known schema of firebase.  The result is the ability to query and not having to worry about unesting.
    2. Multiple project consolidation – companies running two projects or more enjoy consolidation for enhanced querying and comparison. This is also a significant cost reduction.
    3. Unlimited properties per event – 25 unique parameters with each event type. With Cooladata, there is no limit to the number of custom properties and dimensions per event.
    4. Enriching from Firebase real-time database – we managed to combine and manage update all properties and dimensions from Firebase into the fact table. We make it more efficient, producing insights by merging both raw and real-time data.
      For more information see our documentation.
  • Google Standard SQL support
    Up until now, Cooladata enabled running freehand queries over Cooladata using Standard SQL with CQL editors only. Cooladata now supports create a fully standard project, which automatically will support external tables with Standard dialect, support standard expressions and will allow querying the data with KPI report as part of a strategic plan to migrate Cooladata to operate in Standard SQL, encompassing all the advantages of the language, including performance enhancements, query optimizations and superior functionality.
    For more information about the new Standard SQL functions (like “Unnest”, “With”, “Array” etc.) see our Standard SQL documentation.
  • Date condition for merging Aggregation and Models tables
    Up until now, using “Append and Update strategy” allowed you to update existing rows (according to a unique key) and append new rows to the destination table. Starting from toady, Cooladata allows adding to partitions tables (Aggregation Tables or Models) with “Append and Update strategy” days filter (based on the partitions column) which enables to replace only the latest tables’ rows. This feature improves executions’ performance and helps to manage huge tables.
  • UI / UX improvements: Saving lists filters during the session and open in a new tab
    We’ve listened to our customers’ requests and continue to improve our user interface. As parts of our efforts, we enabled to keep the list’s filters until the end of the session. This includes the search, column filter, sorting, the active tab and the number of the presented results in the page (page size). In addition, we allow opening reports, dashboards and tasks in a new tab using CTRL+Click/middle mouse click.
  • Shipment and cache notifications
    In order to improve query performance, Cooladata uses extensively caching and shipment.
    Whenever a report is executed, Cooladata notify the user whether the data returned from the cache or used shipment 
    Controlling whether a report will use cache, as well as shipment, could have never been easier. Just click on the “Report Options” and set the toggle ON or OFF

    For more information see our report options documentation.
  • Ability to download models logs
    We added all the attached logs files to each run, available for download at the “View logs” window


Other Report Settings

The other reports settings are available from inside the report, in the top bar, each has his own icon:

Report Tags

Tags can be given to any reports. The tag’s design shows you an indication of the number of tags used in the report. Click the button to add or edit tags.
Use the filter column in the reports list in order to filter your reports by tags.

Save and Save as

Save as located inside the “save” dropdown.
Use it to save changes you’ve made to a new report, without affecting the original. This will switch you to the new saved report.

Report Folders

Reports folder is a new Cooladata feature which allows you to located easier and faster your project’s reports.
You could create a folder from the report itself or from the reports list, as long as you are the report owner or you have permission to edit it.

Access to the folders is available through the Report editor or through the Reports list.

Folders through the Report Editor

The report folders are available from inside the report, in the top bar next to the report filters

Folders through the Reports List

There are three ways to edit or add folders from the reports list:

A. Through the Folders menu-

Hover the folders names and use the sub-menu (3 dots) to edit.

Click the + to create new folder.

In order to delete just the folder, without the content, just move all the folder reports’ to another folder or delete the folder with the contained reports through the folder sub-menu.

B. Through the report sub-menu

Hover the reports and use the sub-menu (3 dots) in order move the report to another folder.

C. Through the bulked reports options

Click on the report’ check box and mark it, then click the folder icon in the bulked reports menu (at the top bar) in order to move the selected reports to a folder.

Important information

Report Folders are saved per project, and therefore, all of those options are available from the Project’s Reports tabs.

Click on “All Folders Content” in order to display all the project reports without the folders filters.

All the reports that aren’t related to any folder will be saved in the “Root” folder.

Please note that folders will be saved only if a report related to them,
therefore, please make sure you’ve added at least one report to your new folder.
Also, duplicated reports or reports which “saved as” will keep being related to the folder given to them in the original report.

Report Parameters

Parameters are variables, that allow you to define key and value, and by that inject any value you want to the query.

In order to use the parameters you need to define the key -value on the parameter popup and add the keyword to the report query.
You will be able to do so either from a CQL report or either from a dashboard:

Parameters through the CQL report

1. Open a CQL report, click on the parameter icon and define the keys and values you want. then add the keywords to the query with initial strudel (for example @tableName).

2. Open a CQL report, add the keywords to the query with initial strudel. When you’ll open the parameter popup, you could see the keywords you’ve entered to the query already there, just add value to each key and apply.

add the keywords to the query and add a value on the Parameters popup

Parameters through the dashboard

Adding a report with parameters to a dashboard will automatically add the report parameters to the dashboard. If you’de like to apply some parameters only for the dashboard, you could add them to the dashboard directly through the parameters icon (right next to dashboard filters).
You could also change the report parameters value on the dashboard, but if you would like to delete a report parameter you’ll need to delete it from the report itself.

Important information

  • Parameters will apply on CQL reports only (through the report builder and through the linked dashboard)
  • Two identical keys, in the same report, with different values, will inject the first set value (in both report and dashboard).
  • Two identical keys, with different values, in two separate reports, on the same dashboard, will inject the first set value.