databricks

SEPTEMBER 18, 2023

We are thrilled to introduce the support of a new SQL feature in Apache Spark and Databricks: Lateral Column Alias (LCA). This feature.

SQL 109

SQL Engineering Data 109

Rockset

OCTOBER 11, 2022

In this blog, we’ll compare and contrast how Elasticsearch and Rockset handle data ingestion as well as provide practical techniques for using these systems for real-time analytics. If dynamic typing is used as the index type, then Elasticsearch does support some schema changes such as adding fields, removing fields and changing types.

Data Ingestion 52

Data Ingestion Kafka Relational Database PostgreSQL 52

dbt Developer Hub

NOVEMBER 3, 2022

In this blog post we’ll dive into how we tackled one source of quality issues: directly relying on upstream database schemas. Modern ETL tools like Fivetran and Stitch can flexibly handle schema changes - for example, if a new column is created they can propagate that creation to Snowflake. Each column is a variant type in Snowflake.

Kafka 52

Kafka ETL Tools BI Database 52

Rockset

MAY 6, 2020

Rockset Patch API Rockset recently introduced a Patch API method, which enables users to stream complex CDC changes to Rockset with low-latency inserts and updates that trigger incremental indexing, rather than a complete reindexing of the document. In this blog, I’ll discuss the benefits of Patch API and how Rockset makes it easy to use.

MongoDB 40

MongoDB Bytes Database Relational Database 40

DoorDash Engineering

APRIL 12, 2023

Building a metrics layer that works for experimentation is not simple, as it should support different types of metrics of varying scale that are used across the diverse range of A/B tests that are being run across different products. It exposes a set of columns as measures or dimensions.

SQL 82

SQL Metadata Raw Data Government 82