Sharding = partitioning and it's the only way data warehouses can scale to handle large datasets. Tables are partitioned on the primary key, usually with range-based sharding for flexibility.
Some warehouses like BigQuery force this as a numeric key (dates by default) while others leave it up to you. Partitioning can also use multiple columns to help with more even distribution and/or better query performance.