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
Updated over 2 years ago