{% include {{ include.sql_file }} %}

Blog

Explore technical tips and topics from Firebolt experts and the community.

Blog

June 13, 2025

Live Engine Upgrades, Zero Downtime: The Firebolt Method

Discover how Firebolt delivers seamless, no-downtime upgrades using shadow clusters and real-time performance.

Ilya Shakhat

Thank you! Your submission has been received!

Oops! Something went wrong while submitting the form.

Engineering

September 16, 2024

Caching & Reuse of Subresults across Queries

Deep dive into how Firebolt optimizes query performance through caching and reusing results of parts of the query plan.

Alex Hall

Engineering

September 13, 2024

Engines: Online Scaling and Upgrades

Uncover Firebolt’s Engine internals featuring zero-downtime upgrades, multi-dimensional elasticity, and granular scaling

Artem Grachev

September 13, 2024

A primer on analyzing semi-structured data

This guide will provide you with the fundamental knowledge necessary to handle semi-structured data effectively.

Firebolt Team

Engineering

September 11, 2024

Making a Query Engine Postgres Compliant Part I - Functions

Technical deep dive on how Firebolt evolved into a PostgreSQL-compliant database system.

Benjamin Wagner

Customer Blogs

August 20, 2024

How we serve data from millions of gaming channels to 50K customers using Firebolt

Read on to find out how Lurkit is using Firebolt over AWS to serve advanced gaming analytics

Tom Niskanen

Product

August 12, 2024

Right size your engines and achieve unparalleled price-performance with firebolt’s granular scaling

Scale one node at a time to adjust compute resources incrementally, ensuring an ideal price-performance ratio.

Krishna Thotapalli

Product

August 2, 2024

Announcing Firebolt Engines: Next-Generation Compute Infrastructure for Cloud Data Warehousing

Firebolt Inc., a cloud data warehouse provider, announced its next-generation compute infrastructure, Engines.

Krishna Thotapalli

November 19, 2023

The key is in the key.

One of the more common and costly mistakes in the many data implementations is confusion about keys.

Robert Harmon

November 19, 2023

Simplifying time variance in a SQL data warehouse

An issue many coming into the data warehouse world is difficulty with is managing time variance at scale and efficiency.

Robert Harmon

November 19, 2023

"Do data architects exist anymore?"

"Do data architects exist anymore?" Wow, as a recovering data architect that's a loaded question.

Robert Harmon

November 14, 2023

Who's down with OBT? I can assure you, not me.

I'm not a fan of dimensional modeling. It exists to solve physical problems, not logical problems.

Robert Harmon

November 5, 2023

Rob's high performance data warehousing rule #4: Delete nothing, update only metadata.

Rob says: delete nothing, update only metadata.

Robert Harmon

We use cookies to give you a better online experience

Blog

Live Engine Upgrades, Zero Downtime: The Firebolt Method

Caching & Reuse of Subresults across Queries

Engines: Online Scaling and Upgrades

A primer on analyzing semi-structured data

Making a Query Engine Postgres Compliant Part I - Functions

How we serve data from millions of gaming channels to 50K customers using Firebolt

Right size your engines and achieve unparalleled price-performance with firebolt’s granular scaling

Announcing Firebolt Engines: Next-Generation Compute Infrastructure for Cloud Data Warehousing

The key is in the key.

Simplifying time variance in a SQL data warehouse

"Do data architects exist anymore?"

Who's down with OBT? I can assure you, not me.

Rob's high performance data warehousing rule #4: Delete nothing, update only metadata.