enryls commented on PR #27631:
URL: https://github.com/apache/superset/pull/27631#issuecomment-2621034146
> > > 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
> ```python
> 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
After some tentatives I was able to login, but there is a strange behaviour,
the first time I query the sheet I receive a "Server Error" then I refresh the
page and I receive "Provide authorization" message. I'll investigate more and
let you know.
--
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]
