Run the following command to create an authorization object to access external object store:
CREATE AUTHORIZATION MyAuthObj USER 'user_name' PASSWORD 'password';
Where:
- user_name is the ACCESS_KEY or Storage Account Name to your external object store.
- password is the secret access key, Key, SAS Token, or Secure Email and Secret Access Key depending on your external object store.
If you are accessing a public bucket or container, put empty strings for USER and PASSWORD, enclosed in straight quotes, such as:
CREATE AUTHORIZATION MyAuthObj USER '' PASSWORD '';
Associate the AUTHORIZATION OBJECT with a Foreign Table
CREATE FOREIGN TABLE riverflow_csv , EXTERNAL SECURITY MyAuthObj USING ( LOCATION('/s3/td-usgs-public.s3.amazonaws.com/CSVDATA/') );