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

Runbook for Migration from Snowflake to ChistaDATA Cloud for ClickHouse: Part 1

ChistaDATA Inc.

Introduction Snowflake is a fully managed SaaS (Software as a service) used for data warehousing, data engineering, data lakes, and data science applications. Snowflake is a proven cloud-based data platform, and it is one of […]

Overview of Key Features of ChistaDATA’s ClickHouse DBaaS

ChistaDATA Inc.

Introduction As the ChistaDATA team, we keep our DBaaS environment up-to-date, arrange bug fixes and release new releases. In this blog post, we will talk about the latest updates. You want to ensure your ClickHouse […]

Migrating MSSQL Database to ClickHouse

ChistaDATA Inc.

In the previous article, We discussed migrating from Oracle to the ClickHouse database. This migration technology tool will soon be available in the ChistaDATA DBaaS, and you can enjoy the advantages of ClickHouse database with […]

ClickHouse Release Notes – v23.5 (May 2023)

ChistaDATA Inc.

Introduction We greatly appreciate the ClickHouse team’s consistent efforts in delivering monthly releases packed with new features, improvements, and valuable bug fixes. At ChistaData, we diligently conduct Quick Peek analyses on each release and publish […]

Leveraging ClickHouse for Real-time Analytics on Blockchain Data

ChistaDATA Inc.

Introduction With one of our proof-of-concepts (POC), we have implemented ClickHouse to handle Ethereum blockchain transaction data for processing purposes. Through the cumulative aggregation and analysis of this data, we can extract valuable insights […]

Migrating Oracle Database to ClickHouse

ChistaDATA Inc.

In previous article we talked about migrating from OLTP databases to the ClickHouse database. This migration technology tool will soon be available in the ChistaDATA DBaaS and you can enjoy the advantages of ClickHouse database […]

Best Practices for ClickHouse’s Role Based Access Control

ChistaDATA Inc.

Role-based access control (RBAC) is a method of restricting access to a resource based on the roles of the users within an organization. RBAC can ensure that the users are allowed to access the resource […]

In this article, we delve into how ClickHouse supports sharding via a distributed via distributed table engine and the basics of sharding and distributed engines

ClickHouse Horizontal Scaling: Sharding and Resharding Strategies

ChistaDATA Inc.

Introduction Sharding is a process in which a large database table is divided horizontally into smaller ones (with same schema/columns) and stored across different nodes. ClickHouse supports sharding via distributed table engine. You can […]

Comprehensive Guide to ClickHouse EXPLAIN

ChistaDATA Inc.

Introduction Have you ever pondered over how database engines handle queries and optimize their execution? Have you ever wondered which queries are responsible for slowing down your database? Are you curious to know who is […]

ClickHouse Horizontal Scaling: Implementing Parallel Replicas with Dynamic Shards

ChistaDATA Inc.

Introduction ClickHouse is known for its exceptional performance, scalability, and flexibility. With its ability to handle massive amounts of data and process queries in real-time, ClickHouse is becoming increasingly popular among data analysts, developers, and […]