Delta live tables target schema

shagun
New Contributor III

The first time i run my delta live table pipeline after setup, I get this error on starting it :-

------------------------------------

org.apache.spark.sql.catalyst.parser.ParseException: 

Possibly unquoted identifier my-schema-name detected. Please consider quoting it with back-quotes as `my-schema-name`(line 1, pos 34)

== SQL ==

CREATE DATABASE IF NOT EXISTS my-schema-name

----------------------------------^^^

at org.apache.spark.sql.errors.QueryParsingErrors$.unquotedIdentifierError(QueryParsingErrors.scala:382)

at org.apache.spark.sql.catalyst.parser.PostProcessor$.exitErrorIdent(ParseDriver.scala:388)

at

--------------------------------------------

The pipeline works fine, if i leave the target schema field blank and run the pipeline.

I then update the pipeline with target schema my-schema-name and then successive pipeline updates are successful. But everytime i run the pipeline 1st time after setting it up, I get the above errror.