Forum Discussion
Schema on lakehouse sql endpoint
DennesTorres It seems to be same limitations that we use to have in Synpase analytics -- lake databases
Reference Text:Custom SQL objects in lake databases
Lake databases allow creation of custom T-SQL objects, such as schemas, procedures, views, and the inline table-value functions (iTVFs). In order to create custom SQL objects, you MUST create a schema where you will place the objects. Custom SQL objects cannot be placed in dbo schema because it is reserved for the lake tables that are defined in Spark, database designer, or Dataverse.
Link :
https://learn.microsoft.com/en-us/azure/synapse-analytics/metadata/database
DennesTorres It seems to be same limitations that we use to have in Synpase analytics -- lake databases
Reference Text:
Custom SQL objects in lake databases
Lake databases allow creation of custom T-SQL objects, such as schemas, procedures, views, and the inline table-value functions (iTVFs). In order to create custom SQL objects, you MUST create a schema where you will place the objects. Custom SQL objects cannot be placed in dbo schema because it is reserved for the lake tables that are defined in Spark, database designer, or Dataverse.
Link :
https://learn.microsoft.com/en-us/azure/synapse-analytics/metadata/database
puneetvijwani We can create the custom SQL objects in the dbo schema as well, like views and procedure. We just can't create the function only.