The IOMETE SQL Editor allows you to effectively write and execute queries against your data using modern features and a clean, customizable UI.
The advanced Autocomplete function removes the need to remember the SQL syntax. It makes proactive suggestions while you type, using the built-in data catalog.
The Schema Explorer allows you to explore the schema of your databases while writing your query. Make use of the metadata for entities. Get shortcuts for the standard queries with the context menu and insert them into the current worksheet with a click. Copy the names of entities with a keyboard combination...
Save your queries and return back to them whenever you want and with the autosave feature you don’t have to worry about losing any progress.
Navigate through previous steps, check the metadata of the query, and reuse the query by opening it in the current worksheet.
Create Query Variables and use them throughout your worksheets. Safely change the value of a variable from one place without the necessity to edit the query.
Hide sections or make them full screen if you need to concentrate on something particular. Place your results at the right or go with the default placement at the bottom. With a clean and intuitive UI there is no need to worry about getting uncomfortable with a lot of elements on the screen. Everything is scrollable and manageable.
Book 20 mins with us to see if we're a mutual fit or we can dive in right away with a 45 min demo.
You just need to select lakehouse and database and you are good to go.
Yes. There is the ability to export results as a .csv file. The export button is located right above the results table.
You can use the Query History feature of the SQL editor.
You don’t have to do something special to enable autocomplete feature. It is enabled by default and it uses your data catalog information to enrich autocompleting possibilities.
There is an autosave feature working in the background that saves your progress once in a while.