Simply can't thank you enough for all your educational dbt videos. I am learning so much from you! I wanted to ask you if you could make a tutorial on how to deal with and resolve problems related to dataset location when attempting to build destination tables at a different location than the source tables, specifically in Google Cloud. First and foremost, is it even possible to build a table in destination, say EU, when your source tables are in location US? The kind of errors I sporadically get are: "Runtime Error in model int_ecommerce__order_items_products (models/example/intermediate/int_ecommerce__order_items_products.sql) 404 Not found: Dataset `project_id`:`dataset_id` was not found in location US; reason: notFound, message: Not found: Dataset `project_id`:`dataset_id` was not found in location US" The issue is though that I don't want it to look in location US, but instead in EU where it is actually located. Is there a way to configure this in dbt Core and/or dbt Cloud? Many thanks in advance!
►► The Starter Guide for Modern Data (Free Guide) → www.kahandatasolutions.com/startermds
The Playbook for dbt - bit.ly/playbookdbt
Using dbt does give me the feeling of software dev, since it supports version controlling, macros (like func) and tests.
Oh, and ready-to-use packages is great too.
Simply can't thank you enough for all your educational dbt videos. I am learning so much from you! I wanted to ask you if you could make a tutorial on how to deal with and resolve problems related to dataset location when attempting to build destination tables at a different location than the source tables, specifically in Google Cloud. First and foremost, is it even possible to build a table in destination, say EU, when your source tables are in location US? The kind of errors I sporadically get are: "Runtime Error in model int_ecommerce__order_items_products (models/example/intermediate/int_ecommerce__order_items_products.sql)
404 Not found: Dataset `project_id`:`dataset_id` was not found in location US; reason: notFound, message: Not found: Dataset `project_id`:`dataset_id` was not found in location US"
The issue is though that I don't want it to look in location US, but instead in EU where it is actually located. Is there a way to configure this in dbt Core and/or dbt Cloud? Many thanks in advance!