Skip to main content

Ocient Hyperscale
Data Warehouse

Run analytics on trillions of rows in seconds. Connect, load, and query massive datasets with the speed and scale your organization needs.

Get StartedLearn Key Concepts
import pyocient

# Connect to Ocient Hyperscale Data Warehouse
conn = pyocient.connect("ocient://user:password@host:4050/database")

# Execute analytics query
cursor = conn.cursor()
cursor.execute("SELECT count(*) FROM sensor_data WHERE timestamp > NOW() - INTERVAL '1 HOUR'")
print(cursor.fetchall())

Quick Start

Get up and running with Ocient in minutes

Connect with JDBC

Set up a JDBC connection to run queries from Java applications or the CLI

Connect with Python

Use pyocient to connect and query Ocient from Python applications

Load Your Data

Create data pipelines to ingest data from S3, Kafka, HDFS, and more

Guides

Step-by-step tutorials to help you succeed with Ocient

Key Concepts

Understand the architecture, nodes, data types, and indexing strategies that power Ocient’s hyperscale performance

Query Ocient

Learn how to write effective queries, optimize performance, and leverage Ocient’s SQL capabilities

Database Administration

Manage security, users, access controls, and optimize query performance with keys and indexes

System Administration

Install, configure, maintain, and monitor your Ocient system with hardware and software requirements and ongoing maintenance

Integrations

Connect Ocient with your favorite tools and platforms

DBeaver

Metabase

Tableau

Superset

SQLAlchemy

Looker Studio

View all integrations →

API Reference

Complete technical reference for developers

HTTP Query API

REST API for executing SQL statements with authentication, streaming, and SSO support

SQL Reference

Data types, functions, operators, DDL, DCL, and geospatial reference

Connection Drivers

JDBC and pyocient driver documentation and configuration options

Architecture

Learn how Ocient achieves hyperscale performance

Compute Adjacent Storage Architecture

Learn how CASA collocates NVMe storage with compute resources for optimal performance on trillions of rows

Distributed System Design

Understand SQL Nodes, Loader Nodes, and Foundation Nodes that form the Ocient data warehouse