The example uses the AUTHORIZATION keyword with an authorization object to provide credentials to external object store.
- Set up or obtain access to the external object store where you want to write data. Follow the instructions from your external storage vendor.
- If not already done, have an administrative user create the authorization object that has the credential to the bucket. See Controlling Foreign Table Access with an AUTHORIZATION Object.
- Use WRITE_NOS with the AUTHORIZATION keyword:
SELECT * FROM WRITE_NOS ( ON ( SELECT * FROM RiverFlowPerm WHERE DateTime = '2018-06-27 00:00:00' ) USING LOCATION('/S3/s3.amazonaws.com/iewritenostest/RiverFlowPerm2/') AUTHORIZATION(MyAuthObj) STOREDAS('PARQUET') ) AS d;Replace LOCATION with the URI to the external object store where you are writing the data.
Your result will be similar to the following:
NodeId AmpId Sequence ObjectName ------ ----- -------- ------------------------------------------------------------------------ 33 0 1 /S3/s3.amazonaws.com/ie-writenos-bucket/20180701_auth_example/object_33_0_1.parquet 33 1 1 /S3/s3.amazonaws.com/ie-writenos-bucket/20180701_auth_example/object_33_1_1.parquet 33 2 1 /S3/s3.amazonaws.com/ie-writenos-bucket/20180701_auth_example/object_33_2_1.parquet
Prerequisites
Use AUTHORIZATION Keyword