topic Re: Location for DB and for specific tables in DB in Data Engineering

Location for DB and for specific tables in DB

Mirko — Wed, 02 Feb 2022 12:31:12 GMT

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

Re: Location for DB and for specific tables in DB

Anonymous — Wed, 02 Feb 2022 16:22:39 GMT

Hi, Mirko. Welcome back! Just like the last time, we'll give your peers a chance to respond. We'll come back around if we need to. Thank you for your patience. 🙂

Re: Location for DB and for specific tables in DB

Mirko — Wed, 02 Feb 2022 17:30:55 GMT

Hi Piper, i tried it again. This time on 10.2 instead of 9.0. Now it works like desired. But still a little bit strange.

Re: Location for DB and for specific tables in DB

Anonymous — Thu, 03 Feb 2022 17:10:33 GMT

@Mirko Ludewig - Thanks for letting us know. I don't like strange all that much, but I do like working as desired!