wyzer
Contributor II

Hi,

Here is the result of of the "ls" command :

path                          name              size          modificationTime
dbfs:/mnt/${env]/      ${env]/		0		1654780637000
dbfs:/mnt/Temp/       Temp/		0		1643299456000
dbfs:/mnt/bronze/     bronze/		0		1655217261000
dbfs:/mnt/dev/          dev/		        0		1642150158000
dbfs:/mnt/extprd/      extprd/		0		0
dbfs:/mnt/gold/         gold/		0		1655197511000
dbfs:/mnt/prod/         prod/		0		1649774080000
dbfs:/mnt/qa/            qa/			0		1643122331000
dbfs:/mnt/silver/        silver/		0		1654676963000
dbfs:/mnt/uat/            uat/		0		1642150009000

I've used this command to create the folder :

CREATE OR REPLACE TABLE ${env}XXXXX.ZZZZ (
  .....
)
USING DELTA
OPTIONS (PATH '/mnt/${env]/gold/XXXXX/ZZZZ/')

As you can see, I've written "${env]" instead of "${env}'.