I can run a query that uses the CONVERT_TIMEZONE function in a SQL notebook. When I move the code to my DLT notebook the pipeline produces this error:
Cannot resolve function `CONVERT_TIMEZONE`
Here is the line: CONVERT_TIMEZONE('UTC', 'America/Phoenix', date_time) as local_datetime
Should this work?