Skip to main content
Lake Light

Overview

oleander’s lake provides a powerful environment for data analysis, collaboration, and discovery. Execute SQL queries, manage your tables, and contribute to the community—all with automatic lineage tracking and observability built-in.

Automatic lineage

Every operation in oleander automatically captures lineage metadata using the OpenLineage specification. No manual configuration required—just integrate and observe.

SQL execution

Run SQL queries directly in oleander’s lake environment. Whether you’re analyzing your own data or exploring public tables, the SQL interface provides:
  • Fast Query Execution - Execute queries with optimized performance
  • Interactive Results - View and export query results instantly
  • Query History - Access your past queries and results
  • Automatic Lineage - Every query automatically captures lineage metadata

Data management

Upload your data

Upload your own tables to oleander’s lake. Your data can be:
  • Private - Keep your data secure and accessible only to your team
  • Public - Share tables with the community for collaboration
  • Managed - Automatic versioning and lineage tracking

Access public tables

Explore and utilize public tables contributed by the oleander community. These tables are:
  • Curated - Vetted tables from trusted sources
  • Documented - Complete metadata and documentation included
  • Joinable - Easily join with your own data for analysis
Queries can be run on any url as well like below:
Lake Anything Light

Scheduled queries with time-travel

Schedule queries to run automatically at specified intervals with time-travel capabilities. Time-travel queries allow you to write queries that reference specific versions or timestamps of your data, ensuring reproducibility and enabling historical analysis without needing to maintain separate historical copies of your data. Please note that these do incur additional storage as each version is kept to preserve time-traveling capabilities.

Collaboration

Contribute to the oleander community by uploading public tables. Sharing tables helps:
  • Build Community - Foster collaboration and knowledge sharing
  • Enable Research - Provide tables for analysis and experimentation
  • Support Learning - Help others learn from example tables

Getting started

To start using the lake:
  1. Navigate to the Data Lake in your oleander dashboard
  2. Run a SQL query on a public table to get familiar
  3. Upload your own data to start analyzing your tables
  4. Explore lineage to see how data flows through your queries
The lake provides a complete environment for data analysis, from quick SQL queries to complex Spark jobs, all with observability built in.