Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Redshift ODBC Query Folding Failure due to Data Types

Hi there,   At first, I didn't know what the question was. I was a bit stuck. But I believe that my question is the following: When applying filters, what data types will (and will not) result i...
Need Help
edhans's avatar
edhans
Community Champion
4 years ago

They should all fold correctly. I've not used RedShift but I've filtered on decimals, integers, dates, and strings in Power Query to SQL and SnowFlake with no issues.

And even when folding breaks, it just continues to work in the Power Query mashup engine either on your desktop or gateway, it doesn't throw an error.

I'd consider opening a support ticket with MS. I have seen similar issues with Oracle not working correctly and there are double-bit character sets involved.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks for the reply Ed!

    Yeah, the PQ mash up evaluator contines but it's on millions of rows so it is incredibly slow. I'd rather it be folded.

     

    Since my post I have tried to join on definite integers and it displays a 
    The function (..) -> is not valid
    The left query is not a valid ODBC query

    Second one is strange, because it folds correctly up to that point...

    Also, neither Table.Join or Table.nestedJoin functions fold on a smaller dataset I have put into Redshift., tried inner and leftOuter jouns. Both queries are folded up to the join for left and right queries before passing the results over to the mash up evaluator.