# 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**](https://docs.ortege.ai/en/ortege-products/api), leverage **SQL** via[ Ortege Studio](https://docs.ortege.ai/en/ortege-products/ortege-studio), 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**](https://docs.ortege.ai/en/ortege-products/ortege-studio) offers a straightforward, SQL-based interface. Explore and analyze datasets directly from the platform with SQL endpoints available in our [**Data Catalog**](https://docs.ortege.ai/en/ortege-products/ortege-lakehouse/data-catalog), 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: 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:

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

The question should be specific, self-contained, and written in natural language.
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.