darylerwin opened a new issue #4392: bigquery select putting in extra "schema" in the column names. URL: https://github.com/apache/incubator-superset/issues/4392 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 Latest ### Expected results (google.cloud.bigquery.dbapi.exceptions.DatabaseError) [{u'reason': u'invalidQuery', u'message': u'Unrecognized name: abc at [1:12]', u'location': u'query'}] ### Actual results ### Steps to reproduce Created table. It generates what looks to be somewhat correct sql except for the schema in front of the dataset.column name in the select statement. table is defined as abc.revenue schema is left blank database is defined as bigquery://myprojectid/ It looks as thought `myschema.revenue`.`exchange_rate` would work! .. so just the extra ` ` are causing the problem. SELECT SUM(`myschema`.`revenue`.`exchange_rate`) AS `sum__exchange_rate` FROM `abc.revenue` WHERE `day` >= '2018-02-02' AND `day` <= '2018-02-09' ORDER BY `sum__exchange_rate` DESC LIMIT 5000
---------------------------------------------------------------- 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: us...@infra.apache.org With regards, Apache Git Services
