Materialized view and time_bucket with dynamic timezone?

It’s not possible right now @Emilie. You’d need to create one materialized view per time zone. Check this: Continous Aggregate Support for different timezone - #2 by Chris_Travers