title: How to import from a bucket in the S3 eu-west-1 region?
body: <p>I try to bulk import into a cockroach db from a S3 bucket in the eu-west-1 region</p>
  
  <pre><code>IMPORT TABLE osm.nodes (
          id INT PRIMARY KEY,
          version INT NOT NULL,
          lat DECIMAL NOT NULL,
          lon DECIMAL NOT NULL,
          changeset_id INT NOT NULL,
          visible BOOLEAN NOT NULL
      )
      CSV DATA ('s3://cockroach-import/nodes.csv?AWS_ACCESS_KEY_ID=&lt;snip&gt;&amp;AWS_SECRET_ACCESS_KEY=&lt;snip&gt;')
      WITH
          temp = 's3://cockroach-import/?AWS_ACCESS_KEY_ID=&lt;snip&gt;&amp;AWS_SECRET_ACCESS_KEY=&lt;snip&gt;',
          delimiter = ','
      ;
  </code></pre>
  
  <p>I get the error message:</p>
  
  <pre><code>failed to create s3 reader: 400: "The authorization header is malformed; the region 'us-east-1' is wrong; expecting 'eu-west-1'"
  </code></pre>
  
  <p>How can I specify the S3 region in the import statement?</p>