open bouquet readme

Open Bouquet Developer Hub

Welcome to the open bouquet developer hub. You'll find comprehensive guides and documentation to help you start working with open bouquet readme as quickly as possible, as well as support if you get stuck. Let's jump right in!

Get Started    Documentation

Getting started with Bouquet

Overview : a complete use case to create a bookmark and publish it in an app.

Download and Install Bouquet

Using Windows
Using Mac OS
Using Linux

Connect to a database

Open the Bouquet app for the first time.

There are two possible choices :

  • You know how to connect to your database so you create your own project. The left side is for you.
  • You don't have any database of your own to connect t. Click "use our demo project" on the right side.
The landing

The landing

You use the demo project

A default project is automatically created in your project list.
Double click on it and after a loading moment it will display the list of the available tables.
At any time, you can connect to your own database by clicking on "Add a project" in the left panel.

Click to add a project

Click to add a project

You use your own project

A connection popup displays
Fill it with your database parameter and click "check connection".
In the next screen, don't forget to select at least a schema.

You can now save your project and select it in the project list. Our zero-commute feature import schemas and directly populate the model. In case relations are already defined in your database, Bouquet can generate relations by itself.

Double click on your project name and after a loading moment it will display the list of the available tables.You can at any time use another database by modifying the current project or creating another one.

If you need more details see the guide : How to create a project ?

Create your first query

Open your project and double click the table you want to analyze. You'll open the Query Builder. In this example we are using the demo project.

In the demo project, you can select, "Sales" table as an example.

In the demo project, you can select, "Sales" table as an example.

The left part is your query configuration. The right part is the material from your project and from Bouquet. Switch between tabs to access :

  • Dimensions are the possible quantitative column values
  • Metrics are calculated outputs
  • Functions are the existing SQL built-in operations. You can use them as aggregates.

For more details about the Query Builder and its possibilities see see Query a bookmark or a domain

Select a period and click the "Query" button.

The result of your query is now visible at the bottom of the page. You can note that the first metric is already selected for you by the zero-commute.

Add a breakdown colum

As interesting as the total of one month can be, we now want to split this result by day of the month.
Click the tab "Dimensions" to display the possible columns information.
Look for a date, like "Saletime" in the demo then drag and drop it to the "groupBy" text area.

Now the result is displayed by date. To order it, drag and drop "Saletime" in the "orderBy" text area, the same way you did for the group by.

For more details about the Query Builder and its possibilities see Query a bookmark or a domain

Save a bookmark

Now that you are happy with your query, you can save it as a bookmark, by hitting the "Bookmark" button bellow the result table.
Just gives your Bookmark a name. You can now re-open it from the "Public" folder of the "Bookmark" navigator.

Use my bookmark into a web app

With Bouquet, you can easily embed your query into any application. You'll find bellow the steps.

Generate a new API key

Go back to the project list and select your project. Then click the "Get API key" button.

For all details about the API key and its attributes.

The generated API key will have access to all public bookmarks of this project.

Build my first app

You can now follow the first simple tutorial to help you build your first app and embed your new bookmark in it.

Getting started with Bouquet

Overview : a complete use case to create a bookmark and publish it in an app.