Altinity Knowledge Base for ClickHouse®
  • Products
    Altinity.Cloud
    Managed service for ClickHouse in any AWS, GCP, or Azure region or your own VPC
    Support for ClickHouse
    Get 24/7 Support or POC and evaluative support
    Training for ClickHouse
    Altinity Administrator training for ClickHouse
    Customer Stories
    See why our customers love us
  • Resources
    Documentation
    Product guides and tutorials
    Guides and eBooks
    Technical content for developers
    What is ClickHouse?
    Learn why ClickHouse is the fastest database in the world
    What is Kubernetes?
    Learn why Kubernetes is the platform of choice for analytic databases
  • Blog
  • Company
    About the Company
    Who we are and what we do
    Careers
    Join our team!
    Contact
    Have questions? We've got answers.
  • Need help?      
  • Altinity® Knowledge Base for ClickHouse®
    • Engines
      • Atomic Database Engine
        • How to Convert Ordinary to Atomic
        • How to Convert Atomic to Ordinary
      • EmbeddedRocksDB & dictionary
      • MergeTree table engine family
        • CollapsingMergeTree vs ReplacingMergeTree
        • Part names & MVCC
        • Properly ordering and partitioning MergeTree tables
        • AggregatingMergeTree
        • index & column files
        • Merge performance and OPTIMIZE FINAL
        • Nulls in order by
        • ReplacingMergeTree
          • ReplacingMergeTree does not collapse duplicates
        • Skip index
        • SummingMergeTree
        • VersionedCollapsingMT
    • Queries & Syntax
      • GROUP BY
        • GROUP BY tricks
      • Adjustable table partitioning
      • DateTime64
      • DISTINCT & GROUP BY & LIMIT 1 BY what the difference
      • Imprecise literal Decimal or Float64 values
      • Multiple aligned date columns in PARTITION BY expression
      • Row policies overhead
      • Slow `SELECT count()`
      • trace_log
      • Using array functions to mimic window-functions alike behavior
      • -State & -Merge combinators
      • ALTER MODIFY COLUMN is stuck, the column is inaccessible.
      • ANSI SQL mode
      • Async INSERTs
      • Atomic insert
      • ClickHouse Projections
      • Cumulative Anything
      • Data types on disk and in RAM
      • DELETE via tombstone column
      • EXPLAIN query
      • Fill missing values at query time
      • FINAL clause speed
      • Join with Calendar using Arrays
      • JOINs
        • JOIN optimization tricks
      • JSONExtract to parse many attributes at a time
      • KILL QUERY
      • Lag / Lead
      • Machine learning in ClickHouse
      • Mutations
      • OPTIMIZE vs OPTIMIZE FINAL
      • Parameterized views
      • partial-projection-optimization
      • PIVOT / UNPIVOT
      • Possible deadlock avoided. Client should retry
      • Roaring bitmaps for calculating retention
      • SAMPLE by
      • Sampling Example
      • Simple aggregate functions & combinators
      • Skip indexes
        • Example: minmax
        • Skip index bloom_filter Example
        • Skip indexes examples
      • Time zones
      • Time-series alignment with interpolation
      • Top N & Remain
      • Troubleshooting
      • TTL
        • MODIFY (ADD) TTL
        • What are my TTL settings
        • TTL GROUP BY Examples
        • TTL Recompress example
      • UPDATE via Dictionary
      • Values mapping
      • Window functions
    • Functions
      • Encoding and Decoding of quantileTDigest states
      • kurt & skew
      • -Resample vs -If vs -Map vs Subquery
      • arrayFold
      • arrayMap, arrayJoin or ARRAY JOIN memory usage
      • assumeNotNull and friends
      • Encrypt
      • sequenceMatch
    • Integrations
      • Altinity Cloud Access Management
      • ClickHouse® python drivers
      • Integrating ClickHouse® with MySQL
      • ODBC Driver for ClickHouse®
      • Spark
      • BI Tools
      • CatBoost / MindsDB / Fast.ai
      • Google S3 (GCS)
      • Kafka
        • Schema Inference for Kafka
        • Setting the background message broker schedule pool size
        • Adjusting librdkafka settings
        • Error handling
        • Exactly once semantics
        • Kafka main parsing loop
        • Kafka parallel consuming
        • Multiple MVs attached to Kafka table
        • Rewind / fast-forward / replay
        • SELECTs from engine=Kafka
      • RabbitMQ
        • RabbitMQ Error handling
    • Setup & maintenance
      • S3 & object storage
        • AWS S3 Recipes
        • s3 and mutations
        • s3 cached table
        • S3Disk
      • AggregateFunction(uniq, UUID) doubled after ClickHouse® upgrade
      • Can not connect to my ClickHouse® server
      • cgroups and k8s
      • ClickHouse logs and Vector.dev
      • ClickHouse operator
      • ClickHouse® and different filesystems
      • ClickHouse® RBAC example
      • Compatibility layer for the Altinity Kubernetes Operator for ClickHouse®
      • Convert uniqExact to uniq(Combined)
      • Custom Settings
      • Description of asynchronous_metrics
      • disk encryption
      • DR two DC
      • How ALTERs work in ClickHouse®
      • How to recreate a table
      • http_handlers
      • Logging
      • Precreate parts using clickhouse-local
      • Recovery after complete data loss
      • Replication: Can not resolve host of another ClickHouse® server
      • source parts sizeis greater than the current maximum
      • Successful ClickHouse® deployment plan
      • sysall database
      • Timeouts during OPTIMIZE FINAL
      • Use an executable dictionary as cron task
      • Useful settings to turn on
      • Who ate my CPU
      • Zookeeper session has expired
      • Server config files
      • Aggressive merges
      • Altinity Backup for ClickHouse®
      • Altinity packaging compatibility >21.x and earlier
      • AWS EC2 Storage
      • ClickHouse® in Docker
      • ClickHouse® Monitoring
      • ClickHouse® versions
      • Configure ClickHouse® for low memory environments
      • Converting MergeTree to Replicated
      • Data Migration
        • Export from MSSQL to ClickHouse®
        • add_remove_replica
        • clickhouse-copier
          • clickhouse-copier 20.3 and earlier
          • clickhouse-copier 20.4 - 21.6
          • Kubernetes job for clickhouse-copier
        • Distributed table to cluster
        • Fetch Alter Table
        • Remote table function
        • rsync
      • DDLWorker
        • There are N unfinished hosts (0 of them are currently active).
      • differential backups using clickhouse-backup
      • High CPU usage
      • Load balancers
      • memory configuration settings
      • Memory Overcommiter
      • Moving a table to another device
      • Object consistency in a cluster
      • Production Cluster Configuration Guide
        • Backups
        • Cluster Configuration FAQ
        • Cluster Configuration Process
        • Hardware Requirements
        • Network Configuration
      • Regulating the size of System tables
    • Useful queries
      • Check table metadata in zookeeper
      • Compare query_log for 2 intervals
      • Debug hanging thing
      • Handy queries for system.query_log
      • Ingestion metrics from system.part_log
      • Remove block numbers from zookeeper for removed partitions
      • Removing tasks in the replication queue related to empty partitions
      • Can detached parts be dropped?
      • Database Size - Table - Column size
      • Number of active parts in a partition
      • Parts consistency
    • Schema design
      • ClickHouse limitations
      • ClickHouse® row-level deduplication
      • Column backfilling from dictionary
      • Functions to count uniqs
      • How to change ORDER BY
      • Ingestion of AggregateFunction
      • insert deduplication
      • JSONEachRow, tuple, map and MVs
      • Pre-Aggregation approaches
      • SnowflakeID
      • Two columns indexing
      • Best schema for storing many metrics registered from the single source
      • Codecs
        • Codecs on array columns
        • Codecs speed
        • How to test different compression codecs
      • Dictionaries vs LowCardinality
      • Flattened table
      • Floats vs Decimals
      • Ingestion performance and formats
      • IPs/masks
      • JSONAsString and Mat. View as JSON parser
      • LowCardinality
      • Materialized Views
        • Idempotent insert MV
        • Backfill/populate MV in a controlled manner
    • Using the Altinity Kubernetes Operator for ClickHouse®
    • Interfaces
      • clickhouse-client
    • Upgrade
      • Vulnerabilities
      • ClickHouse® Function/Engines/Settings Report
      • Removing empty parts
      • Removing lost parts
    • Dictionaries
      • Dictionaries & arrays
      • Dictionary on the top of several tables using VIEW
      • Dimension table design
      • Example of PostgreSQL dictionary
      • MySQL8 source for dictionaries
      • Partial updates
      • range_hashed example - open intervals
      • Security named collections
      • SPARSE_HASHED VS HASHED vs HASHED_ARRAY
    • Using This Knowledge Base
      • Mermaid Example
    • ClickHouse® Upgrade eBook
    • ClickHouse Cluster Maintenance eBook
Edit this page Create child page Create documentation issue Print entire section
Altinity®, Altinity.Cloud®, and Altinity Stable® are registered trademarks of Altinity, Inc. ClickHouse® is a registered trademark of ClickHouse, Inc.; Altinity is not affiliated with or associated with ClickHouse, Inc.
Hetzner logo

NEW: Our managed service for ClickHouse is on Hetzner Cloud. Come talk to us!
  1. Integrations
  2. BI Tools

BI Tools

Business Intelligence Tools
  • Superset: https://superset.apache.org/docs/databases/clickhouse
  • Metabase: https://github.com/enqueue/metabase-clickhouse-driver
  • Querybook: https://www.querybook.org/docs/setup_guide/connect_to_query_engines/#all-query-engines
  • Tableau: Altinity Tableau Connector for ClickHouse® support both JDBC & ODBC drivers
  • Looker: https://docs.looker.com/setup-and-management/database-config/clickhouse
  • Apache Zeppelin
  • SeekTable
  • ReDash
  • Mondrian: https://altinity.com/blog/accessing-clickhouse-from-excel-using-mondrian-rolap-engine
  • Grafana: Integrating Grafana with ClickHouse
  • Cumul.io
  • Tablum: https://tablum.io
Last modified 2024.07.30: Site cleanup, mostly minor changes (a4a9639)
Altinity.com
  • PRODUCT
  • Altinity.Cloud
  • Support for ClickHouse
  • Training for ClickHouse
  • Altinity.Cloud Pricing
  • Altinity Plans and Features
SOC CertifiedSOC2 TYPE II Certified
  • RESOURCES
  • Blog
  • Documentation
  • Knowledge Base
  • Altinity Stable Builds
  • Kubernetes Operator
  • Altinity Open Source Projects
  • Events
  • COMPANY
  • About Altinity
  • Press Releases
  • Partners
  • Customer Stories
  • Careers
  • Contact Us
Get the latest ClickHouse news straight to your inbox every month.
Sign Up
© 2025 Altinity Inc. Altinity®, Altinity.Cloud®, and Altinity Stable® are registered trademarks of Altinity, Inc. ClickHouse® is a registered trademark of ClickHouse, Inc.; Altinity is not affiliated with or associated with ClickHouse, Inc. Kafka, Kubernetes, MySQL, and PostgreSQL are trademarks and property of their respective owners. All Rights Reserved Privacy Policy