Articles by ChistaDATA Inc.

About ChistaDATA Inc.

We are an full-stack ClickHouse infrastructure operations Consulting, Support and Managed Services provider with core expertise in performance, scalability and data SRE. Based out of California, Our consulting and support engineering team operates out of San Francisco, Vancouver, London, Germany, Russia, Ukraine, Australia, Singapore and India to deliver 24*7 enterprise-class consultative support and managed services. We operate very closely with some of the largest and planet-scale internet properties like PayPal, Garmin, Honda cars IoT project, Viacom, National Geographic, Nike, Morgan Stanley, American Express Travel, VISA, Netflix, PRADA, Blue Dart, Carlsberg, Sony, Unilever etc

Tuning Index Granularity for ClickHouse in E-commerce

Tuning Index Granularity for ClickHouse Performance in E-commerce

ChistaDATA Inc.

Introduction In the world of data analytics and storage, databases are the backbone that supports businesses’ decision-making processes. ClickHouse, an open-source columnar database management system, has gained popularity for its exceptional speed and efficiency in […]

Implementing Branching on ChistaDATA Cloud for ClickHouse

ChistaDATA Inc.

Introduction In the world of modern software development, managing data efficiently and effectively is crucial for maintaining a successful and scalable application. One of the techniques that has gained popularity in recent years is […]

Runbook for Migration from Amazon Redshift to ChistaDATA Cloud for ClickHouse: Part 1

ChistaDATA Inc.

Introduction Amazon Redshift is a proprietary cloud data warehouse offered by AWS. It is based on PostgreSQL but with modifications. Amazon RedShift is an OLAP data store, whereas PostgreSQL is an OLTP database system. […]

ClickHouse Summer 2023 Release – Version 23.7

ChistaDATA Inc.

Introduction Each new release includes new features, improvements, and numerous bug fixes, and the ChistaDATA team is always on top of the latest releases. On 27th July 2023, ClickHouse version 23.7 (July 2023) was released, […]

Temporary Tables & Parameterized Views In ClickHouse

ClickHouse’s Solutions: Alternatives to Table-Valued Parameters for Dynamic Data Handling

ChistaDATA Inc.

Introduction Have you ever wondered how SQL databases handle dynamic data manipulation and filtering? Table-Valued Parameters are the remarkable feature that empowers us to do just that. Allowing entire tables or arrays as parameters […]

ClickHouse MergeTree: Understanding Storage Policies and Load Balancing

ChistaDATA Inc.

Introduction Optimizing data distribution and storage utilization is paramount when working with MergeTree tables in ClickHouse. This involves understanding and leveraging storage policies and load balancing mechanisms to ensure efficient data placement across disks and […]