Tables backed by a BigQuery, Databricks, or Snowflake connection can push Foundry authored transforms to BigQuery, Databricks, or Snowflake. This is known as "compute pushdown", and allows Foundry's pipeline management, data lineage, and security functionality to be used on top of data warehouse compute. Use virtual table inputs and outputs to push down compute.
To use compute pushdown:
All inputs and outputs must be virtual tables associated with the same source connection.
The source must be compute pushdown compatible (for example, BigQuery, Databricks, or Snowflake).
For more information and code examples, refer to the following source-specific compute pushdown documentation: