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:


From Home page press Create button


In the modal widow select New chart


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


Additionally a query could be converted to the SQL form