Apache Kylin

Apache Kylin is an open-source distributed analytics engine designed to provide a SQL interface and multi-dimensional analysis (OLAP) on large-scale datasets. It provides sub-second query latency on trillion-record datasets via pre-computed cubes and works on top of Hadoop, Spark, and cloud storage.

Apache Kylin publishes 6 APIs on the APIs.io network, including Authentication API, Jobs API, Models API, and 3 more. Tagged areas include Analytics, Big Data, Cube, OLAP, and Open Source.

The Apache Kylin catalog on APIs.io includes 1 JSON-LD context and 2 Spectral governance rulesets.

Apache Kylin’s developer surface includes authentication, documentation, getting-started guide, and 9 more developer resources.

🌐 Visit website 📡 Source on GitHub

53.6/100 developing ▼ -5.2 Agent 37/100 agent ready Full breakdown ↓
scored 2026-07-28 · rubric v0.6

AccessFreemiumSelf serve⚡ Free to try

7 APIs 7 Features 4 Use Cases

AnalyticsBig DataCubeOLAPOpen SourceSQL

Kin Score

Kin Score How this is scored →
scored 2026-07-28 · rubric v0.6

Composite quality — 53.6/100 · developing

Contract Quality 16.0 / 25

Developer Ergonomics 6.1 / 20

Commercial Clarity 10.0 / 20

Operational Transparency 6.8 / 13

Governance 8.3 / 12

Discoverability 6.5 / 10

Agent readiness — 37/100 · agent ready

Machine-Readable Contract 18 / 18

Agentic Access Contract 10 / 10

MCP Server 0 / 12

Machine-Readable Auth 10 / 10

Idempotency 0 / 9

Stable Error Semantics 0 / 8

Request/Response Examples 7 / 7

Rate-Limit Signaling 7 / 7

Typed Event Surface 0 / 6

Agent Skills 0 / 5

Well-Known Catalog 0 / 4

Consent & Bot Identity 0 / 3

A2A Agent Card 0 / 8

Dry-Run / Simulate Mode 0 / 4

Improve this rating by publishing the missing artifacts — every area above can be raised, and the full rubric is at apis.io/rating/. This rating is computed from github.com/api-evangelist/apache-kylin: open an issue to ask a question, or submit a pull request to add artifacts. Want it done for you? Prioritized profiling — $2,500 →

APIs 7

Individual APIs this provider publishes, each with its own machine-readable definition.

Rate Limits 1

Documented rate limits and quota policies.

Apache Kylin Rate Limits

5 limits

RATE LIMITS

FinOps 1

Cost, billing, and metering signals for API financial operations.

Apache Kylin Finops

FINOPS

Features 7

Notable capabilities this provider offers.

Sub-Second OLAP Queries

Pre-computed cubes enable sub-second query response on trillion-record datasets.

SQL Interface

ANSI SQL interface for business analysts using existing SQL skills.

Cube Pre-computation

Build cubes with aggregates pre-calculated for instant query response.

Hadoop and Cloud Integration

Works on top of Hadoop, Spark, and cloud object storage.

JDBC/ODBC Drivers

Standard JDBC and ODBC drivers for BI tool integration.

Segment Management

Incremental cube building with date-range segment management.

Multi-Tenancy

Project-based multi-tenancy for isolating datasets and access.

Scroll for all 7

JSON Schema 8

Standalone JSON Schema definitions for this provider's data models.

Scroll for all 8

Examples 8

Example request and response payloads for these APIs.

Scroll for all 8

Use Cases 4

What developers build with this provider.

Data Warehouse Query Acceleration

Accelerate slow Hive or Spark queries with Kylin cube pre-computation.

BI Tool Integration

Connect Tableau, PowerBI, and Superset to Kylin via JDBC for analytics.

Real-Time OLAP

Stream data into Kylin incrementally for near-real-time OLAP analytics.

Large-Scale Reporting

Generate business reports over trillion-record datasets in seconds.

Integrations 7

Pre-built integrations with other platforms and tools.

Apache Hadoop

Reads from HDFS and executes MapReduce cube builds on Hadoop.

Apache Spark

Spark-based cube building for faster and more efficient data processing.

Apache Hive

Hive metastore integration for table schema and metadata.

Apache HBase

HBase storage for pre-computed cube data.

Tableau

Native Tableau connector via Kylin JDBC driver.

Apache Superset

Apache Superset integration via JDBC for self-service analytics.

{"type" => "Blog", "url" => "https://kylin.apache.org/blog/rss.xml"}

Scroll for all 7

Resources

Get Started 1

Portal, sign-up, and the first successful call

GettingStarted

GettingStarted

Documentation 1

Reference material describing how the API behaves

Documentation

Documentation

Agent Surfaces 1

MCP servers, agent skills, and machine-readable catalogs

AgenticAccess

AgenticAccess

Design & Contract 3

Pagination, idempotency, versioning, errors, and events

Versioning

Versioning

SpectralRules

SpectralRules

Vocabulary

Vocabulary

Build 2

SDKs, sample code, and the tooling you integrate with

GitHubOrganization

GitHubOrganization

GitHubRepository

GitHubRepository

Access & Security 3

Authentication, authorization, and security posture

VulnerabilityDisclosure

VulnerabilityDisclosure

DomainSecurity

DomainSecurity

Authentication

Authentication

Commercial 1

Pricing, plans, and the legal terms of use

TermsOfService

TermsOfService

Source (apis.yml)

aid: apache-kylin
name: Apache Kylin
description: Apache Kylin is an open-source distributed analytics engine designed to provide a SQL interface and multi-dimensional
  analysis (OLAP) on large-scale datasets. It provides sub-second query latency on trillion-record datasets via pre-computed
  cubes and works on top of Hadoop, Spark, and cloud storage.
type: Index
accessModel:
  pricing: freemium
  onboarding: self-serve
  trial: false
  try_now: true
  public: false
  label: Freemium · Self-serve signup
  confidence: high
  source:
  - plans
  - authentication
  generated: '2026-07-22'
  method: derived
position: Consumer
access: 3rd-Party
image: https://kinlane-images.s3.amazonaws.com/shared/apis-json/icons/apache-kylin.png
tags:
- Analytics
- Big Data
- Cube
- OLAP
- Open Source
- SQL
created: '2026-03-16'
modified: '2026-05-19'
url: https://raw.githubusercontent.com/api-evangelist/apache-kylin/refs/heads/main/apis.yml
specificationVersion: '0.19'
apis:
- aid: apache-kylin:jdbc-driver
  name: Apache Kylin JDBC Driver
  description: The Kylin JDBC driver provides SQL-over-Kylin access for BI tools and SQL clients, enabling standard JDBC connectivity
    to Kylin OLAP cubes.
  humanURL: https://kylin.apache.org/docs/tutorial/jdbc.html
  tags:
  - JDBC
  - SQL
  properties:
  - type: Documentation
    url: https://kylin.apache.org/docs/tutorial/jdbc.html
- aid: apache-kylin:apache-kylin-authentication-api
  name: Apache Kylin Authentication API
  description: User authentication
  humanURL: https://kylin.apache.org/docs/restapi/
  tags:
  - Authentication
  properties:
  - type: OpenAPI
    url: openapi/apache-kylin-authentication-api-openapi.yml
  - type: Documentation
    url: https://kylin.apache.org/docs/restapi/
- aid: apache-kylin:apache-kylin-jobs-api
  name: Apache Kylin Jobs API
  description: Build job management
  humanURL: https://kylin.apache.org/docs/restapi/
  tags:
  - Jobs
  properties:
  - type: OpenAPI
    url: openapi/apache-kylin-jobs-api-openapi.yml
  - type: Documentation
    url: https://kylin.apache.org/docs/restapi/
- aid: apache-kylin:apache-kylin-models-api
  name: Apache Kylin Models API
  description: Data model management
  humanURL: https://kylin.apache.org/docs/restapi/
  tags:
  - Models
  properties:
  - type: OpenAPI
    url: openapi/apache-kylin-models-api-openapi.yml
  - type: Documentation
    url: https://kylin.apache.org/docs/restapi/
- aid: apache-kylin:apache-kylin-projects-api
  name: Apache Kylin Projects API
  description: Project management
  humanURL: https://kylin.apache.org/docs/restapi/
  tags:
  - Projects
  properties:
  - type: OpenAPI
    url: openapi/apache-kylin-projects-api-openapi.yml
  - type: Documentation
    url: https://kylin.apache.org/docs/restapi/
- aid: apache-kylin:apache-kylin-query-api
  name: Apache Kylin Query API
  description: SQL query execution
  humanURL: https://kylin.apache.org/docs/restapi/
  tags:
  - Query
  properties:
  - type: OpenAPI
    url: openapi/apache-kylin-query-api-openapi.yml
  - type: Documentation
    url: https://kylin.apache.org/docs/restapi/
- aid: apache-kylin:apache-kylin-tables-api
  name: Apache Kylin Tables API
  description: Table and datasource management
  humanURL: https://kylin.apache.org/docs/restapi/
  tags:
  - Tables
  properties:
  - type: OpenAPI
    url: openapi/apache-kylin-tables-api-openapi.yml
  - type: Documentation
    url: https://kylin.apache.org/docs/restapi/
common:
- type: AgenticAccess
  url: agentic-access/apache-kylin-agentic-access.yml
- type: VulnerabilityDisclosure
  url: security/apache-kylin-vulnerability-disclosure.yml
- type: DomainSecurity
  url: security/apache-kylin-domain-security.yml
- type: Authentication
  url: authentication/apache-kylin-authentication.yml
- type: GitHubOrganization
  url: https://github.com/apache
- type: GitHubRepository
  url: https://github.com/apache/kylin
- type: Documentation
  url: https://kylin.apache.org/docs/
- type: GettingStarted
  url: https://kylin.apache.org/docs/tutorial/kylin_sample.html
- type: TermsOfService
  url: https://www.apache.org/licenses/LICENSE-2.0
- type: Versioning
  url: https://kylin.apache.org/download/
- type: SpectralRules
  url: rules/apache-kylin-spectral-rules.yml
- type: Vocabulary
  url: vocabulary/apache-kylin-vocabulary.yaml
- type: Features
  data:
  - name: Sub-Second OLAP Queries
    description: Pre-computed cubes enable sub-second query response on trillion-record datasets.
  - name: SQL Interface
    description: ANSI SQL interface for business analysts using existing SQL skills.
  - name: Cube Pre-computation
    description: Build cubes with aggregates pre-calculated for instant query response.
  - name: Hadoop and Cloud Integration
    description: Works on top of Hadoop, Spark, and cloud object storage.
  - name: JDBC/ODBC Drivers
    description: Standard JDBC and ODBC drivers for BI tool integration.
  - name: Segment Management
    description: Incremental cube building with date-range segment management.
  - name: Multi-Tenancy
    description: Project-based multi-tenancy for isolating datasets and access.
- type: UseCases
  data:
  - name: Data Warehouse Query Acceleration
    description: Accelerate slow Hive or Spark queries with Kylin cube pre-computation.
  - name: BI Tool Integration
    description: Connect Tableau, PowerBI, and Superset to Kylin via JDBC for analytics.
  - name: Real-Time OLAP
    description: Stream data into Kylin incrementally for near-real-time OLAP analytics.
  - name: Large-Scale Reporting
    description: Generate business reports over trillion-record datasets in seconds.
- type: Integrations
  data:
  - name: Apache Hadoop
    description: Reads from HDFS and executes MapReduce cube builds on Hadoop.
  - name: Apache Spark
    description: Spark-based cube building for faster and more efficient data processing.
  - name: Apache Hive
    description: Hive metastore integration for table schema and metadata.
  - name: Apache HBase
    description: HBase storage for pre-computed cube data.
  - name: Tableau
    description: Native Tableau connector via Kylin JDBC driver.
  - name: Apache Superset
    description: Apache Superset integration via JDBC for self-service analytics.
  - url: https://kylin.apache.org/blog/rss.xml
    type: Blog
maintainers:
- FN: Kin Lane
  email: info@apievangelist.com