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

ClickHouse March 2023 Release – Version 23.3

ChistaDATA Inc.

Introduction ClickHouse, the open-source, columnar-oriented, distributed SQL database management system, is known for its high-performance analytics and data processing capabilities. With each release, ClickHouse continues to evolve and introduce new features to enhance its functionality […]

Replicating Data across ClickHouse Servers

clickhouse-copier – A reliable workhorse for copying data across ClickHouse servers

ChistaDATA Inc.

Introduction ClickHouse comes with useful tools for performing various tasks. clickhouse-copier is one among them and as the name suggests, it is used for copying data from one ClickHouse server to another. The servers can […]

Connect to ChistaDATA DBaaS ClickHouse Cluster via DBeaver

ChistaDATA Inc.

ClickHouse is renowned for its impressive performance and scalability as an open-source columnar database management system. With its versatility and power, ClickHouse is a go-to choice for data-intensive applications. If you have a ClickHouse instance […]

Implementing Inverted Indexes in ClickHouse for Fast Search: Part 1

ChistaDATA Inc.

Introduction ClickHouse’s MergeTree table engine uses sparse indexing for its primary index and data-skipping indices as a secondary index. These indices are used to speed up the data retrieval from the disk. More recently, ClickHouse […]

Connecting ChistaDATA's ClickHouse Cloud with Java

Connecting ChistaDATA Cloud for ClickHouse with Java

ChistaDATA Inc.

Introduction Database as a Service (DBaaS) is a managed service offered by the cloud that allows access to databases without the demand for physical hardware setup, software installation, or database setup. The ChistaDATA DBaaS […]

Streaming Data from PostgreSQL to ClickHouse using Kafka and Debezium – Part 2

ChistaDATA Inc.

Introduction As we mentioned in the previous article in this series, migrating data from OLTP to OLAP is possible. This tutorial shows you how to set up a Postgres Docker image for usage with Debezium […]

Data Visualization using Apache Superset in ClickHouse Cloud

ChistaDATA Cloud DBAAS : Performing data exploration and visualisation using Apache Superset – Part 2

ChistaDATA Inc.

Introduction In the previous part of this series, we had seen the steps to connect to a ClickHouse database server running on ChistaDATA cloud DBAAS from an Apache Superset application. In this part, we […]

ChistaDATA Cloud DBAAS : Performing data exploration and visualisation using Apache Superset – Part 1

ChistaDATA Inc.

Introduction Apache Superset is an open-source software and a top level project at Apache Software foundation. It is an application for data exploration and data visualization which is designed to handle data at petabyte scale. […]

Get Started with ChistaDATA's ClickHouse Cloud: Part 2

Get Started with ChistaDATA Cloud

ChistaDATA Inc.

Introduction ChistaData Cloud is a state-of-the-art, zero-maintenance Database as a Service (DBaaS) for ClickHouse®. It provides an all-inclusive infrastructure service that simplifies the creation, operation, and scaling of ClickHouse® databases. The service is backed by […]

Connecting ChistaDATA Cloud for ClickHouse with Python

ChistaDATA Inc.