...

Overview

Each of the Cloud Data Warehouse Warehouses (CDW) that SnapLogic supports , uses its own SQL Query Optimizer to assess and optimize the SQL queries generated by ELT Pipelines. This is primarily done to reduce the time and costs involved in executing these queries. But, because these optimizers consider optimizing only certain blocks in the query, but not the query as a whole (across these blocks of the query)—they , they generate inefficient query plans and take longer times for execution and thereby increasing incur higher CDW costs for the users. This is due to a generally conservative approach that these CDW optimizers tend to take—so as to not cause data integrity issues.

...

As the CDW optimizers look at enhancing the query only at its various chunks but not the entire query, they CAN MAY NOT generate the simple query that it actually is:

...