This statement creates the function mapping NOS_Reader for the READ_NOS table operator using the authorization InvAuth_S3 and specifying a location on Amazon S3.
To create a function mapping for READ_NOS, you must have the EXECUTE FUNCTION privilege on READ_NOS.
For information about the READ_NOS table operator, see
Teradata Vantage™ - SQL Data Manipulation Language, B035-1146.Create an authorization object called InvAuth_S3:
CREATE AUTHORIZATION InvAuth_S3
AS INVOKER TRUSTED
USER 'YOUR-ACCESS-KEY-ID'
PASSWORD 'YOUR-SECRET-ACCESS-KEY';
Create the function mapping for READ_NOS:
CREATE FUNCTION MAPPING NOS_Reader
FOR READ_NOS
EXTERNAL SECURITY INVOKER TRUSTED InvAuth_S3 USING
LOCATION('/S3/td-usgs.s3.amazonaws.com/td-usgs/JSONDATA/');