Scaleway Data Warehouse for ClickHouse® is a fully managed, European hosted data warehouse designed to power data analytics at scale – without the complexity of traditional infrastructure. It leverages very fast, analytical ClickHouse® database optimized for readings and aggregations.
This demo represents the BI (Business Intelligence) analytics use case, where the raw data stored in Scaleway Data Warehouse for ClickHouse® is being transformed using Apache Superset™ platform to power real-life dashboards.
ClickHouse® features
Blazing fast
Column oriented, blazingly fast database, ideal for analytics.
Federated queries
Query remote databases without ever copying data into ClickHouse.
Open-source
No proprietary lock-in.
SQL compatible
Intuitive SQL commands.
Distributed compute
Leverage the compute power of all the nodes in your cluster.
Proven at scale
Query terabytes of data easily.
Our value proposition
Simplicity
Deploy clusters with multiple nodes and a load balancer effortlessly.
Sovereignty
Hosted in Europe-based data centers.
Performance at scale
Autoscaling from 1 to 15 vCPU.
Security
Natively integrated with the Scaleway VPC.
Transparent pricing
Predictable pricing, based on provisioned vCPU and storage.
Bottomless storage
100 GB of Block Storage included, on top of an unlimited S3 Storage.
High-level demo design
The entire demo environment is created through Terraform code.
The CPU Instance is used to load datasets from public Object Storage bucket to MongoDB®, PostgreSQL and ClickHouse® databases.
Datasets stored in MongoDB®, PostgreSQL or Object Storage can be queried using ClickHouse® query federation feature, without the need of copying the data into ClickHouse® database.
The CPU Instance with pre-installed Docker image is used as a base for an external tool – Apache Superset™ platform – allowing exploration of the data.
Scaleway technical specification
| Design element | Scaleway Product | Technical specification |
|---|---|---|
| Data loader CPU Instance | STANDARD3-X2C-8G | 2 vCPU, 8 GB RAM, 10 GB Block Storage 5k IOPS |
| BI CPU Instance | Docker pre-installed, STANDARD3-X2C-8G | 2 vCPU, 8GB RAM, 60 GB Block Storage 5k IOPS |
| Data Warehouse for ClickHouse® | ClickHouse-v25 | 2 vCPU, 8 GB, 100 GB Block Storage 5k |
| Managed MongoDB® | MongoDB 8.0, MGDB-PLAY2-NANO | 2 vCPUs, 4 GB RAM, 5 GB SBS 5k |
| Managed Database for PostgreSQL | PostgreSQL-17, DB-DEV-S, Standalone | 2 vCPUs, 2 GB RAM, 5GB Local Storage |