Altinity.com
  • Products
    • PRODUCTS
      Altinity.Cloud
      Managed cloud
      Deploy on Altinity’s cloud
      Bring your own cloud
      Any region, any environment
      Vendor comparison 
      Pricing 
      Support for ClickHouse®
      24/7 Support
      POC and Evaluative Support
      Training for ClickHouse®
      OPEN SOURCE SOFTWARE
      NEW Project Antalya Builds 
      Scale ClickHouse queries infinitely with 10X cheaper data lakes
      Altinity Stable Builds for ClickHouse® 
      LTS-certified binaries with 3 years’ support
      Altinity Kubernetes Operator for ClickHouse® 
      Manage ClickHouse clusters on Kubernetes effortlessly
      Altinity Backup for ClickHouse® 
      Simple backup and restore tool for ClickHouse
      See more > 
      CLICKHOUSE® SOLUTIONS
      Observability & Logging 
      Manage high-volume observability data efficiently
      Security Information and Event Management (SIEM) 
      Efficiently process and analyze high-volume security events
      Trading Analytics 
      Make faster market decisions
      Customer stories 
      See why our customers love us
      Altinity Plans and Features 
      Managed service or support? Compare plans and features
  • Resources
    • Developer Center

      Documentation 
      Product guides and tutorials

      Knowledge Base 
      Answers to common questions and issues

      Past Webinars 
      Watch anytime, on demand.

      More Technical Content 
      How-to guides and videos

      Learning

      What is ClickHouse? 
      New to ClickHouse? Start here

      Kubernetes Operator 
      Learn how it works and who uses it

      Unevenly Distributed 
      A Thought Leadership Series on Real-Time Data Lakes

      Altinity Stable Builds 
      Learn why you should be using them in your prod environments

      Community

      Open Source at Altinity 
      Explore our open source projects and contributions

      Events 
      Upcoming conferences, events, and webinars

      Slack Community 
      Get help for any ClickHouse issue from experts

      Monthly Office Hours 
      Meet our engineers live and ask your questions

  • Blog
  • Company
    • About the company  
      Leadership 
      Press Releases 
      Partners 
      Customer Stories 
      Careers 
      Get in touch with ClickHouse experts.
      Contact Us 
  • Contact
  • Tech Support ClickHouse® in Cloud YouTube Github
  • Products
    • Altinity.Cloud
      • Pricing for ClickHouse
      • Altinity.Cloud vs ClickHouse Cloud FAQ
      • Support for ClickHouse
      • Training for ClickHouse
    • Open Source Software
      • Project Antalya
      • Altinity Stable Builds
      • Kubernetes Operator
      • Altinity Backup for ClickHouse
    • ClickHouse™ Solutions
      • Observability & Logging with ClickHouse®
      • Security Information and Event Management (SIEM) with ClickHouse®
      • Trading analytics with ClickHouse®
  • Resources
    • Developer Center
      • Documentation
      • Knowledge Base
      • Past Webinars
      • Guides and eBooks
    • Learning
      • What is ClickHouse?
      • What is Kubernetes?
      • Unevenly Distributed
      • Altinity Stable Builds
    • Community
      • Events
      • Slack Community
      • Office Hours for ClickHouse®
  • Blog
  • Company
    • About Altinity
    • Leadership
    • Press Releases
    • Partners
    • Customer Stories
    • Careers
  • Contact
  • Tech Support
  • ClickHouse® in Cloud
  • 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
        • Kafka virtual columns
        • 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
        • Clean up orphaned objects on s3
        • 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
      • Client Timeouts
      • 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
      • Jemalloc heap profiling
      • Logging
      • Merge Memory in metric_log
      • 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 and DDL queue problems
        • 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
    • 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
      • Notes on Various Errors with respect to replication and distributed connections
      • 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®
      • Istio Issues
    • 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 TTLs in Practice (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.
Project Antalya
Build Real‑Time Data Lakes with ClickHouse® and Apache Iceberg
Learn more
  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
© 2026 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