Iceberg functions

For an overview of querying, tuning, and exporting Iceberg tables, see the Iceberg guide.

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

Read Iceberg tables ad hoc with the READ_ICEBERG table-valued function, register them in Firebolt’s catalog with CREATE ICEBERG TABLE, or mount an entire catalog with CREATE ICEBERG DATABASE. For how to choose between these approaches and tune them, see the Iceberg guide.

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