This section is designed to help Snowflake users get started with using External User Defined Functions.
Tip: No software installation is needed. You can use your regular web browser.
Snowflake recognizes certain roles as administrators. For example, the ACCOUNTADMIN role can create API Integration and External User Defined Functions.
After the ACCOUNTADMIN creates these items in Snowflake, it is expected that execution rights will be granted to other roles.
The script in this document uses the SYSADMIN role to perform the Geocode operation.
Important: In your actual Snowflake environment, you can use any role that has the necessary permissions.
Snowflake users can perform various GeoAddressing operations, such as Geocode and Verify.
Follow these steps to get the Geocode or Verify results:
- : Select the environment.
- : Create the API Integration.
- : Create the External Defined Function.
- Grant the required permissions to the user to perform the Geocode or Verify operation.
- Perform the Geocode or Verify operation.
- Validate the results.