Function Mapping for WRITE_NOS | CREATE FUNCTION MAPPING | Teradata Vantage - Example: Function Mapping for WRITE_NOS - Teradata Vantage - Analytics Database

SQL Data Definition Language Syntax and Examples

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-11-06
dita:mapPath
jco1628111346878.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
mdr1472255012272
lifecycle
latest
Product Category
Teradata Vantage™
This statement creates the function mapping NOS_Writer for the WRITE_NOS table operator using the authorization MyObjAuth.
To create a function mapping for WRITE_NOS, you must have the EXECUTE FUNCTION privilege on WRITE_NOS.
For information about the WRITE_NOS table operator, see Teradata Vantage™ - SQL Data Manipulation Language, B035-1146.

Create an authorization object called MyObjAuth:

CREATE AUTHORIZATION MyObjAuth
 AS DEFINER TRUSTED
     USER 'YOUR-ACCESS-KEY-ID'
     PASSWORD 'YOUR-SECRET-ACCESS-KEY';

Create the function mapping for WRITE_NOS:

CREATE FUNCTION MAPPING NOS_Writer
FOR WRITE_NOS
EXTERNAL SECURITY DEFINER TRUSTED MyObjAuth
USING
LOCATION,
STOREDAS,
NAMING,
MANIFESTFILE,
MANIFESTONLY,
OVERWRITE,
INCLUDE_ORDERING,
INCLUDE_HASHBY,
MAXOBJECTSIZE,
COMPRESSION,
ANY IN TABLE;