typeform_campaigns / Snapshot | MV with join optimization

Improving the performance of a JOIN thanks to subqueries. This was the query in a pipe that created a MV, so every time there was an ingestion in the submission finished datasource, the query was executed. Reducing the query time and processed bytes meant a lot in terms of performance.
Note: the shown Typeform's form may not be active anymore

Last updated