[Dashboard] FCC New Coder Survey 2018, Error: Columns missing in datasource: ['Gender']

[zuzhi]

In this Gender slice in FCC New Coder Survey, uses wrong column name for group by cause an error.

Change 'Gender' to 'gender' should fix it.

Screenshots

How to reproduce the bug

1. Go to Dashboard 'FCC New Coder Survey 2018'
2. See error/Go to Gender Slice

Environment

Latest master

Checklist

Make sure to follow these steps before submitting your issue - thank you!

• I have checked the superset logs for python stacktraces and included it here as text if there are 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.

Additional context

Change 'Gender' to 'gender' should fix it.

[villebro]

@zuzhi on what database are you? I assume the problem is caused by how the database handles mixed case column names?

[zuzhi]

@villebro I use MySQL 8 as superset meta database

[zuzhi]

#12530 will fix this issue.