Row-limited operators are fast short-circuiting CSE rule by combining FilterNode and ProjectNode and complex function splitting Avoid unnecessary intermediate data structures Optimization Merge similar TableScan Merge arbitrary() and inner complex scalar function
In this talk, we provide a glimpse at the results of our latest benchmark test which compares the speed and cost of processing data inside Snowflake (ELT) vs. processing and serving prepared live tables from a data lake using Upsolver (ETL).