duckdb / duckdb/unity_catalog

READ / WRITE to Catalog Commit Managed Table doesn't work

Open
#87 3 comments 0 reactions 0 assignees View on GitHub
Dominant language
C++
Stars
110
Forks
44
Avg merge
2d 13h
Merged PRs (30d)
4

Description

In DuckDB v1.5

Steps to reproduce:

1 - Create a Managed Table in any Databricks workspace

2 - Run basic DuckDB commands
```INSTALL unity_catalog;
LOAD unity_catalog;
CREATE SECRET (
TYPE unity_catalog,
TOKEN 'xxx',
ENDPOINT 'WS',
AWS_REGION 'region'
);
ATTACH 'catalog' AS catalog (TYPE unity_catalog, DEFAULT_SCHEMA 'main');
USE CATALOG;
SELECT * FROM table;
```

Output:

```
DEBUG:
{'request': {'type': POST, 'url': 'https://WS.cloud.databricks.com/api/2.1/unity-catalog/temporary-table-credentials', 'headers': {User-Agent='duckdb/v1.5.3(osx_arm64) cli 14eca11bd9', Authorization=Bearer token, Content-Type=application/json}, 'start_time': '2026-06-11 11:59:45.787732', 'duration_ms': 497}, 'response': {'status': BadRequest_400, 'reason': Bad Request, 'headers': {date='Thu, 11 Jun 2026 11:59:46 GMT', x-request-id=4eeea8cd-4ba7-41c0-ad58-db65c3b20807, content-length=948, strict-transport-security='max-age=31536000; includeSubDomains; preload', x-databricks-org-id=xxx, server-timing='request_id;dur=0;desc="4eeea8cd-4ba7-41c0-ad58-db65c3b20807", client_protocol;dur=0;desc="HTTP/1.1"', server=databricks, vary=Accept-Encoding, alt-svc=clear, x-content-type-options=nosniff, content-type=application/json}}}

DEBUG:
{'database': temp, 'type': Rollback, 'transaction_id': 4611686018427388057}

IO Error:
POST Request to 'https://ws.cloud.databricks.com/api/2.1/unity-catalog/temporary-table-credentials' failed: 'Bad Request'
```

However the same setup works with External Tables

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.