# BigQuery

## Configuration

The BigQuery configurations are:

* `creds`: the path to the Google authentication credentials. The default is the environment variable `GOOGLE_APPLICATION_CREDENTIALS`.

For more information, see here the [Google BigQuery documentation](https://cloud.google.com/bigquery/docs/reference/libraries).

```yaml
# profile.yml

<profile name here>: # change this!
  adapters:
    <bigquery adapter name here>: # change this!
      type: bigquery
      creds: '{{ env("GOOGLE_APPLICATION_CREDENTIALS") }}'

```

Under the hood, prism interacts with the BigQuery Python API to create the SQL engine.

## `hooks.sql()`

You can run queries against the BigQuery engine using the `hooks.sql` function:

```python
def run(self, tasks, hooks):
    df = hooks.sql(
        adapter_name="<bigquery adapter name>",
        query="SELECT * FROM table"
    )
```