File: create_external_function.sql

package info (click to toggle)
sqlfluff 3.5.0-2
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 34,000 kB
  • sloc: python: 106,131; sql: 34,188; makefile: 52; sh: 8
file content (18 lines) | stat: -rw-r--r-- 455 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
 
CREATE EXTERNAL FUNCTION exfunc_sum(INT,INT)
RETURNS INT
STABLE
LAMBDA 'lambda_sum'
IAM_ROLE 'arn:aws:iam::123456789012:role/Redshift-Exfunc-Test';

CREATE OR REPLACE EXTERNAL FUNCTION exfunc_upper()
RETURNS varchar
STABLE
LAMBDA 'exfunc_sleep_3'
IAM_ROLE 'arn:aws:iam::123456789012:role/Redshift-Exfunc-Test'
RETRY_TIMEOUT 0;

CREATE OR REPLACE EXTERNAL FUNCTION exfunc_foo(varchar)
RETURNS int
IMMUTABLE
SAGEMAKER 'some_endpoint_name'
IAM_ROLE default;