Hi!How can I join a table in Bigquery with a table in Redshift? I did it using merge in a look, but there is a limit of 5000 lines and I have more data than that.
I don’t think you can join two databases with different dialects. You can join two different databases using federated joins (assuming they are the same dialect, same physical machine and same connection). Per the article I think the best bet would be to duplicate the datasets into the desired database
Other posters are correct, this isn’t directly possible outside merged results or federated joins.
That said, there is a dark magic called a foreign data wrapper which should be elaborated on in the next community mic drop. I’m not 100% sure if Redshift and BigQuery specifically can utilize this though.
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.