Databricks, Delta Lake, Pyspark, Clustering, Data Warehouse.
512GB of data. If the SELECT subquery contains a transformation, filter, or join. If the projected columns are not the same as the source table. Because not all operations apply liquid clustering, Databricks recommends frequently running OPTIMIZE to ensure that all data is efficiently clustered.