SQL Editor Update: Support for session-based execution in SQL Editor

We’ve introduced full session support in the Query Service API - a major step forward that unlocks a modern, stateful SQL workflow in Keboola.

With session-based execution, SQL Editor now supports session-scoped features such as:

  • SQL variables
  • Temporary tables
  • Session parameters (SET, etc.)
  • Other session-scoped SQL features

This brings Keboola’s SQL experience in line with tools like Snowflake Snowsight and removes long-standing limitations caused by stateless query execution. Complex analytical workflows that were previously difficult or impossible are now fully supported.

Rollout is planned gradually this and next week.

Interested in more details? Read our documentation.

Enjoy - and let us know your feedback!