Hi folks,
I am trying to setup a data source to Redshift with custom query which require the date parameters (@DS_START_DATE, @ds_END_DATE). It seems like the parameter wasn't replaced by the actual value.
To test this, I have created a test data source where the query being:
SELECT
'@DS_START_DATE' AS start_date_str
Just to see if Looker Studio will replace the parameters when in report. The answer is no.
I have also tried that without single quote but still no luck. If this does not work we will not be able to use Looker Studio but have to use competitors.
Any idea how to make it work? Thank you in advance!
PS: I have experience with Looker Studio on BigQuery and it just work fine. Must be a Redshift problem....
LinkedIn
Twitter
