Query folding issues with Redshift

[maj_a]

Hi all,

has anyone successfully set-up incremental refresh using Amazon Redshift as a data source?

We tried setting it up using the data connector for Redshift as well as an ODBC connection. In both instances query folding did not occur after applying the RangeStart and RangeEnd parameters as filters to the date column.

I will really appreciate if someone can help with this issue. Essentially, I am trying to upload a small data into service and run a refresh in service to pull 3 years of data and incrmental thereafter. When I apply the filter and run my query, which when sent to redshift does not recogive the data parameters passed:

Thanks,

MA

[vanessafvg]

have you checked against this document, if any of this conditions might prevent you from achieving query folding?

how do you pull the data via  a connector, what does your query do.

https://docs.microsoft.com/en-us/power-query/power-query-folding