paumillet opened a new issue #14406: URL: https://github.com/apache/superset/issues/14406
Hello, Following [this tutorial on Preset blog](https://preset.io/blog/2020-06-01-connect-superset-google-sheets/), I managed to connect to the example spreadsheet, as well as my own ones, with simple queries via the SQL editor as ```sql SELECT * FROM "https://docs.google.com/spreadsheets/d/1_rN3lm0R_bU3NemO0s9pbFkY5LQPcuy1pscv8ZXPtg8/edit#gid=0"; ``` I got the results correctly returned. But every time I try to "Explore" my dataset then, I get the following error `no such table`:  When I try to build a bar chart, as suggested in the tutorial, I noticed that the query Superset was applying was : ```sql SELECT country AS country, COUNT(*) AS count FROM "https://docs.google.com/spreadsheets/d/1_rN3lm0R_bU3NemO0s9pbFkY5LQPcuy1pscv8ZXPtg8/edit#gid=0"; GROUP BY country ORDER BY count DESC LIMIT 10000 ``` I indeed have the same error when reproducing that query in the SQL editor. But I don't have error anymore if I just query without the `ORDER BY` statement! and my results are correctly displayed. Any idea on how to deal with this trouble to be able to visualize my data from Gsheets? I'm using Superset version 1.0.1, let me know if you need more information about the setup. Thanks in advance for helping, Pauline -- 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]
