Databricks Community

You can use CAST instead.Eg:SELECT cast('2024' as int);

Interesting

The tables do not have specific configuration, and the user who is receiving the error is in a group that has full permission in the INTERNAL catalog

Schema validation should help here.

@HaripriyaP You can use databricks CLI to export and import notebooks from one workspace to another.CLI Documentation here:https://github.com/databricks/cli/blob/main/docs/commands.md#databricks-workspace-export---export-a-workspace-object

@HaripriyaP - Depends on your use case, Either of the below approach can be chosen. 1)  DELTA CLONE(DEEP CLONE) to clone them to the new workspace. 2) Have the same cluster policy/Instance profile of the old workspace to access them in the new worksp...

Just to close the loop here that it seems DLT generated MVs now support column comments.

could you get the full error stack trace please

Databricks REST API referenceThis reference contains information about the Databricks application programming interfaces (APIs). Each API reference page is presented primarily from a representational state transfer (REST) perspective. Databricks REST...