hawkz commented on issue #21152:
URL: https://github.com/apache/superset/issues/21152#issuecomment-3323293870
I believe I've solved this for my connection attempt.. wanted to share the
steps that worked for me.
1. Go to databases → + Database
2. Give the display name you want and the SQL URI: `gsheets://`
3. Setup a service account in cloud console, making sure you've got drive
and sheets APIs enabled.
4. Invite the service account email to have view access to your sheet.
5. Upload the service credentials into the database advanced tab BUT edit
them first to add `{"service_account_info": `before the Google downloaded JSON
and `}` after.
6. Make SURE that the sheet is free of formulas or content that'll confuse
it. (I had a `=now()` that threw me for a while)
7. Go to SQL lab, and query for your sheet in the `SELECT * FROM
"https://docs.google.com/spreadsheets/d/1IZgjkXXX6YI/edit?gid=0#gid=0"` format
(the gids are copied from the URL as I view the right tab/sheet in the google
sheet workbook.
Should then let you query and start doing fun stuff.
--
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]
