I’m having trouble using Snowflake data source advanced options

Hello,

I am getting an error when calling a table in snowflake stating the following:

"This native database query isn't currently supported".

I have already unchecked the checkbox under Options-->Security--> "Require user approval for new native database queries" and tried simple SELECT 1 FROM some_table.

I'm trying to run this query: 

SELECT * from some_table
WHERE Column1 = 'ABC'
AND "Date" BETWEEN DATEADD(YEAR,-1,"Date") AND 'yyyy-mm-dd' 

Does anyone know what might be causing this?

Thanks!