Database Creation Error while editing Google Sheets Database

[phananh050199]

Bug description

Yesterday I created a connection with Google Sheet Database including 3 sheets (all are sharable) and I still use it well. But today after I install adapters for connecting to Shillelagh database I met the error Unexpected error: TypeError: Cannot convert undefined or null to object while opening SQL Lab. I research the error and then find out that my connection to Google Sheet Database raised fatal error but don't know how to fix it. I even tried to delete the datasets as well as database connection but Apache Superset don't allow me to do this. Does anyone have a clue. Thank you

How to reproduce the bug

Go to Settings Click Database Connections Edit Google Sheets Database

Screenshots/recordings

Superset version

4.0.0

Python version

3.10

Node version

16

Browser

Chrome

Additional context

No response

Checklist

• [X] I have searched Superset docs and Slack and didn't find a solution to my problem.
• [X] I have searched the GitHub issue tracker and didn't find a similar bug report.
• [X] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.

[aishsharmagit]

I am facing the same issue, using Superset 4.0. Whenever I try to connect to Google Sheets I get the error (builtins.NoneType) None [SQL: connect) got an unexpected keyword argument 'source'] (Background on this error at: https://sqlalche.me/e/14/dbapi)

I am following this doc: https://docs.preset.io/docs/google-sheets-connection