You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@superset.apache.org by "rewert (via GitHub)" <gi...@apache.org> on 2025/12/04 15:44:07 UTC

Re: [I] Superset 3.0.2 Public Googlesheet can be read without service account credentials but throws error when you add creds [superset]

rewert commented on issue #26452:
URL: https://github.com/apache/superset/issues/26452#issuecomment-3612877497

   > You must use a Google Workspace account and configure Domain-Wide Delegation if you use subject. For regular (personal) Google accounts, just delete the subject in file superset/db_engine_specs/gsheets.py. <img alt="Image" width="1227" height="476" src="https://private-user-images.githubusercontent.com/73045983/472926401-1dba0a8a-8712-44b3-8fc6-aa15f5f2144a.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3NjQ4NjMwOTMsIm5iZiI6MTc2NDg2Mjc5MywicGF0aCI6Ii83MzA0NTk4My80NzI5MjY0MDEtMWRiYTBhOGEtODcxMi00NGIzLThmYzYtYWExNWY1ZjIxNDRhLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTEyMDQlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUxMjA0VDE1Mzk1M1omWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPWRlMzQ0NTM5ZTE0MWI4MTdlZTAwZWI2MDM2MzRmMGMyZDg3NTJkYjk3OWVhMzJmMDkxNjliNzNlMWUxZmQ5YzImWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.u9sx
 qpvbDsP36NhWjY3Qcs725bYQOlw5tFKwEgcAx1M">
   
   This in combination with removing subject from lib.py works.
   Just removing subject from gsheets.py gets you past the adding database connection error, but if we try to create dataset from it, we get error again.
   Removing subject from "if service_account_info:" and "if service_account_file:" in lib.py get_credentials function enables us to create datasets from it.


-- 
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: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org