Google Sheets allows querying spreadsheets as SQL tables via shillelagh.
Installation
Required packages: shillelagh[gsheetsapi]shillelagh[gsheetsapi]
pip install "apache-superset[gsheets]"Connection String
gsheets://Supported Features
JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation
Feature Score: 61/201
Time Grains
Common Time Grains:
SECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR
Extended Time Grains:
FIVE_SECONDSTHIRTY_SECONDSFIVE_MINUTESTEN_MINUTESFIFTEEN_MINUTESTHIRTY_MINUTESHALF_HOURSIX_HOURSWEEK_STARTING_SUNDAYWEEK_STARTING_MONDAYWEEK_ENDING_SATURDAYWEEK_ENDING_SUNDAYQUARTER_YEAR
Troubleshooting
Common error messages you may encounter when connecting to or querying Google Sheets, along with their causes and solutions.
Notes
Requires Google service account credentials or OAuth2 authentication. See docs for setup instructions.