copy orders to (getvariable('bucket') || '/analytics/orders.parquet') (format parquet);

select path_in_schema, type, compression, total_compressed_size, total_uncompressed_size from parquet_metadata(getvariable('bucket') || '/analytics/orders.parquet');


copy orders to (getvariable('bucket') || '/analytics/orders_by_product') (format parquet, partition_by (product), overwrite_or_ignore);

select file from glob(getvariable('bucket') || '/analytics/orders_by_product/**');


select count(*)
from read_parquet(getvariable('bucket') || '/analytics/orders_by_product/*/*.parquet') where product = 'cookie';