Anonymous
Not applicable

@Rasmus Stokholm​ : does this help?

It is possible that the partition pruning is not happening because the partition column is not being properly defined as a timestamp type. Delta Lake uses the partitioning information to optimize queries and speed up data access, so it's important to ensure that the partition columns are defined correctly.

You can check the partitioning information of your table by running the DESCRIBE EXTENDED command in Delta Lake. This will give you more information about the table, including the partitioning scheme and the data types of the partition columns.

If the partition column is not properly defined as a timestamp type, you can try altering the table to redefine the partition column as a timestamp. For example, if your partition column is called "date", you can run the following command to redefine it as a timestamp:

ALTER TABLE mytable PARTITIONED BY (date TIMESTAMP)

Once you have verified that the partition column is correctly defined as a timestamp type, you can try running your query again and see if the partition pruning is working as expected.