Improved Feature
16 days ago

Enhanced SQL UI with Notebook-Style Execution

We've upgraded Ilum’s SQL Editor to support notebook-style operations, making it easier than ever to explore, query, and analyze big data at scale. Starting now, you can write & execute SQL in structured cells, just like in Jupyter Notebook, instead of running your Apache Spark SQL queries one by one. This enables you to run SQL or SQLite queries similar to a Jupyter Notebook. So instead of running Apache Spark SQL queries one by one, you can write and execute SQL in structured cells. 

Key Improvements: 
- Notebook-style SQL execution – Run and organize queries in cells for a more interactive SQL analytics experience. 
- Persistent query history – Save and revisit SQL jobs for improved workflow management. 
- Multi-cell execution – Execute individual cells or entire SQL notebooks for fast, scalable data exploration. 
- Integrated with BI & Data Platforms – Query data stored in cloud data lakes, data warehouses, and on-prem storage via JDBC integration. 

With this update, it is easier to query SQL inside Ilum and manage data lakehouse, business intelligence and big data analysis.  Check it out today and meet the better way to manage your structured and semi-structured data! 🚀

ilum-improved-sql.png 180.53 KB