This guide introduces you to SQL reports.

SQL reports is an analytical tool that enables you to create, edit, or view a report using data from third-party data sources that are written in SQL query or visual mode. It allows you to select data from a database for which you created an integration in your project (for example, a Google BigQuery or MS SQL database) and create a report based on that data.

🚧

Important

This feature is currently available in the BETA version, but we are working on its improvement.

When to use SQL reports

• Display data from the third-party data sources in the SQL reporter by writing a custom SQL query.
• Use data from Bloomreach Engagement BigQuery, and make a report out of it through the SQL reports feature.
• Write a SQL query in a more flexible editor and then just display the results in Bloomreach.

How to create a SQL report

1. Navigate to Analysis > SQL reports.

2. Click on the + or +New SQL report.
3. You now see a new SQL editor. As a data source, choose one of your SQL integrations to use data from and click on the Load data model. Loading the data might take a few seconds.

4. Choose either Visual mode or SQL mode according to your preferences.
5. Don't forget to click on the Save button when done.

If you want to display your final results, you have two options to do so:

1. In the SQL report library, directly click on the particular SQL report, and when it opens, you can view the results.
2. Through the dashboard:
   • Go to My dashboards from the side menu.
   • Either edit an already existing dashboard or create a new one.
   • Add SQL report node to your dashboard.
   • Select the SQL report to display.
   • After clicking the Save button, the final report results are added to the dashboard for viewing.

SQL report modes

Visual mode

Visual mode works the same way as standard reports. There are rows, columns, and metrics in order to create a report. It helps with a better visualization of raw data. You can summarize the data in a grid table or a chart. Learn more about how standard reports work.

SQL mode

In SQL mode, there is an available side column with available tables to query on, loaded for selected data sources. After clicking on the table, all available columns for the current table are displayed, also with their column type (number, string, ...). You can paste the name of a column/table by clicking on the plus sign next to the name of the table/column (visible when hovering over it).

Editing actions

In the upper right corner, there is a dot icon. After clicking on it, the bar menu will appear with those options for editing/adjusting the whole report: