Use Iceberg Catalogs
beta
To read from the Redpanda-generated Iceberg table, your Iceberg-compatible client or tool needs access to the catalog to retrieve the table metadata and know the current state of the table. The catalog provides the current table metadata, which includes locations for all the table’s data files. You can configure Redpanda to either connect to a REST-based catalog, or use a filesystem-based catalog.
The Iceberg integration for Redpanda Cloud is a beta feature. It is not supported for production deployments. To configure REST catalog authentication for use with Iceberg topics in your cloud cluster, contact Redpanda support. |
For production deployments, Redpanda recommends using an external REST catalog to manage Iceberg metadata. This enables built-in table maintenance, safely handles multiple engines and tools accessing tables at the same time, facilitates data governance, and maximizes data discovery. However, if it is not possible to use a REST catalog, you may use the filesystem-based catalog (object_storage
catalog type), which does not require you to maintain a separate service to access the Iceberg data. In either case, you use the catalog to load, query, or refresh the Iceberg table as you produce to the Redpanda topic. See the documentation for your query engine or Iceberg-compatible tool for specific guidance on adding the Iceberg tables to your data warehouse or lakehouse using the catalog.
After you have selected a catalog type at the cluster level and enabled the Iceberg integration for a topic, you cannot switch to another catalog type.
Connect to a REST catalog
Connect to an Iceberg REST catalog using the standard REST API supported by many catalog providers. Use this catalog integration type with REST-enabled Iceberg catalog services, such as Databricks Unity and Snowflake Open Catalog.
To connect to a REST catalog, set the following cluster configuration properties:
-
iceberg_catalog_type
:rest
-
iceberg_rest_catalog_endpoint
: The endpoint URL for your Iceberg catalog, which you either manage directly, or is managed by an external catalog service. -
iceberg_rest_catalog_authentication_mode
: The authentication mode to use for the REST catalog. Choose fromoauth2
,bearer
, ornone
(default).-
For
oauth2
, also configure the following properties:-
iceberg_rest_catalog_oauth2_server_uri
: The OAuth endpoint URI used to retrieve tokens for REST catalog authentication. If left unset, the deprecated catalog endpoint/v1/oauth/tokens
is used as the token endpoint instead. -
iceberg_rest_catalog_client_id
: The ID used to query the OAuth token endpoint for REST catalog authentication. -
iceberg_rest_catalog_client_secret
: The secret used with the client ID to query the OAuth token endpoint for REST catalog authentication.
-
-
For
bearer
, configure theiceberg_rest_catalog_token
property with your bearer token.Redpanda uses the bearer token unconditionally and does not attempt to refresh the token. Only use the bearer authentication mode for ad hoc or testing purposes.
-
For REST catalogs that use self-signed certificates, also configure these properties:
-
iceberg_rest_catalog_trust
: The contents of a certificate chain to trust for the REST catalog. -
iceberg_rest_catalog_crl
: The contents of a certificate revocation list foriceberg_rest_catalog_trust
.
See Cluster Configuration Properties for the full list of cluster properties to configure for a catalog integration.
Store a secret for REST catalog authentication
To store a secret that you can reference in your catalog authentication cluster properties, you must create the secret using rpk
or the Data Plane API. Secrets are stored in the secret management solution of your cloud provider. Redpanda retrieves the secrets at runtime.
For more information, see Introduction to rpk and Redpanda Cloud API Overview.
If you need to configure any of the following properties, you must set their values using secrets:
-
iceberg_rest_catalog_client_secret
-
iceberg_rest_catalog_crl
-
iceberg_rest_catalog_token
-
iceberg_rest_catalog_trust
To create a new secret:
-
rpk
-
Cloud API
Run the following rpk
command:
rpk security secret create --name <secret-name> --value <secret-value> --scopes redpanda_cluster
-
Authenticate and make a
GET /v1/clusters/{id}
request to retrieve the Data Plane API URL for your cluster. -
Make a request to
POST /v1/secrets
. You must use a Base64-encoded secret.curl -X POST "https://<dataplane-api-url>/v1/secrets" \ -H 'accept: application/json'\ -H 'authorization: Bearer <token>'\ -H 'content-type: application/json' \ -d '{"id":"<secret-name>","scopes":["SCOPE_REDPANDA_CLUSTER"],"secret_data":"<secret-value>"}'
bashYou must include the following values:
-
<dataplane-api-url>
: The base URL for the Data Plane API. -
<token>
: The API key you generated during authentication. -
<secret-name>
: The name of the secret you want to add. The secret name is also its ID. Use only the following characters:^[A-Z][A-Z0-9_]*$
. -
<secret-value>
: The Base64-encoded secret. -
This scope:
"SCOPE_REDPANDA_CLUSTER"
.
The response returns the name and scope of the secret.
-
You can now reference the secret in your cluster configuration.
Use a secret in cluster configuration
To set the cluster property to use the value of the secret, use rpk
or the Control Plane API.
For example, to use a secret for the iceberg_rest_catalog_client_secret
property, run:
-
rpk
-
Cloud API
rpk cluster config set iceberg_rest_catalog_client_secret ${secrets.<secret-name>}
Make a request to the PATCH /v1/clusters/<cluster-id>
endpoint of the Control Plane API.
curl -H "Authorization: Bearer <token>" -X PATCH \
"https://api.cloud.redpanda.com/v1/clusters/<cluster-id>" \
-H 'accept: application/json'\
-H 'content-type: application/json' \
-d '{"cluster_configuration": {
"custom_properties": {
"iceberg_rest_catalog_client_secret": "${secrets.<secret-name>}"
}
}
}'
You must include the following values:
-
<cluster-id>
: The ID of the Redpanda cluster. -
<token>
: The API key you generated during authentication. -
<secret-name>
: The name of the secret you created earlier.
Example REST catalog configuration
Suppose you configure the following Redpanda cluster properties for connecting to a REST catalog:
iceberg_catalog_type: rest
iceberg_rest_catalog_endpoint: http://catalog-service:8181
iceberg_rest_catalog_authentication_mode: oauth2
iceberg_rest_catalog_client_id: <rest-connection-id>
iceberg_rest_catalog_client_secret: <rest-connection-secret>
If you use Apache Spark as a processing engine, your Spark configuration might look like the following. This example uses a catalog named streaming
:
spark.sql.catalog.streaming = org.apache.iceberg.spark.SparkCatalog
spark.sql.catalog.streaming.type = rest
spark.sql.catalog.streaming.uri = http://catalog-service:8181
# You may need to configure additional properties based on your object storage provider.
# See https://iceberg.apache.org/docs/latest/spark-configuration/#catalog-configuration and https://spark.apache.org/docs/latest/configuration.html
# For example, for AWS S3:
# spark.sql.catalog.streaming.io-impl = org.apache.iceberg.aws.s3.S3FileIO
# spark.sql.catalog.streaming.warehouse = s3://<bucket-name>/
# spark.sql.catalog.streaming.s3.endpoint = http://<s3-uri>
Redpanda recommends setting credentials in environment variables so Spark can securely access your Iceberg data in object storage. For example, for AWS, use AWS_ACCESS_KEY_ID and AWS_SECRET_ACCESS_KEY .
|
The Spark engine can use the REST catalog to automatically discover the topic’s Iceberg table. Using Spark SQL, you can query the Iceberg table directly by specifying the catalog name, the namespace, and the table name:
SELECT * FROM streaming.redpanda.<table-name>;
The Iceberg table name is the name of your Redpanda topic. Redpanda puts the Iceberg table into a namespace called redpanda
, creating the namespace if necessary.
Integrate filesystem-based catalog (object_storage
)
By default, Iceberg topics use the filesystem-based catalog (iceberg_catalog_type
cluster property set to object_storage
). Redpanda stores the table metadata in HadoopCatalog format in the same object storage bucket or container as the data files.
If using the object_storage
catalog type, you provide the object storage URI of the table’s metadata.json
file to an Iceberg client so it can access the catalog and data files for your Redpanda Iceberg tables.
The metadata.json file points to a specific Iceberg table snapshot. In your query engine, you must update your tables whenever a new snapshot is created so that they point to the latest snapshot. See the official Iceberg documentation for more information, and refer to the documentation for your query engine or Iceberg-compatible tool for specific guidance on Iceberg table update or refresh.
|
Example filesystem-based catalog configuration
To configure Apache Spark to use a filesystem-based catalog, specify at least the following properties:
spark.sql.catalog.streaming = org.apache.iceberg.spark.SparkCatalog
spark.sql.catalog.streaming.type = hadoop
# URI for table metadata: AWS S3 example
spark.sql.catalog.streaming.warehouse = s3a://<bucket-name>/redpanda-iceberg-catalog
# You may need to configure additional properties based on your object storage provider.
# See https://iceberg.apache.org/docs/latest/spark-configuration/#spark-configuration and https://spark.apache.org/docs/latest/configuration.html
# For example, for AWS S3:
# spark.hadoop.fs.s3.impl = org.apache.hadoop.fs.s3a.S3AFileSystem
# spark.hadoop.fs.s3a.endpoint = http://<s3-uri>
# spark.sql.catalog.streaming.s3.endpoint = http://<s3-uri>
Redpanda recommends setting credentials in environment variables so Spark can securely access your Iceberg data in object storage. For example, for AWS, use AWS_ACCESS_KEY_ID and AWS_SECRET_ACCESS_KEY .
|
Depending on your processing engine, you may need to also create a new table to point the data lakehouse to the table location.