2 Replies Latest reply on Sep 7, 2018 12:56 AM by Shakib Mohammad

    Cannot process data across locations: EU,US

    Shakib Mohammad

      Hi,

       

      I am getting an error "Cannot process data across locations: EU, US" while making joins between two tables.

       

      Source:- BigQuery (Google Cloud Platform)

       

      Error Message:-

       

      {"ts":"2018-08-11T12:59:57.895","pid":15116,"tid":"3218","sev":"warn","req":"-","sess":"-","site":"-","user":"-","k":"msg","v":"HTTPRequestor::DoWork::HTTPException 400 https://www.googleapis.com:443/bigquery/v2/projects/aac-dw-dev/queries {\n \"error\": {\n  \"errors\": [\n {\n    \"domain\": \"global\",\n    \"reason\": \"invalid\",\n    \"message\": \"Cannot process data across locations: EU,US\"\n }\n  ],\n  \"code\": 400,\n  \"message\": \"Cannot process data across locations: EU,US\"\n }\n}\n","ctx":{"client-type":"desktop","procid":"15672","tid":"12868","version":"20182.18.0627.2230"}}

       

      Any help would be appriciated.

       

      Thanks in advance.