Sample Redshift External Function

Sample redshift external function definitions

Sample Redshift External Function

Method: Tokenization

Type: ALPHA

 

Redshift Data Types

Redshift Max Size

Protegrity Max Size

VARCHAR

4K (4,096 bytes)

4K (4,096 bytes)

CHAR

 

 

 

External Function Sample Definitions:

CREATE EXTERNAL FUNCTION PTY_PROTECT_ALPHA ( val varchar )
RETURNS varchar
VOLATILE lambda
'<replace_with_protect_function_name>:Production' iam_role 'arn:aws:iam::<REPLACE_WITH_YOUR_AWS_ACCOUNT>:role/<REPLACE_WITH_IAM_ROLE_NAME>';

 

Sample EF Calls:

SELECT PTY_PROTECT_ALPHA ('Hello World');

SELECT PTY_UNPROTECT_ALPHA('rfDtw sLMJK');

 

 

Method: Tokenization

Type: NUMERIC

 

Redshift Data Types

Redshift Max Size

Protegrity Max Size

DECIMAL

4K (4,096 bytes)

4K (4,096 bytes)

INTEGER

BIGINT

 

 

External Function Sample Definitions:

CREATE OR REPLACE EXTERNAL FUNCTION PTY_PROTECT_NUMERIC ( val int )
RETURNS int
VOLATILE lambda
'<replace_with_protect_function_name>:Production' iam_role 'arn:aws:iam::<REPLACE_WITH_YOUR_AWS_ACCOUNT>:role/<REPLACE_WITH_IAM_ROLE_NAME>';

 

Sample EF Calls:

SELECT PTY_PROTECT_NUMERIC (2147483647);

SELECT PTY_UNPROTECT_NUMERIC(-12344556564);

Last modified : December 04, 2025