'dict' object does not support indexing when adding redshift database

[nicokras]

Trying to add a redshift database, I get the 'dict' object does not support indexing error. What could be happening?

Superset version 0.17.1
Python version: 2.7
Ubuntu server.

Thanks

[xrmx]

Please use the template issue and report all the needed informations like a stack trace.

[ndeslandes]

@mistercrunch

I have the same issue. No stacktrace in the log.

'dict' object does not support indexing when clicking Save in the /databaseview/add page with a redshift config

Database : db_name
SQLAlchemy URI : redshift+psycopg2://user:password@redhsit_host:5439/db_name
Cache Timeout :
Extra : {
"metadata_params": {},
"engine_params": {
"connect_args":{
"sslmode": "prefer"
}
}
}

[alexdebrie]

I had the same issue. To fix, change your SQL Alchemy URI from redshift+psycopg2://... to postgresql+psycopg2://...

Solution found here.

[nicokras]

@alexdebrie That worked for me. Thanks for your help!

[xrmx]

So documentation is wrong? If so anyone care to do a patch please? http://airbnb.io/superset/installation.html#database-dependencies

[alexdebrie]

See 2447.

[mistercrunch]

Merged, closing