Iceberg functions

Iceberg functions provide utilities for working with Apache Iceberg tables. These functions include table-valued functions for reading Iceberg data and partition transform functions that implement the Iceberg partition transforms specification.

Reading Iceberg data

You can register an Iceberg table in Firebolt’s catalog using CREATE ICEBERG TABLE and then query it like a regular table:

SELECT * FROM my_iceberg_table LIMIT 5;

Alternatively, use the READ_ICEBERG table-valued function to query Iceberg tables ad hoc without registering them:

SELECT * 
FROM READ_ICEBERG(
  LOCATION => 'my_iceberg_location',
  MAX_STALENESS => INTERVAL '30 seconds'
) 
LIMIT 5;

Partition transform functions

Iceberg partition transform functions compute partition values according to the Iceberg specification. These functions can be used in the PARTITION BY clause of CREATE ICEBERG TABLE commands.

SELECT 
  iceberg_year('2025-12-15'::DATE) AS year_partition,
  iceberg_month('2025-12-15'::DATE) AS month_partition,
  iceberg_day('2025-12-15'::DATE) AS day_partition;

Returns:

year_partition	month_partition	day_partition
55	671	20437

Available functions

Table-valued functions:

READ_ICEBERG - Read data from Iceberg tables

Partition transform functions:

ICEBERG_YEAR - Extract year as years from 1970
ICEBERG_MONTH - Extract month as months from 1970-01-01
ICEBERG_DAY - Extract day as days from 1970-01-01
ICEBERG_HOUR - Extract hour as hours from 1970-01-01 00:00:00
ICEBERG_BUCKET - Hash value into a bucket
ICEBERG_TRUNCATE - Truncate value to a width

What is Firebolt?

Overview

Self-Managed

Performance and Observability

Guides

SQL reference

General reference

API reference

Legal

Iceberg functions