[Yandex Cloud documentation](../../../../index.md) > [Yandex Data Transfer](../../../index.md) > [Step-by-step guides](../../index.md) > [Configuring endpoints](../index.md) > BigQuery > Source

# Transferring data from a BigQuery source endpoint

When [creating](../index.md#create) or [updating](../index.md#update) an endpoint, configure access to BigQuery.

Yandex Data Transfer enables you to upload data from BigQuery storage to Yandex Cloud managed databases and implement various data processing and transformation scenarios. To implement a transfer:

1. [Explore possible data transfer scenarios](#scenarios).
1. [Prepare the BigQuery database](#prepare) for the transfer.
1. [Set up a source endpoint](#endpoint-settings) in Yandex Data Transfer.
1. [Set up one of the supported data targets](#supported-targets).
1. [Create](../../transfer.md#create) a transfer and [start](../../transfer.md#activate) it.
1. In case of any issues, [use ready-made solutions](../../../troubleshooting/index.md) to resolve them.

## Scenarios for transferring data from BigQuery {#scenarios}

You can upload data from BigQuery cloud storage to managed databases for further storage in the cloud, processing and loading into data marts for further visualization.

For a detailed description of possible Yandex Data Transfer scenarios, see [Tutorials](../../../tutorials/index.md).

## Preparing your BigQuery database {#prepare}

To prepare a BigQuery data source:

1. [Create a Google Cloud service account](https://cloud.google.com/iam/docs/creating-managing-service-accounts).
1. [Add the service account](https://cloud.google.com/iam/docs/granting-changing-revoking-access#granting-console) as a participant with the `BigQuery User` role to the Google Cloud project.
1. [Create a Google Cloud service account key](https://cloud.google.com/iam/docs/creating-managing-service-account-keys).

For more information, see [this Airbyte® guide](https://docs.airbyte.com/integrations/sources/bigquery).

## Configuring the BigQuery source endpoint {#settings}

{% list tabs group=instructions %}

- Management console {#console}

    * **Project ID**: Specify the ID of the [Google Cloud project](https://cloud.google.com/resource-manager/docs/creating-managing-projects) that contains the BigQuery target's dataset.
    * (Optional) **Default dataset ID**: Dataset ID used for searching for tables and forms to view. If the field value is set, data is only transferred from the specified [schema](https://cloud.google.com/bigquery/docs/datasets-intro). This may speed up schema detection.
    * **Credentials **: Specify the contents of the [account key](https://cloud.google.com/iam/docs/creating-managing-service-account-keys) JSON file.

{% endlist %}

## Configuring the data target {#supported-targets}

Configure one of the supported data targets:

* [MySQL®](../target/mysql.md)
* [MongoDB](../target/mongodb.md)
* [ClickHouse®](../target/clickhouse.md)
* [Greenplum®](../target/greenplum.md)
* [Yandex Managed Service for YDB](../target/yandex-database.md)
* [Apache Kafka®](../target/kafka.md)
* [YDS](../target/data-streams.md)
* [PostgreSQL](../target/postgresql.md)

For a complete list of supported sources and targets in Yandex Data Transfer, see [Available Transfers](../../../transfer-matrix.md).

Make sure that the network hosting the target cluster is configured to allow connections from the internet. To enable internet access, [set up routing](../../../../vpc/tutorials/nat-instance/index.md).

After configuring the data source and target, [create and start the transfer](../../transfer.md#create).