Amazon Redshift unnesting of the super field

[vladimir_vv]

Hello everyone,

I'm searching for some advice and I would be grateful for any support regarding the following:

Issue: cannot upload the data from Amazon Redshift database, while trying to unnest the filed SUPER (aka nested field)

Error occurred: 

Details: "ODBC: ERROR [XX000] [Microsoft][Amazon Redshift] (30) Error occurred while trying to execute a query: [SQLState XX000] ERROR:  Query unsupported due to an internal error.

DETAIL:  *var_it != join_var_

Statement example (which runs on DBeaver with no problem)

select 
  event_date::date,
  super.param_name1,
  super.param_name2,
  super.param_name3
from my_data_base mdb
limit 100

So as you can see I address to superfield as "super", then I address to the required parameter as ".param_name1" using "." instead of join and unnest operators, but basically as I understand this is a syntax which is common for Redshift

Many thanks for your support in advance!
This is the screenshot of the error.
!

[manojgupta]

Not working for me, any solution?

[Shobita_T]

I could resolve the error my setting [EnableFolding=false] instead of true at the end the power query 

[loreto]

I've changed the connection with Amazon Redshift from direct connection to ODBC connection and it worked.  

[loreto]

How have you gotten around with that issue? I'm experiencing the same problem

[Anonymous]

Were you ever able to resolve this issue on your own? 

[cinziazullian]

I resolved the issue by changing the ODBC connection. I had to download the driver and connect using that. However, I'm unsure why this happened. I previously had a connection that worked perfectly fine, but then this problem occurred. I would like to understand why this happened to prevent it in the future.