Skip to main content

New Features

SQL IDE

Comprehensive SQL development environment integrated into the Oxy IDE:
  • Multi-Tab Query Editor - Monaco-based SQL editor with syntax highlighting and multi-tab support for managing multiple queries simultaneously
  • Database Client Store - Centralized database connection management with query workspace state
  • Schema Browser - Explore database schemas, tables, and columns directly in the sidebar
  • Restructured IDE Navigation - Separate sections for Files, Database, Settings, and Observability with dedicated routing
  • Backend Execution - New endpoints for SQL query execution and cached database metadata retrieval

Execute SQL Query Shortcut

Keyboard shortcut for faster query execution:
  • Cmd/Ctrl+Enter Keybinding - Execute SQL queries directly from the Monaco editor without clicking Run button
  • Proper Cleanup - Monaco command and keybinding registrations properly cleaned up on component unmount
  • Integrated Workflow - Keyboard shortcut wired to existing Run behavior for seamless experience

Strict YAML Validation

Enhanced configuration validation to catch errors early:
  • Deny Unknown Fields - Added #[serde(deny_unknown_fields)] to Config, Workflow, AppConfig, and Semantics structs to reject typos at parse time
  • Common Error Prevention - Catches mistakes like using steps: instead of tasks: in workflow files
  • Enhanced CLI Validation - oxy validate command now supports --file flag for single-file validation with improved error reporting that continues after errors
  • Simplified Parsing - Removed redundant intermediate structs for cleaner configuration loading

Platform Improvements

SQL Query Result Handling

  • Forced Parquet Format - All SQL query results now use Parquet format instead of optional JSON, enabling VirtualizedTable with built-in paging and sorting
  • Result Table State Reset - Added key prop to VirtualizedTable to properly reset state (page, sort, selections, column widths) when displaying new results
  • Timezone Support - Extended dayjs with timezone and UTC plugins for proper handling of Arrow timestamp types with timezone information

Semantic Query Improvements

  • Execution Error Clearing - Fixed issue where execution errors persisted after query became valid by clearing error state on successful execution

Semantic Engine Container Management

  • Volume Mount Validation - Cube.js container startup now validates and reconciles existing volume mounts, recreating container if binds don’t match
  • Database URL Requirement - oxy semantic-engine command now requires OXY_DATABASE_URL environment variable with earlier runtime availability check
  • Improved Reliability - Better container lifecycle management prevents configuration drift

Dependencies Update

  • Latest Versions - Updated Rust and all dependencies to latest versions for improved performance and security