Change data partitioning
When Change Data Partitioning is enabled, the Replicate Change Tables in Databricks are partitioned by the partition_name
column. Data files are uploaded to the storage, according to the maximum size and time definition, and then stored in a directory under the Change Table directory. Whenever the specified partition timeframe ends, a partition is created that points to the storage location.
Information about the partitions is written to the attrep_cdc_partitions Control Table.