Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

BigQuery Location Mismatch Error with Datastream

I'm getting a location constraint error when trying to create a table that queries data from my Datastream-replicated dataset.

Setup:

  • Datastream is replicating data to a BigQuery dataset in us-east1 region 
  • I'm trying to create a new table in a schema that's in the US multi-region
  • Getting the error about single-region and multi-region locations not being compatible in the same query

Question:  I don't mind re-syncing the data, but it doesn't seem like I can set up a multi-region Datastream Stream. What should I do?


EDIT: 

For best results, keep all resources in one region. Choosing the same region as your source data can optimize cost, performance, and compliance. 

This comes from the datastream connection profiles. Saying "For best results, keep all resources in one region" implies that I should be able to set it to multi-region, but it's not in that menu.

0 2 144
2 REPLIES 2