> For the complete documentation index, see [llms.txt](https://docs.ortege.ai/en/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.ortege.ai/en/ortege-products/ortege-lakehouse.md).

# Ortege Lakehouse

**Ortege Lakehouse: Tailored Data Access for Every Need**

Ortege Lakehouse provides versatile data consumption options to ensure seamless integration with your systems. Access our blockchain data through[ **API endpoints**](/en/ortege-products/api.md), leverage **SQL** via[ Ortege Studio](/en/ortege-products/ortege-studio.md), or request [**Parquet file**](https://parquet.apache.org/) access for raw data. This multi-faceted approach enables you to choose the optimal format for your analytical and operational needs, with all methods secured via a [JWT token](https://jwt.io/) issued by the Ortege team.

#### API Endpoints

Built on [Cube](https://cube.dev/docs/product/introduction), our API endpoints organize data into **cubes**, each representing a structured collection of blockchain datasets optimized for performance. These cubes streamline access to specific data types, simplifying integration with your applications.

* **Organized by Cube**: Each cube is tailored to a blockchain or data category, such as transaction history, token metrics, or social sentiment.
* **Endpoint Access**: Easily interact with the cubes using REST or GraphQL endpoints, or connect via WebSocket for real-time streaming.

API access is controlled through a JWT token provided by the Ortege team, ensuring secure data transmission.

#### SQL Access via Ortege Studio

For users looking to run SQL queries on our datasets, [**Ortege Studio**](/en/ortege-products/ortege-studio.md) offers a straightforward, SQL-based interface. Explore and analyze datasets directly from the platform with SQL endpoints available in our [**Data Catalog**](/en/ortege-products/ortege-lakehouse/data-catalog.md), categorized by blockchain and topic.

Ortege Studio’s SQL capabilities provide flexible, on-demand data exploration, making it ideal for detailed analytics and reporting.

#### Parquet File Access

If your project requires raw data, Ortege offers access to **Parquet files** through our public cloud storage. To request access, simply reach out to the [Ortege team](https://t.me/ortege_friends), who will issue a JWT token for secure access to our cloud storage resources.

This data access structure, backed by our secure JWT token system, empowers you to seamlessly integrate and interact with blockchain data according to your specific needs.

***

#### **Join the Ortege Community**

Subscribe today to gain exclusive access to the Ortege API and unlock unparalleled blockchain data insights. Empower your applications with our optimized datasets and discover the transformative power of Ortege’s data ecosystem.

[**Subscribe Now**](https://buy.stripe.com/bIYcPbbNIgAdc80001)


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.ortege.ai/en/ortege-products/ortege-lakehouse.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.