Artem Ervits

CORE

Principal Sales Engineer at Snowflake

Company website: https://www.snowflake.com/en/

Fort Lee, US

Joined Feb 2021

https://blog.ervits.com

About

The views expressed are my own and not necessarily of my employer.

Education
Open Source Projects

Education

Brooklyn College

Masters of Science in Information Systems

Sep 2004 - Jun 2007

Brooklyn College · Computer Science

Bachelors of Science

Sep 1998 - Jun 2003

Open Source Projects

Cockroach Docker

Nov 2019 - Current

Cockroach Docker turorials

Stats

Reputation:	2559
Pageviews:	449.1K
Articles:	73
Comments:	1

Expertise

Databases

Articles
Comments

Articles

Exploring Real-Time Data Ingestion Into Snowflake Using CockroachDB, Redpanda, and Kafka Connect

Explore Kafka Connect as a solution to stream changefeeds into Snowflake for greater control over how messages are delivered to Snowflake.

September 10, 2024

· 4,958 Views · 1 Like

Tour of Snowflake Ingestion Using CockroachDB and Redpanda Connect

This is an exploratory article delving into various ways to ingest real-time data into Snowflake and the levels of difficulty and effort required.

August 15, 2024

· 4,063 Views · 1 Like

Integrating Snowflake With Trino

Trino simplifies accessing Snowflake, highlighting its versatility in providing robust data management and analytics solutions for modern enterprises.

March 18, 2024

· 13,431 Views · 1 Like

Optimizing PgBench for CockroachDB Part 3

CockroachDB will support Read Committed isolation starting with the next release. I am going to test PgBench with RC in today's article.

December 1, 2023

· 4,869 Views · 2 Likes

Secure Schema Migrations With Flyway and CockroachDB Dedicated

In this article, explore a solution to TLS certificate issues and containerized schema migrations with Flyway and CockroachDB.

October 25, 2023

· 2,453 Views · 3 Likes

Emitting Protocol Buffers Using CockroachDB CDC Queries

Follow this demonstration using several recent features to demonstrate the ability to serialize CockroachDB rows to proto and emit via CDC Queries.

September 1, 2023

· 5,063 Views · 1 Like

CockroachDB TIL: Volume 13

Cover topics such as diagnosing cert issues and looking at client verification of server certificate differences in the cockroach and the psql clients.

August 31, 2023

· 2,362 Views · 1 Like

Using DuckDB With CockroachDB

Explore this fun experiment using DuckDB to parse CockroachDB Change Data Capture output and query CockroachDB with DuckDB.

May 21, 2023

· 1,954 Views · 1 Like

Reducing Network Latency and Improving Read Performance With CockroachDB and PolyScale.ai

This tutorial explores how to benefit from lowered latency, increased performance, and reduced infrastructure costs, as well as faster reads in more locations.

May 15, 2023

· 4,164 Views · 5 Likes

Load Balancer High Availability With CockroachDB and HAProxy

CockroachDB relies on a load balancer to provide client fault tolerance. Here, take a look at a load balancer as the single point of failure.

May 7, 2023

· 3,857 Views · 1 Like

Connection Pool High Availability With CockroachDB and PgCat

This article covers pooler high availability working with PgCat to provide a highly available configuration where clients can see multiple connections.

April 25, 2023

· 2,930 Views · 1 Like

CockroachDB TIL: Volume 12

Learn to find partial indexes, identify the DB Console URL with SQL, experiment with a lightweight pooler called pgcat, handle client disconnects, and more.

April 20, 2023

· 3,381 Views · 1 Like

Using CockroachDB CDC With Apache Pulsar

As of this writing, CockroachDB does not have a direct integration with Apache Pulsar. Here, integrate CockroachDB CDC with Pulsar via the existing Kafka sink.

April 12, 2023

· 8,376 Views · 3 Likes

Correcting My Misconceptions With REGIONAL BY ROW Tables

This tutorial will dive deeper into nuances with CockroachDB REGIONAL BY ROW tables. I learned the hard way about the limitations and to pay close attention to the documentation on the topic.

March 7, 2023

· 4,410 Views · 1 Like

Optimizing Pgbench for CockroachDB Part 1

I originally wrote an article on pgbench and CockroachDB in October of 2021. Today, we're going to return to the topic and discuss a few improvements.

Updated December 30, 2022

· 4,254 Views · 1 Like

Optimizing Pgbench for CockroachDB Part 2

I originally wrote an article on pgbench and CockroachDB in October of 2021. Today, I am going to continue talking about pgbench optimizations you can implement to make CockroachDB perform.

Updated December 30, 2022

· 4,047 Views · 1 Like

CockroachDB TIL: Volume 11

This is my series of articles covering short "Today I learned" topics as I work with CockroachDB. Today, we're covering auto-completion and syntax highlighting in CLI with pgcli, Sqlalchemy and ON UPDATE expressions, identifying sessions, naming transaction blocks and setting traces in CLI.

December 27, 2022

· 3,187 Views · 1 Like

Using Short-Lived Tokens To Authenticate Python Applications to CockroachDB

JWT tokens can replace passwords for a safer and more secure cloud-native future. Follow this tutorial to get JWT AuthN working with your Python application.

October 28, 2022

· 9,903 Views · 1 Like

Configure Single Sign On for CockroachDB CLI With Okta IdP

Today we're going to cover how to set up Single Sign On for CockroachDB CLI with Okta SSO using short-lived JWT tokens.

October 25, 2022

· 7,491 Views · 1 Like

CockroachDB TIL: Volume 10

Explore ULID and UUID generation, tab completion in the CLI, third-party IDEs like Postico and Serverless clusters, and more in this "today I learned" post.

October 18, 2022

· 4,709 Views · 1 Like

Using CockroachDB CDC With Azure Event Hubs

This tutorial is an attempt to integrate CockroachDB CDC with Azure Event Hubs via our existing Kafka support.

October 3, 2022

· 4,507 Views · 1 Like

Using CockroachDB Dedicated With Starburst Galaxy

In this article, we're going to look at connecting Starburst Galaxy, a Trino SaaS service running with CockroachDB Dedicated.

September 24, 2022

· 4,401 Views · 1 Like

CockroachDB Multi-Region Abstractions for MongoDB Developers With FerretDB

This is yet another part of an interesting experiment with FerretDB and CockroachDB. This time, we're going to expand on the previous articles by looking at the multi-region capabilities in CockroachDB.

September 21, 2022

· 3,355 Views · 1 Like

Experimenting With Unique Constraints in CockroachDB, MongoDB, and FerretDB

This is an unexpected third part of an interesting experiment with FerretDB and CockroachDB. This time, we're going to expand on the previous article.

September 14, 2022

· 4,464 Views · 2 Likes

Migrating MongoDB Collections to CockroachDB With FerretDB

In part 2 of an experiment with FerretDB and CockroachDB, restore a MongoDB collection into CockroachDB via FerretDB, and expand on previous learnings.

September 13, 2022

· 5,127 Views · 2 Likes

CockroachDB TIL: Volume 9

In this latest "Today I learned" post, audit schema change events, configure Linode Cloud Storage for CockroachDB bulk ops, and lots of DBeaver goodness.

September 1, 2022

· 5,284 Views · 3 Likes

CockroachDB TIL: Volume 8

In this "Today I learned" post, learn how to generate workload data for CockroachDB for offline use, decode hex data into human-readable form, and more.

Updated August 23, 2022

· 5,736 Views · 2 Likes

Using CockroachDB as a Backend for OSS MongoDB Alternative FerretDB

In today's tutorial, we are going to step away from the world of Postgres and production readiness topics and have some NoSQL fun using MongoDB API to persist data in CockroachDB.

August 18, 2022

· 4,221 Views · 2 Likes

CockroachDB TIL: Volume 7

Learn about CLI query stats, cloning schemas quickly, distinguishing which table IDs correspond to which table names, connecting to non-default databases, and copying columns between column families.

June 2, 2022

· 6,349 Views · 2 Likes

Using CockroachDB CDC with Confluent Cloud Kafka and Schema Registry

Follow along in this article as I document the steps required to set up CockroachDB CDC with Confluent Schema Registry.

April 21, 2022

· 3,825 Views · 2 Likes

Comments

Working With Multi-Level JSON in CockroachDB

Jul 28, 2021 · Lauren Forbes

thanks for the feedback, let me know if there's anything you'd like me to expand on