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 ?
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, but unless there is some native way to connect to MySQL from BQ then no it can’t do it at all.