# BigQuery compute pushdown

To use compute pushdown with BigQuery, create a [Python repository](../overview/index.md) and install the most recent version of the `transforms-tables` library.

An [Ibis ↗](https://ibis-project.org/) connection to BigQuery will be established based on the connection details of the BigQuery tables configured as inputs and/or outputs. Data can be transformed using the Ibis DataFrame API. For complete guidance on the Ibis API, consult the [Ibis documentation ↗](https://ibis-project.org/backends/bigquery).

Note the use of Foundry lightweight API syntax rather than Foundry Spark syntax in the following example of a BigQuery-backed Ibis transform:

```python
from transforms.api import transform
from transforms.tables import (
    IbisInput,
    IbisOutput,
    TableInput,
    TableOutput,
    BigQueryTable
)


@transform.bigquery.using(
    source_table=TableInput("ri.tables.main.table.1234"),
    output_table=TableOutput(
        "ri.tables.main.table.5678",
        "ri.magritte..source.1234",
        BigQueryTable("PROJECT", "DATASET", "TABLE"),
    ),
)
def compute(source_table: IbisInput, output_table: IbisOutput):
    # Data transformation with Ibis
    table = source_table.table()
    output_table.write(table)
```

:::callout{theme="neutral"}
Incremental computation using the `@incremental` decorator is not currently supported when using compute pushdown to BigQuery.
:::