[GitHub] vldmit opened a new issue #5650: Not able to add a table from external Redshift Spectrum schema

[GitBox <gi...@apache.org>]

vldmit opened a new issue #5650: Not able to add a table from external Redshift Spectrum schema
URL: https://github.com/apache/incubator-superset/issues/5650
 
 
   - [x] I have checked the superset logs for python stacktraces and included it here as text if any
   - [x] I have reproduced the issue with at least the latest released version of superset
   - [x] I have checked the issue tracker for the same issue and I haven't found one similar
   
   ### Superset version
   
   0.26.3
   
   ### Expected results
   
   I want to add a table from external Redshift Spectrum schema, in order to create charts based on this table. I expect the flow will be the same as with "local" Redshift schemas: 
   
   1) Sources -> Databases -> Add (postgresql)
   2) Sources -> Tables -> Add (select redshift DB, put schema name and table name)
   3) Observe a table in a table list
   
   ### Actual results
   
   Following error is displayed:
   
   > Table [spectrum.assoc] could not be found, please double check your database connection, schema, and table name
   
   where `spectrum` is an external schema name and `assoc` is a table name. 
   
   ### Steps to reproduce
   
   Create Redshift cluster; create external spectrum schema; add a table to the metastore
   
   ### Notes
   
   - I think this _might_ be a duplicate of https://github.com/apache/incubator-superset/issues/3316
   - In `psql` console, you can't get a list of tables in external spectrum schema by using `\dS`, only by querying SVV_EXTERNAL_TABLES system view.
   - In Superset's SQL Lab I can query external spectrum tables by using `schema.tablename` naming
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org