This is a Push-Only function. It means that TDV relies on remote data sources that support this function to natively process it.

Not all data sources will support all functions and those that do may not have the exact same syntax or behavior. For help with syntax and functionality, refer to your data source documentation.

Push-Only functions should generally only be used when either there is no general alternative supplied by TDV or there is some specific behavior or performance benefit that is not available through TDV alternatives. Using Push-Only functions can prevent federated query optimizations when TDV creates query plans. This means TDV has less flexibility in determining in which data sources will process the different parts of a federated query.