CODEWITHSUNDEEP
restdatabricksdatabricks-unity-catalogdatabricks-rest-api
Hazal
Hazal

Reputation: 23

How can I retrieve table constraints using Databricks REST API at the schema level?

I would like to know if someone faces the same issue as I do. If so, how did you solve it? I need to get the DDL at the schema level in Databricks so I can use the REST API -> GET /API/2.1/unity-catalog/tables. However, it does not return the table constraints, although it is listed in the API documentation

The response includes all the metadata except the table constraints.

Is there something that I might have missed?

I am using the below input parameters:

[{"key":"catalog_name","value":"demo","equals":true},{"key":"schema_name","value":"marts","equals":true}, {"key":"include_delta_metadata","value":"ture"}]

Upvotes: 0

Views: 459

Answers (1)

Matt Morris
Matt Morris

Reputation: 1

I have experienced the same thing and was told by Databricks that using list does not return these constraints, although using get for a single table does. I have tested this and can confirm experiencing the same thing. Their documentation for list does suggest these constraints should be returned, but that is wrong.

Additionally, if you're using the Databricks python SDK, it does not return the constraints. I'm not sure if these issues are related, but I've opened an issue to detail that problem as well.

Upvotes: 0

Related Questions