> ## Documentation Index
> Fetch the complete documentation index at: https://oxy.tech/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# SQL IDE Enhancements, Time Dimensions, Version Tracking, and Platform Stability

> Enhanced temporal analytics, SQL IDE improvements, build metadata visibility, and comprehensive platform reliability fixes

<Icon icon="calendar" iconType="regular" size={16} /> **February 12, 2026**

### New Features

#### Time Dimension Support

Enhanced temporal analytics capabilities in the semantic layer:

* **Granularity Control** - Query time dimensions with configurable granularity (day, week, month, quarter, year)
* **Relative Time Filters** - Filter time dimensions using relative time expressions (e.g., "last 30 days", "this quarter")
* **Improved Validation** - Better error messages and validation for time-based queries
* **Snowflake DateTime Fix** - Resolved display issues for Snowflake datetime values in the frontend

#### SQL IDE Improvements

Comprehensive enhancements to the SQL development environment:

* **Manual Database Refresh** - New refresh button in database sidebar with loading state indicator for reloading connections on demand
* **Enhanced Error Handling** - Detailed error responses with status codes and descriptive messages for connection, execution, storage, and parsing errors
* **Semantic Model Metadata** - Richer semantic model details for each dataset and table with database name context
* **Auto-Sync State** - Database list automatically invalidates after successful sync to reflect latest state
* **Better Error Display** - Improved error extraction and display in query editor with robust API response parsing

#### Version Banner

Build metadata visibility for easier diagnostics:

* **Health Endpoint Metadata** - Backend health endpoints now include compile-time build information (commit hash, timestamp, build profile, CI URLs)
* **Version Badge in UI** - New `VersionBadge` popover in IDE header displays build and version details
* **Runtime Traceability** - Quickly identify which version is running for debugging and support purposes

***

### Platform Improvements

#### Observability & Logging

* **Granular Log Level Control** - Separate filters for console output (`OXY_LOG_LEVEL`, default: "warn") and OTLP trace export (`OXY_OTLP_LOG_LEVEL`, default: "debug")
* **Reduced Verbosity** - Removed extensive tracing statements from server API endpoints for cleaner logs
* **OTel Collector Fixes** - Added restart policy with 5 retries to handle ClickHouse startup race conditions
* **Network Verification** - ClickHouse readiness checks now verify network accessibility on port 9000

#### Task Output Injection

* **Table Data Rendering** - Fixed `{{ task_name }}` to output actual table data instead of debug file paths in agent prompts and formatter templates
* **Markdown Display** - Tables in `type: markdown` blocks now render as JSON code blocks instead of `[object Object]`
* **Semantic Query Logs** - Automation run logs now properly display semantic query parameters, generated SQL, and results

#### Tool Configuration

* **Default Tool Names** - Tools automatically receive default names based on type if omitted
* **Unique Name Validation** - Enforced unique tool names within agent configurations to prevent errors
* **Better Defaults** - Improved default values for tool `name` and `description` fields

#### File System & Permissions

* **WSL Permission Fix** - Cube.js containers now run as host user's UID:GID on Unix systems to prevent root-owned files
* **Unicode-Safe Encoding** - Added Unicode-safe Base64 utilities to handle file paths with non-Latin characters and emojis
* **Better Error Messages** - Clear, actionable error messages for permission issues with fix instructions

#### Database Management

* **Connection Pool Configuration** - Added timeouts, connection limits, and connection testing for improved reliability
* **PostgreSQL Update** - Updated PostgreSQL image from 18-alpine to 18.1 across all configurations
* **SSE Keep-Alive** - Prevents timeout on long-running workflow event streams

#### UI Stability

* **Workflow Preview Fix** - Refactored streaming logic to prevent app crashes during workflow execution
* **Preview Refresh** - Standardized preview refresh behavior with proper state management
* **Save Changes Consistency** - Fixed issue where save changes sometimes didn't appear in preview
* **Special Characters** - Fixed frontend crashes when file paths contain non-Latin characters or emojis

#### Container Management

* **Enterprise Network Cleanup** - Enhanced container cleanup with retry logic during graceful shutdown
* **Consolidated Cleanup** - `cleanup_containers_on_shutdown()` now stops and removes all Oxygen-managed containers

#### Dependencies Update

* **Latest Versions** - Updated Rust and all dependencies to latest versions for improved performance and security
* **Removed Unused Dependencies** - Cleaned up lockfile by removing unused `chrono-node` dependency
