> ## Documentation Index
> Fetch the complete documentation index at: https://docs.e6data.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Connect to an Iceberg REST catalog using OAuth client credentials

> Register an Iceberg REST catalog in Unified and read an existing table with

How-to guideApplies to: Unified engine deployments

Register an Iceberg REST catalog in Unified and read an existing table with
OAuth client credentials.

## Before you start

Use an existing catalog with at least one readable Iceberg table. The engine and
workers must reach the catalog and its table storage. Have the remote identity
and permissions ready before creating the Unified registration. Replace the
namespace and table with one you know has data.

Collect the service catalog API URI and its warehouse and prefix requirements.
Confirm which authentication method its administrator has enabled.

The service must return usable temporary storage credentials, or the table
location must already have configured storage access in Unified. Requesting
delegation alone does not grant access. Local secret values require the
[encrypted secret store](https://docs.e6data.com/transformation/operations/configuration/secrets.md).

## Values to collect

* Catalog API URI, warehouse, namespace, and table.
* Client ID, client secret, token endpoint, and granted scope.

## Run the SQL

Replace every `<placeholder>` before running. Use unused names for the resources
below. Run the statements in order in Workbench.

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
CREATE SECRET recipe_iceberg_rest_oauth_secret AS '<client-secret>';

CREATE CREDENTIAL recipe_iceberg_rest_oauth_auth USING oauth2
OPTIONS (
  'authentication' = 'client_credentials',
  'client_id' = '<client-id>',
  'token_endpoint' = '<token-endpoint>'
)
SECRETS ('client_secret' = 'recipe_iceberg_rest_oauth_secret');

CREATE CATALOG recipe_iceberg_rest_oauth USING `iceberg-rest`
OPTIONS (
  'uri' = '<catalog-api-uri>',
  'warehouse' = '<warehouse>',
  'header.x-iceberg-access-delegation' = 'vended-credentials',
  'auth.type' = 'oauth2',
  'oauth2-server-uri' = '<token-endpoint>',
  'scope' = '<granted-scope>'
)
CREDENTIALS ('auth' = 'recipe_iceberg_rest_oauth_auth');

SELECT *
FROM recipe_iceberg_rest_oauth.`<namespace>`.`<table>`
LIMIT 5;
```

## Check the result

The SELECT should return up to five rows from the chosen table. Use a nonempty
table for this check. This verifies both metadata and table-file access;
creating the registration alone does not verify either.

## Clean up

This removes only the Unified registrations. It leaves the remote catalog and
its tables in place.

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
DROP CATALOG recipe_iceberg_rest_oauth;
DROP CREDENTIAL recipe_iceberg_rest_oauth_auth;
DROP SECRET recipe_iceberg_rest_oauth_secret;
```


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.