Technical Deep Dive: Automated Column Statistics · Product
Firebolt’s automated column statistics keep optimizer insights up to date, improving query plans and performance automatically—no query changes required.
Blog
Explore technical tips and topics from Firebolt experts and the community.
Technical Deep Dive: Efficient and ACID Compliant Vector Search Indexes in Firebolt · Product
Technical Deep Dive: Efficient and ACID Compliant Vector Search Indexes in Firebolt
Pruning even more data with late materialization · Product
Learn how Late Materialization speeds up top-K queries by delaying column scans.
FuzzBerg: Hunting Bugs in Iceberg and file-format readers · Product
Firebolt FuzzBerg to accelerate security testing of Iceberg and other file based readers.
Firebolt ARM Rollout · Product
Firebolt ARM Rollout; optimising price performance
Implementing Explicit Multi-Statement Transactions in a Stateless, Cloud-Native Architecture · Product
Firebolt supports explicit, multi-statement transactions using BEGIN, COMMIT, and ROLLBACK syntax while maintaining ACID compliance and stateless architecture.
Implementing Firebolt MERGE Statement · Product
Technical deep dive on the powerful MERGE SQL command, enabling simultaneous operations on a single table.
Automatic Cache Warmup · Product
Faster queries from the start with smart cache loading on engine boot, upgrade, and scale
Firebolt Auror · Product
Firebolt built Auror to securely validate container images with low latency in Kubernetes clusters.
Eliminating Redundant Joins in Firebolt for Faster SQL · Product
Firebolt removes redundant joins to boost SQL performance and optimize complex subqueries.
Firing Up Firebolt’s Client Ecosystem · Product
This features enables users to not use precious resources on just maintaining a connection when in fact their client is not doing anything.
Introducing Firebolt Core - Self-Hosted Firebolt, For Free, Forever · Product
Firebolt's CTO and VP of Engineering discuss the launch of Firebolt's self-managed version, Firebolt Core.
Making Firebolt Fast By Doing Practically Nothing · Product
Hear about the different methods deployed in Firebolt for reducing the number of scanned rows (aka pruning).
Live Engine Upgrades, Zero Downtime: The Firebolt Method · Product
Discover how Firebolt delivers seamless, no-downtime upgrades using shadow clusters and real-time performance verification to ensure peak reliability.
Querying Apache Iceberg with Sub-Second Performance · Product
Firebolt's new READ_ICEBERG capability does a lot of heavy lifting to provide low-latency access to your Iceberg tables.
Exploring your data lake in Firebolt using just TVFs · Product
Discover how Firebolt implements SQL functions for data exploration.
Unlock Conversational Data Interaction: Firebolt MCP Server for Advanced LLM Integration · Product
Connect Firebolt to AI tools like Claude and Copilot using the new MCP Server to streamline workflows, run smart queries, and boost data engineering efficiency.
Decomposing Firebolt transactions · Product
Explore how Firebolt's transaction system maps to the four essential steps—Execute, Validate, Order, Persist. Learn how Firebolt uses MVCC, OCC, and Foundation
Robust and efficient geospatial operations using snap rounding (Part III) · Product
We will explore in more detail how Firebolt implements robust operations on geospatial data.
Architecture and Internal Representation of the GEOGRAPHY Data Type (Part II) · Product
Explore how Firebolt processes & optimizes GEOGRAPHY data using S2 cells, shape indexes, and query pruning for peak performance.
Building Geospatial Support in Firebolt (Part-I) · Product
Implementing fast geospatial queries in Firebolt using the S2 Geometry Library.
Firebolt’s zero-copy clone · Product
Discover Firebolt’s Zero-Copy Clone feature: a cost-efficient way to clone massive tables instantly without duplicating data.
Fuzzing Firebolt: Catching 0-days as fast as our query processor · Product
Learn how Firebolt identifies zero-day vulnerabilities as efficiently as its query processor.
How we built Firebolt · Product
Gain insights into how Firebolt was built to redefine cloud data performance and scalability.
Caching & Reuse of Subresults across Queries · Product
Enhance query performance with Firebolt's caching and subresult reuse features.
Making a Query Engine Postgres Compliant Part I - Functions · Product
Learn about making a query engine Postgres-compliant in part one of this in-depth series.
Engines: Online Scaling and Upgrades · Product
Firebolt engines provide multi-dimensional elasticity to our customers allowing them to achieve desired price-performance without causing downtime for customers