Problem

Hyper-Q reports the error messageDTM3131: The datepart tzoffset is not supported by date function datepart for data type datetime

Cause

This issue is often encountered in complex statements with many nested views. 

Solution

Perform the following analysis and remediation steps using a SQL client connecting through Hyper-Q to the cloud data warehouse.

1. If the SQL statement causing the error has more than one source view, run SELECT COUNT(*) FROM view_name against each view involved to determine where the error originates.
2. Continue this process until you identify the view causing the issue.
3. When you identify the view causing the error, re-run the view definition and validate that you can successfully run SELECT COUNT(*) against the view.