enryls commented on PR #27631:
URL: https://github.com/apache/superset/pull/27631#issuecomment-2619665469
> > I tried this feature but I have a doubt about creating a Google Sheets
Database as it's still asking me for the service account data and Sheets
informations. Maybe I'm missing something?
>
> Can you give more details on what you did? Did you create an application,
populate `DATABASE_OAUTH2_CREDENTIALS`, and enable user impersonation?
Hi @betodealmeida thanks for the reply.
I followed this steps:
- I create a Google Sheets Database in Superset with user impersonation (I
created it with a public Google Sheets because if not I were not able to
complete the creation)
- I setup the variable
```py
DATABASE_OAUTH2_CLIENTS = {
# "Google Sheets": {
# "id": "XXX.apps.googleusercontent.com",
# "secret": "GOCSPX-YYY",
# "scope": " ".join(
# [
# "https://www.googleapis.com/auth/drive.readonly";,
# "https://www.googleapis.com/auth/spreadsheets";,
# "https://spreadsheets.google.com/feeds";,
# ]
# ),
# "authorization_request_uri":
"https://accounts.google.com/o/oauth2/v2/auth";,
# "token_request_uri": "https://oauth2.googleapis.com/token";,
# },
}
```
- Then I tried to query in SQL Editor a private Google Sheets
--
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]
