Delta Live Table "Default Schema" mandatory but not editable

[hedbergjacob]

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?

[NandiniN · Accepted solution]

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.

Like 

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.

[hedbergjacob]

Thank you!

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