Snowflake connector is not able to push down WHERE col1 like 'xxx' ESCAPE '\', because of the ESCAPE. I wonder, how can the ESCAPE “clause” be added to ARP yaml mapping? It is not exactly operator, more like a modifier of operator. The little docs ARP has did not provide examples for these cases.

Hi, this is still not working. How can I push down queries that specify ESCAPE modifier?


You should be able to use external queries to pushdown the literal query string you want, rather than relying on Dremio’s query planner to determine the pushdown.

That’s actually quite limiting…
But found a proper way