CONVERT_TIMEZONE issue in DLT

SamGreene
Contributor III

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?