What is the SQL editor?
The SQL editor enables you to create widgets by writing queries in SQL. The SQL editor provides you with an advanced and flexible way to generate widgets tailored to your specific needs.
💡 With the SQL editor, you can join as many tables as you want without any limitations.
❗Using the SQL editor requires a certain level of technical expertise and familiarity with SQL language. This tool is best suited for users who possess a solid understanding of SQL and are comfortable constructing queries to extract the desired data from the database.
Where to find the SQL editor
- On your sidebar, go to Analytics
- Head to Advanced reports
- Open a dashboard or create a new one
- If a new dashboard is created, the SQL Editor option will appear once it has been created.
- If you open an already created panel, click on Add new widget and select Use SQL editor.
When you enter the SQL editor, a sample query will be displayed. On the left, you can find a list of all the tables and their corresponding fields, which can assist you in composing your query.
