Question 1

How to create a dashboard

Accepted Answer

1. Create a table or graph to add to the dashboard

Q: Reporting Emails

<p>${youtube}<a href="H_BtOcGtA9E">AI Generated Email Reports</a></p> <h1 id="introduction">Introduction</h1> <h6 id="theproblem">The problem:</h6> <p>It's important to keep track of your most important metrics and insights, so you know how things are changing every week. Unfortunately, people tend to forget to check or are too busy when things get chaotic, so it never really becomes a habit.</p> <h6 id="thesolution">The solution:</h6> <p>With AI Generated E-mail reports, all you have to do is take a few seconds to read the quick summary sent to your e-mail inbox once a week. No need to think, or proactively do anything. The information comes to you automatically. The AI Data Analyst runs the query this week, compares it to last week's result, and summarizes the important changes in an email.</p> <h1 id="requirements">Requirements</h1> <h6 id="adatabaseaccessiblefromblazesqlweb">A database accessible from BlazeSQL Web</h6> <p>Since these reports need to get the latest query result every week, even if nobody from your team opens BlazeSQL that day, the BlazeSQL servers need to be able to run the queries to compare the latest result to the previous result for the reporting summary. Make sure the required database for the query you add to the report is accessible from your account at <a href="https://www.BlazeSQL.com/app">BlazeSQL.com/app</a>, rather than just the desktop version.</p> <h6 id="blazeadvancedsubscriptionlimitedtrialaccessprovidedtootherusers">Blaze Advanced Subscription (limited trial access provided to other users)</h6> <p>This is an advanced feature, and requires an Advanced subscription for unlimited use. Other users have limited access to try this feature at no additional cost, and can receive up to 4 A</p>

How to create a table

To create a table (assuming your database is connected), simply describe what you want to the chatbot.

How to create a graph

To create a graph, see the dedicated article on creating graphs

2. Add it to a dashboard

From the chat

To add a table or graph to a dashboard from the chat as a non-technical user, simply click the options button on the top right of the table or graph, and click "Add to Dashboard"

Non-technical user add to dashboard from chat

From the saved page

Navigate to the "Saved" page from the left menu, simply click a saved query and you will see the "Add to dashboard" button in the bottom right.

Add to dashboard from the saved page

3. Edit, share, and refresh your dashboard.

Edit your dashboard

Simply click the edit button in the top right corner, then drag and drop to rearrange items, or drag the edges to resize.

${youtube}Drag and drop dashboard editing

Edit individual items

To edit individual graphs and tables in your dashboard, click the options button in the top right corner of the dashboard item. This will open a list of options for

Question 2

Creating and Editing Graphs in BlazeSQL

Accepted Answer

This article explains how BlazeSQL visualizes query results as graphs and how you can customize them using the graph editor.

Automatic graph visualisation

BlazeSQL automatically displays query results in a graph format. If your results appear as a standard table, you can simply instruct BlazeSQL to "create a graph."

You can ask BlazeSQL to create graphs

Supported Graph Types

BlazeSQL supports the following visualization types:

Table
Single Value
Bar Chart
Line Chart
Pie Chart
Scatter Plot
Map (for geographic data)

Edit Graphs

Open graph editor

Click the 3 dot menu icon in top right corner of a graph, and then click "Open editor".

Open graph editor

Advanced graph features

Multi-bar & Multi-line charts

To create a Multi line or Multi bar chart, use the "Group by" variable. Each group will have a separate bar or line. When making the chatbot request, just tell the chatbot which variable to group by. Ex. "get the number of users for each country, grouped by gender"

BlazeSQL multi-bar chart

Interactive filters/sliders

To make your graph more interactive with a slider that filters the data in the graph, select a variable for the "Inter

Question 3

How to set up Blaze for your company

Accepted Answer

Requirements

Technical users

It's important that the person following this guide has the database access credentials, and enough understanding of SQL to test the chatbot and help it understand the database. Non-technical users should not attempt to use BlazeSQL until step 3 of this setup guide.

Database credentials

You must have the credentials of an SQL database that can accept connections from your device if you are using the desktop version. If you are using the web version of BlazeSQL and your database only allows specific IP addresses, you can whitelist the provided static IP.

Step 1: Connect the database

Create an account and connect your SQL database

Log into https://www.BlazeSQL.com/app, create an account, and connect your SQL database.

Make sure your team will be able to connect

If you download the desktop version and your IP address is whitelisted on your database server, keep in mind that users you invite later will need to have their IP addresses whitelisted on your server. We recommend using the web version and whitelisting the provided static IP or allowing all IPs, so that no setup is required for your team.

Step 2: Go to Train Blaze and fill Blaze’s knowledge gaps

Blaze gathers extensive knowledge by analyzing your data. However, every company has unique business logic, definitions, and tribal knowledge that isn't captured in its databases. The Train Blaze page allows you to address

Question 4

Chat with Supabase PostgreSQL using BlazeSQL AI

Accepted Answer

Supabase aims to make Postgres easily accessible to all users. You can quickly get your PostgreSQL database up and running in a few minutes with features like vector search and authentication directly integrated into it. **

If you're considering using Supabase PostgreSQL, then BlazeSQL is an AI-powered tool that can help you effortlessly uncover data insights.

BlazeSQL is an AI tool that integrates seamlessly with Supabase PostgreSQL. You can ask BlazeSQL questions about your data in natural language. The SQL AI understands what you're asking, digs through your data to find the right information, and creates clear charts and graphs to visualise the answer. It can also provide SQL queries.

It's like having a helpful data expert who does all the technical work for you - you just need to ask the questions you care about. **

At the end of this tutorial, you will have:

Set up a PostgreSQL database running on Supabase,
Connected PostgreSQL to BlazeSQL, and
Queried your data by simply chatting with Blaze (our chatbot).

Setting up Supabase database

** First, head to your Supabase dashboard and create your organization:

Create organization on Supabase **

Create a new project. Give your project a name, select your hosting region, and click "Create new project."

![Create new project in Supabase](

Question 5

Non-technical vs. technical mode

Accepted Answer

Technical mode

What is it?

When using the "technical mode" the chatbot will show the SQL code in its responses and will communicate more specifically about SQL code, and specific tables and columns. The chatbot may also ask the user how to join certain tables or filter on columns, since it assumes technical users know how to.

SQL Query in Technical AI Chatbot mode

SQL Query result in Technical AI Chatbot mode

Non-technical mode

What is it?

When using the "Non-technical mode" the AI will generate and run the SQL code in the background. The chatbot will usually not mention technical specifics about tables, columns, and SQL code, and will avoid asking the user for help with database specifics as it assumes non-technical users aren't familiar with the database.

BlazeSQL non-technical mode chat

Switching between technical and non-technical mode

When registering for BlazeSQL, users are asked if they are "Non-technical" or "Technical", which will configure the app accordingly.

The setting can be changed by switching the "Non-technical" setting in the "Chatbot settings" section of the settings page.

![Non-technical mode switch](https://storage.cri

Question 6

Reporting Emails

Accepted Answer

${youtube}AI Generated Email Reports

Introduction

The problem:

It's important to keep track of your most important metrics and insights, so you know how things are changing every week. Unfortunately, people tend to forget to check or are too busy when things get chaotic, so it never really becomes a habit.

The solution:

With AI Generated E-mail reports, all you have to do is take a few seconds to read the quick summary sent to your e-mail inbox once a week. No need to think, or proactively do anything. The information comes to you automatically. The AI Data Analyst runs the query this week, compares it to last week's result, and summarizes the important changes in an email.

Requirements

A database accessible from BlazeSQL Web

Since these reports need to get the latest query result every week, even if nobody from your team opens BlazeSQL that day, the BlazeSQL servers need to be able to run the queries to compare the latest result to the previous result for the reporting summary. Make sure the required database for the query you add to the report is accessible from your account at BlazeSQL.com/app, rather than just the desktop version.

Blaze Advanced Subscription (limited trial access provided to other users)

This is an advanced feature, and requires an Advanced subscription for unlimited use. Other users have limited access to try this feature at no additional cost, and can receive up to 4 A

Frequently Read Articles

Browse All Categories