oscarxanda opened a new issue #15814: URL: https://github.com/apache/superset/issues/15814
Assuming an account that has column level access defined in an AWS Data Lake. When using this account to connect to Athena, when Superset retrieves the table structure, it retrieves also the columns the user does not have access to. The preview will also fail, as instead of the preview working by "SELECT *..." it does a "SELECT column_1, column_2...". ### Expected results Schema retrieval will only return the columns the account has access to. Table preview will work by not adding the columns the account does not have access to. ### Actual results Table schema shows fields with no access. Preview mode fails. #### Screenshots Preview mode failing, schema showing the column "class" that the account does not have access to.  Expected result  #### How to reproduce the bug 1. Create an account with column level permissions 2. Create a DB connection using that account 3. Go to SQL Lab 4. Select a table the account has access to (but won't have access to all columns) 5. See error ### Environment Using the docker image available on git - superset version: `superset version` Loaded your LOCAL configuration at [/app/docker/pythonpath_dev/superset_config.py] logging was configured successfully 2021-07-21 08:52:52,080:INFO:superset.utils.logging_configurator:logging was configured successfully 2021-07-21 08:52:52,096:INFO:root:Configured event logger of type <class 'superset.utils.log.DBEventLogger'> /usr/local/lib/python3.7/site-packages/flask_caching/__init__.py:202: UserWarning: Flask-Caching: CACHE_TYPE is set to null, caching is effectively disabled. "Flask-Caching: CACHE_TYPE is set to null, " -=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Superset 0.999.0dev -=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - python version: `python --version` Python 3.7.9 - node.js version: `node -v` /bin/sh: 4: node: not found ### 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 No additional context -- 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. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
