DLT SQL demo pipeline issue

Frustrated_DE — Wed, 27 Mar 2024 13:16:12 GMT

Hi,

First foray into DLT and following code exerts from the sample-DLT-notebook.

I'm creating a notebook with the SQL below:

CREATE STREAMING LIVE TABLE sales_orders_raw
COMMENT "The raw sales orders, ingested from /databricks-datasets."
TBLPROPERTIES ("myCompanyPipeline.quality" = "bronze")
AS
SELECT * FROM cloud_files("/databricks-datasets/retail-org/sales_orders/", "json", map("cloudFiles.inferColumnTypes", "true"))

I then reference this in my DLT pipeline but it fails on initialising with a syntax error (pic attached). Can anyone assist? Appreciate it says python and I'm using SQL but thought the pipeline transposed as magic commands aren't permitted in notebook being called in DLT pipe.

Re: DLT SQL demo pipeline issue

Frustrated_DE — Wed, 27 Mar 2024 14:39:45 GMT

If you change the notebook default language as opposed to using magic command. I normally have it set to Python, I've wrongly assumed DLT would transpose as can't use magic command but have to change default in order for it to work.

topic DLT SQL demo pipeline issue in Get Started Discussions

DLT SQL demo pipeline issue

Re: DLT SQL demo pipeline issue