Limits of Pushdown

There are limiting factors to the ability to push down queries. If there are multiple data sources connected on CData Virtuality, a query spanning multiple databases can not be pushed down completely, so some operations will have to be executed in CData Virtuality’s memory (or, to be more exact, in the buffer space, which will be discussed below)

As an example, two different databases of the same MS SQL server can be joined when querying it directly. If a different connection represents each database, the performance will be mitigated because CData Virtuality interprets them as different sources. A way to work around this behaviour is to create a view on the MS SQL server that joins them already on the MS SQL server side.

For databases like Snowflake and MS SQL, CData Virtuality supports having different catalogs and different databases in the same datasource.