Redshift Data Source adding gets me this error: 'dict' object does not support indexing

63 views
Skip to first unread message

csl...@carrotinsights.com

unread,
Mar 17, 2017, 4:15:46 PM3/17/17
to airbnb_superset
I have seen other people get this error specifically for adding a Redshift data source. My URI format is:  redshift+psycopg2://user:pa...@xx.xx.us-east-1.redshift.amazonaws.com:5439/test

Keshav Malani

unread,
Apr 17, 2017, 4:05:46 AM4/17/17
to airbnb_superset
+1 running into same issue. The test connection works but when I hit save, I get the dict error

Maxime Beauchemin

unread,
Apr 17, 2017, 11:13:39 AM4/17/17
to airbnb_superset
I haven't used Redshift but the docs recommend using a postgresql+psycopg2:// connection string against it and it's been discussed in issues. 

I'm guessing the `redshift` SQLAlchemy you are using has some shortcomings (probably around the calls to get metadata). It'd be good to pinpoint them and report them on that project.

Max

Keshav Malani

unread,
Apr 17, 2017, 2:35:22 PM4/17/17
to airbnb_superset
Thanks Maxime. It does connect with your suggested change
Reply all
Reply to author
Forward
0 new messages