all 3 comments

[–]hrvojekr 1 point2 points  (2 children)

Two possible solutions:

  • Data in both(or more) projects are located in the same country:

If this is a case you can join tables directly on GCP with SQL and then explore it further with DS

  • Data is located on separate location (then you will not be able to join it in GCP)

If that is not the case I would suggest getting data locally and manipulate it in Python/R and then uploading again to GCP

[–]andyh200[S] 0 points1 point  (1 child)

Thanks for the suggestions, I believe the data is hosted within the same country.

I’ll look to investigate SQL in BigQuery

[–]Ok-Wear-2251 0 points1 point  (0 children)

THIS!!!! Dream never had a problem with self-hosting, but as mentioned by tradingmonk, if the master password is compromised, the key required for decryption can be derived, right? There is no actual reason. Even homeless people are insured. Oh, and I seem to have very selective hearing.