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

Use the READ_ICEBERG table-valued function to query data from Iceberg tables stored in file-based catalogs or REST catalogs.

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

Performance and Observability

Guides

SQL reference

General reference

API reference

Iceberg functions