[GitHub] jessicachen888 opened a new issue #3694: Foreign table cannot be loaded in SQL lab Tab

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

jessicachen888 opened a new issue #3694: Foreign table cannot be loaded in SQL lab Tab
URL: https://github.com/apache/incubator-superset/issues/3694
 
 
   Make sure these boxes are checked before submitting your issue - thank you!
   
   - [ ] I have checked the superset logs for python stacktraces and included it here as text if any
   - [ ] I have reproduced the issue with at least the latest released version of superset
   - [ ] I have checked the issue tracker for the same issue and I haven't found one similar
   
   
   ### Superset version 0.20
   
   
   ### Expected results
   A table names event_warnings should appear in the SQL lab query tab when user select the corresponding databases and schema.
    
   
   
   ### Actual results
   ![image](https://user-images.githubusercontent.com/16902443/31760961-04cf4b08-b47c-11e7-965d-284cfc9052b4.png)
   
   The event_warnings table appear in the Slice tab
   ![image](https://user-images.githubusercontent.com/16902443/31761164-aba0dee2-b47c-11e7-928b-35b36123313d.png)
   
   
   
   
   ### Steps to reproduce
   
   Use a Foreign Data Wrapper mongodb + multicorn + yam_fdw o create a foreign table in postgresql
   
   **In Postgresql console:**
   
   `CREATE EXTENSION multicorn;
   
   CREATE SERVER mongodb_proxy_server FOREIGN DATA WRAPPER multicorn OPTIONS (wrapper 'yam_fdw.Yamfdw');
   
   CREATE FOREIGN TABLE event_warnings ( 
   "_id" varchar OPTIONS (type 'ObjectId'),
   "ID" varchar, "Point" varchar,
   "Start_Time" timestamptz, "Stop_Time" timestamptz, "Area" varchar,
   "Value" float, "Station" varchar, "Device" varchar, "Warning_Type" varchar,
   "Warning_Upper_Limit" float, "Warning_Lower_Limit" float,
   "Warning_Method" int
   )
   
   SERVER mongodb_proxy_server OPTIONS ( 
   db 'XXX', collection 'event_warnings', 
   host '122.XXX.XXX.XXX', port '27017', user 'username', password 'password'
   );`
   
   In superset:
   ![image](https://user-images.githubusercontent.com/16902443/31761295-08e75450-b47d-11e7-80ce-b5f29de9c3bb.png)
   
   OS: Mac 64 bit
   
   
   

----------------------------------------------------------------
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