No code -> SQL

Footprint is built on a visualisation and plotting engine called Metabase:

Architecturally, Metabase is implemented in such a way that whatever chart is created in an easy-to-use UI, under the hood, it is first converted to SQL and subsequently sent to the server.

📘

It is possible to convert any chart created in UI to SQL form, but in the opposite direction it is possible only in case of simple queries

Next, there will be a demonstration of the process of converting a graph previously created using the drag-and-drop method into an SQL form.

Following is the step-by-step explanation of the whole workflow:

2880

From Home page press Create button

2880

In the modal widow select New chart

2880

Press three dots in the top right corner -> press View the SQL button

2880

Additionally a query could be converted to the SQL form