# Export from MySQL to BigQuery

**URL:** <https://discourse.getdbt.com/t/export-from-mysql-to-bigquery/7532>\
**Category:** Help\
**Created:** [March 28, 2023, 6:30pm UTC](https://discourse.getdbt.com/t/export-from-mysql-to-bigquery/7532 "2023-03-28T18:30:53Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![FrancoC](https://avatars.discourse-cdn.com/v4/letter/f/f17d59/32.png) [@FrancoC](https://discourse.getdbt.com/u/FrancoC)\
**Post date:** [March 28, 2023, 6:30pm UTC](https://discourse.getdbt.com/t/export-from-mysql-to-bigquery/7532/1 "2023-03-28T18:30:53Z")

</div>

I’m not able to read data from MySQL and write them to a BigQuery DB

I’m stuck at the very beginning because seems that the 2 connetors `dbt-bigQuery` and `dbt-mysql` depend on different versions of dbt-code

```auto
dbt-bigquery 1.4.3 requires dbt-core~=1.4.0, but you have dbt-core 1.1.4 which is incompatible.

```

`dbt-core 1.1.4` is installed by dbt-mysql

can someone suggests a way to make dbt to work together with BigQ and MySQL ?

---

<div class="post-metadata">

**Author:** ![joellabes](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/joellabes/32/3980_2.png) [@joellabes](https://discourse.getdbt.com/u/joellabes)\
**Post date:** [March 28, 2023, 10:47pm UTC](https://discourse.getdbt.com/t/export-from-mysql-to-bigquery/7532/2 "2023-03-28T22:47:40Z")

</div>

dbt is not a data movement tool (the Extract/Load in ELT), it is only for transforming data once it lands in a warehouse.

To move data from one warehouse to another, you’ll want to look into tools like Fivetran, Stitch, Meltano, Airbyte etc.

---

<div class="post-metadata">

**Author:** ![FrancoC](https://avatars.discourse-cdn.com/v4/letter/f/f17d59/32.png) [@FrancoC](https://discourse.getdbt.com/u/FrancoC)\
**Post date:** [March 29, 2023, 5:04am UTC](https://discourse.getdbt.com/t/export-from-mysql-to-bigquery/7532/3 "2023-03-29T05:04:31Z")

</div>

thanks, I’m aware of the scope of dbt, and indeed we’re using it on BigQ for data trasnformation. It happens now that one raw datasource is not on BigQ itself, but rather on a different db (MySQL) and seem it should be possible to just read from MySQL and write to BigQ.  
Do you say that is not possibile at all or that dbt is just not the best tool for that ?

---

<div class="post-metadata">

**Author:** ![joellabes](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/joellabes/32/3980_2.png) [@joellabes](https://discourse.getdbt.com/u/joellabes)\
**Post date:** [March 29, 2023, 5:12am UTC](https://discourse.getdbt.com/t/export-from-mysql-to-bigquery/7532/4 "2023-03-29T05:12:06Z")

</div>

> [@FrancoC](#):
>
> Do you say that is not possibile at all or that dbt is just not the best tool for that ?

dbt can only do things that your warehouse can already do in SQL. So you can do something like [unload a CSV to a GS bucket](https://cloud.google.com/bigquery/docs/reference/standard-sql/other-statements#export_data_statement), but unless there is some native way to connect to MySQL from BQ then no it can’t do it at all.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex020/uploads/getdbt/original/1X/a7a7ca1fe379aaf90952b0e13118a817babcd14f.png) [@system](https://discourse.getdbt.com/u/system)\
**Post date:** [April 5, 2023, 5:12am UTC](https://discourse.getdbt.com/t/export-from-mysql-to-bigquery/7532/5 "2023-04-05T05:12:16Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.