Shillelagh is a Python library that allows querying many data sources using SQL, including Google Sheets, CSV files, and APIs.
Installation
Required packages: shillelagh[gsheetsapi]
Connection String
shillelagh://Supported Features
JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation
Feature Score: 41/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
Notes
Shillelagh uses virtual tables to query external data sources. Google Sheets requires OAuth credentials configured.
Help improve this documentation by editing the engine spec: