Introduction

The objective of this document is to help snowflake users to start utilizing their External User Defined Functions. Also, it does not require any software installation, users can work with their normal browsers.

There are certain roles, which Snowflake considers as an administrator. For example, ACCOUNTADMIN can create API Integration and External User Defined Functions.

After ‘ACCOUNTADMIN’ created above items in Snowflake, it is expected that execution rights to be given to other roles. The script in this document uses the ‘SYSADMIN’ role to perform geocode operation. In the actual Snowflake environment, it can be any role. Now, Snowflake users can perform any GeoAddressing operations like Geocode and Verify.

These are the steps to be performed to get the Geocode/ Verify Result:
  1. Select Environment.
  2. Create API Integration.
  3. Create External Defined Function.
  4. Grant required permission to the user to perform Geocode/ Verify operation.
  5. Perform Geocode/ Verify operation.
  6. Validate results.