How to write a Delta Live Table(dlt) pipeline output to Databricks SQL directly

VVill_T
Contributor

Hi,

I am trying to see if it is possible to setup a direct connection from dlt pipeline to a table in Databricks SQL by configuring the Target Schema:

image with poc being a location of schema like "dbfs:/***/***/***/poc.db

The error message was just a syntax error and I am not sure if I am missing a trick here:

imageI have read the documentation on Target Schema but I dont think it is related to Databricks SQL and I wonder if someone can point me to the right direction or advice me on if this could be done at all?

Many thanks in advance!