topic Delta Live Table "Default Schema" mandatory but not editable in Data Engineering

Delta Live Table "Default Schema" mandatory but not editable

hedbergjacob — Thu, 30 Jan 2025 14:53:01 GMT

Hi,

We have an issue with a DLT pipeline. We want to add some source code to an existing pipeline. However, when we save, error message shows that "Default schema" is a mandatory field. However, we are not able to edit the field. The DLT pipeline does not have a default schema as of now.

However, I see that "default schema" is mandatory since patch "Delta Live Tables now supports publishing to tables in multiple schemas and catalogs".

I have full admin rights on workspace.

Any ideas on how to go about this? Do we need create a new pipeline and set it up again?

Re: Delta Live Table "Default Schema" mandatory but not editable

NandiniN — Sat, 01 Feb 2025 04:11:14 GMT

Does the pipeline settings JSON includes the "schema" field.

If you have full admin rights, you can update the existing pipeline settings to include the "schema" field.

curl -X PATCH https://<databricks-instance>/api/2.0/pipelines/<pipeline-id> \ -H "Authorization: Bearer <your-access-token>" \ -H "Content-Type: application/json" \ -d '{ "schema": "your_default_schema" }'

https://docs.databricks.com/en/delta-live-tables/properties.html

**schema **

Type: string

The name of the default schema for the pipeline, where all datasets and metadata for the pipeline are published by default. See Set the target catalog and schema.

Re: Delta Live Table "Default Schema" mandatory but not editable

hedbergjacob — Mon, 03 Feb 2025 09:38:04 GMT

Thank you!

Still, should it not be possible to change it in the UI?