'Error of location with EXECUTE IMMEDIATE on Bigquery

when I use the command:

EXECUTE IMMEDIATE """
EXPORT DATA OPTIONS(
  uri='gs://archivage_base/archive1_@EXPORT_DATE*.csv',
  format='CSV',
  overwrite=true,
  header=true,
  field_delimiter=';') AS
SELECT * FROM `base-042021.campagnemakers.makerlocal`
"""
using current_date() as EXPORT_DATE

I have this error:

Not found: Datasetbase-042021:campagnemakers was not found in location US at [2:1]

I don't understand why because i don't have the error without the command EXECUTE IMMEDIATE. My location is EU.

google-bigquery

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'Error of location with EXECUTE IMMEDIATE on Bigquery

Sources

Related Questions