Google Analytics, Dataform, Bigquery, Google Cloud Platform, Sql.
Sharding is the act of creating separate tables with the same schema, but different table name suffixes (eg. _20231206). Then you can use wildcards and table suffixes to only query a certain date range (instead of the whole dataset). This choice is interesting because even Google itself advises