Hey everyone, other question:
What are your though...
# best-practicess
Stéphane Burwash
02/23/2023, 1:33 PMHey everyone, other question:
What are your thoughts on federated queries? Currently we have a tap-postgres -> target bigquery setup (through stitch), but I'm starting to wonder if I could simply use federated queries to directly copy the data from postgres into bigquery using dbt.
Is this possible and / or a good idea?
v
visch
02/23/2023, 2:26 PMif it has native support for it why not imo! I do linked servers with mssql so I can pull from other mssql databases directly in SQL (using dbt) 🤷
visch
02/23/2023, 2:27 PMYou do move the configuration to the Database which sucks in some ways vs Meltano but it all depends on what your team is more familiar with I think
Having said that we don't use Linked Servers to pull data from oracle even though it's possible because there's a bunch of limitations on the MSSQL end with Linked Servers and even more with a different DB type
s
Stéphane Burwash
02/23/2023, 3:40 PMOk awesome, thanks!
c
christoph
02/23/2023, 8:27 PMdbt also has support manage those external source tables: https://github.com/dbt-labs/dbt-external-tables
p
prratek_ramchandani
02/24/2023, 11:48 PMDoes bigquery support federated queries against Postgres? 🤔