> For the complete documentation index, see [llms.txt](https://docs.acho.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.acho.io/acho-studio/data-flow/export-data/connect-bigquery.md).

# BigQuery

1\. Create a **Workflow** of the project you are working on if there isn't one.

![](https://3574406564-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MB_fx7PCUqvFEdrucJC%2Fuploads%2FhpawtlHYdWg95FkrwV2D%2Fimage.png?alt=media\&token=65b95956-7b39-4d8d-b919-a54b954da7a7)

2\. Drag **BigQuery** under New Database

![](https://3574406564-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MB_fx7PCUqvFEdrucJC%2Fuploads%2F79KnYQbnFyLouMDMYOYv%2Fimage.png?alt=media\&token=96c73c9e-1866-4780-8289-c19dd8f06466)

3\. Enter the following info. 

**Dataset ID** needs to meet BigQuery's naming requirement. Good example: "test\_data"

Make sure the **service account** has access to create projects and datasets. 

![](https://3574406564-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MB_fx7PCUqvFEdrucJC%2Fuploads%2F6gjRT9DShrUGAOIsoWUk%2Fimage.png?alt=media\&token=de0c705d-b56a-4c10-b6fc-c0248bf80be0)

4\. Connect the table to the Destination you just created.

![](https://3574406564-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MB_fx7PCUqvFEdrucJC%2Fuploads%2FXEWLl397mn7aLjQByeRh%2Fimage.png?alt=media\&token=7183cda0-146d-4109-a836-18d34e7e4049)