squalou opened a new issue #14029:
URL: https://github.com/apache/superset/issues/14029


   When in SQL Lab selecting a schema, then a table in dropdown menu I get an 
error instead of colums list.
   
   (Same thing happens when trying to 'add' a table in data/dataset tab)
   
   ### Expected results
   
   See the table description on the left pane.
   
   ### Actual results
   
   error is displayed, (see screenshot)
   
    and following errors appears in superset logs ;
   
   `TypeError: _get_column_info() missing 1 required positional argument: 
'generated' `
   
   More detailed stack : 
   
   ```python
   ERROR:root:_get_column_info() missing 1 required positional argument: 
'generated'
   Traceback (most recent call last):
     File 
"/usr/local/lib/python3.6/site-packages/flask_appbuilder/api/__init__.py", line 
84, in wraps
       return f(self, *args, **kwargs)
     File "/usr/local/lib/python3.6/site-packages/superset/utils/log.py", line 
70, in wrapper
       value = f(*args, **kwargs)
     File "/usr/local/lib/python3.6/site-packages/superset/views/base_api.py", 
line 79, in wraps
       duration, response = time_function(f, self, *args, **kwargs)
     File "/usr/local/lib/python3.6/site-packages/superset/utils/core.py", line 
1311, in time_function
       response = func(*args, **kwargs)
     File "/usr/local/lib/python3.6/site-packages/superset/databases/api.py", 
line 454, in table_metadata
       table_info = get_table_metadata(database, table_name, schema_name)
     File "/usr/local/lib/python3.6/site-packages/superset/databases/utils.py", 
line 66, in get_table_metadata
       columns = database.get_columns(table_name, schema_name)
     File "/usr/local/lib/python3.6/site-packages/superset/models/core.py", 
line 618, in get_columns
       return self.db_engine_spec.get_columns(self.inspector, table_name, 
schema)
     File 
"/usr/local/lib/python3.6/site-packages/superset/db_engine_specs/base.py", line 
692, in get_columns
       return inspector.get_columns(table_name, schema)
     File 
"/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/reflection.py", line 
391, in get_columns
       self.bind, table_name, schema, info_cache=self.info_cache, **kw
     File "<string>", line 2, in get_columns
     File 
"/usr/local/lib/python3.6/site-packages/sqlalchemy/engine/reflection.py", line 
52, in cache
       ret = fn(self, con, *args, **kw)
     File 
"/usr/local/lib/python3.6/site-packages/sqlalchemy_redshift/dialect.py", line 
409, in get_columns
       enums=[], schema=col.schema, encode=col.encode)
     File 
"/usr/local/lib/python3.6/site-packages/sqlalchemy_redshift/dialect.py", line 
614, in _get_column_info
       **kw
   TypeError: _get_column_info() missing 1 required positional argument: 
'generated'
   
   ```
   
   
   
   #### Screenshots
   
   
![image](https://user-images.githubusercontent.com/4623644/114073000-1b4c2b80-98a3-11eb-9524-37653d014d8c.png)
   
   ```
   
   
   ```
   
   #### How to reproduce the bug
   
   1. Go to  SQL Lab
   2. Click on Database, choose a REDSHIFT connexion
   3. Shoose the schema
   3. Unfold the Tables dropdown : which is correclty populated
   4. Choose a table
   5. see error
   
   ### Environment
   
   (please complete the following information):
   
   - superset version: `Superset 0.38.0`
   - python version: `Python 3.6.7`
   - node.js version: does not seem present in Superset docker install
   
   ### Checklist
   
   Make sure to follow these steps before submitting your issue - thank you!
   
   - [x] I have checked the superset logs for python stacktraces and included 
it here as text if there are 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.
   
   ### Additional context
   
   Seems related to this bug 
https://github.com/OpenEnergyPlatform/oedialect/issues/35
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
[email protected]



---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to