events
Save
and Deploy
What is a partitioned table?
Why should we use table partitions?
What are the different kinds of partitioning strategies?
Partitioning type | Description | Example |
---|---|---|
Time partitioning | Partitioning a particular column that is a TIMESTAMP. | Column: timestamp |
Integer range or interval based partitions | Partitioning off of a range of values for a given column. | Say you have a column called customer_id and there are 100 values. |
Ingestion-based | This is when the row was inserted. | NA |