This section describes the requirements for creating external defined function named 'verify' by using these examples.
Below important headers must be passed in external defined function:
- headers-api-key: It expects DIS API's production environment key.
- headers-api-secret: It expects DIS API's production environment secret.
- application: Snowflake users need to define
dis-geoaddressing.
The below script is used for input addresses and expects JSON object as an input
parameter.
create or replace external function verify(address object)
returns variant
IMMUTABLE
api_integration = API_INTEGRATION
HEADERS = ('headers-api-key'= '<<API KEY>>', 'headers-api-secret'='<<API SECRET>>')
MAX_BATCH_ROWS = 1000
as 'https://w5mgkth0zg.execute-api.us-east-1.amazonaws.com/v1/verify';