The following situation: I am creating a Database with location somewhere in my Azure Lake Gen 2.

CREATE SCHEMA IF NOT EXISTS curated LOCATION 'somelocation'

Then i want a specific Table in curated to be in a subfolder in 'somelocation':

CREATE TABLE IF NOT EXISTS curated.tablename

(

values

)

USING DELTA LOCATION 'somelocation/subfolder'

(I created an empty table)

This results in addition to the desired folders in 'somelocation/subfolder' in the creation of additional folders "somelocation/tablename___PLACEHOLDER__/

Can someone explain why these placholders are created? Do i can just delete these Placholders?

Thank your for your help