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 GeoTAX operation. In the actual Snowflake environment, it can be any role. Now, Snowflake users can perform any GeoTAX operations like Location and Address.
These are the steps to be performed to get results:
- Select Environment.
- Create API Integration.
- Create External Defined Function.
- Grant required permission to the user to perform GeoTAX Location/Address operation.
- Perform GeoTAX Location/Address operation.
- Validate results.