This section describes the requirements for creating external defined function named 'geocode' 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.
create or replace external function geocode(address object)
returns variant
IMMUTABLE
api_integration = API_INTEGRATION
HEADERS = ('headers-api-key'= KEY, 'headers-api-secret'=SECRET')
MAX_BATCH_ROWS = 1000
as 'https://w5mgkth0zg.execute-api.us-east-1.amazonaws.com/v1/geocode';