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:
![Screenshot 2022-09-30 at 14.44.37.png 2880](https://files.readme.io/fce2a95-Screenshot_2022-09-30_at_14.44.37.png)
From Home page press Create button
![Screenshot 2022-09-30 at 14.45.28.png 2880](https://files.readme.io/51070db-Screenshot_2022-09-30_at_14.45.28.png)
In the modal widow select New chart
![Screenshot 2022-09-30 at 14.49.12.png 2880](https://files.readme.io/4719314-Screenshot_2022-09-30_at_14.49.12.png)
Press three dots in the top right corner -> press View the SQL button
![Screenshot 2022-09-30 at 14.49.52.png 2880](https://files.readme.io/3208b96-Screenshot_2022-09-30_at_14.49.52.png)
Additionally a query could be converted to the SQL form
Updated over 2 years ago