Issue with date/datetime fields in Snowflake & Direct Query

I'm having problems using date/datetime fields when connecting to Snowflake with direct query. Dragging any date/datetime column into a visual or using it as a filter will result in this error: ...