Johno Scott
04/17/2023, 2:11 AMdynamic partition
with a sensor that adds a partition (a timestamp) each time new data is detected in an incoming CDC source (Fivetran). Depending on the frequency of the ingestion i could be creating :
4 partitions per hour (once every 15 minutes FiveTran connector performs a sync)
96 partitions per day (4 per hour x 24 hours)
== lets round that up to 100 per day ==
36,500 per year (100 x 365 days)
73,000 after 2nd year
182,500 after year 5
... and continued growth of 36K partitions per annum
Is there a sensible limit I should be considering ?
Will things slow down as I add more partitions ?
Are there memory resource implications (e.g. does Dagster code ever load the entire partition set into memory ?)Tim Castillo
04/17/2023, 3:43 PMJohno Scott
04/17/2023, 8:24 PMJohno Scott
04/19/2023, 11:36 AMTim Castillo
04/19/2023, 7:36 PMclaire
04/19/2023, 9:54 PMclaire
04/19/2023, 9:56 PMJohno Scott
04/20/2023, 10:14 PMJohno Scott
04/21/2023, 1:48 AMJohno Scott
04/21/2023, 1:50 AMJohno Scott
04/21/2023, 1:50 AMJohno Scott
04/21/2023, 2:00 AM