Hi,
I am using a shared database on the redshift cluster that i am connecting to.
I am able to query the shared database using .. from the database i am connected to , however when i want to use a field filter, to use a Relative Date widget value, i am not able to set a field to map to.
In the Field to map to option, I cant select the column that includes the date, from the schema/table as it doesnt show up in the actual redshift database that i am connected to.
Is there a work around for this? Or another way i can set the custom time filter?
thanks