WIP: UDF for Google Address Validation API in Snowflake Native App
A
Ambuj Srivastava
started a topic
about 1 hour ago
Introduction
There is a limitation with Snowflake Native Apps to execute the plug-ins/Rest API enrichers due to Snowflake hybrid tables. This limitation cause integration jobs to fail with errors:
Need
The need of this UDF is to replace the error during REST API calls made from application when multiple records gets processes in any integration job.
Summarized Solution
The solution contains the steps to be performed at Snowflake database and Semarchy xDM design to call the function in enricher.
Detailed Solution
Title
Google Address validation API using UDF in Snowflake Native App.
1. Overview
This document describes how to configure Snowflake to call the Google Address Validation API securely using:
● Snowflake Secrets
● Network Rules
● External Access Integration (EAI)
● A Python UDF
● Role-based access control (RBAC)
This setup enables address validation directly within Snowflake SQL queries.
2. Architecture Overview
The solution includes:
1. Secure storage of Google API key using Snowflake Secret
2. Controlled outbound access via Network Rule
3. Secure API invocation via External Access Integration
Ambuj Srivastava
Introduction
There is a limitation with Snowflake Native Apps to execute the plug-ins/Rest API enrichers due to Snowflake hybrid tables. This limitation cause integration jobs to fail with errors:
Need
The need of this UDF is to replace the error during REST API calls made from application when multiple records gets processes in any integration job.
Summarized Solution
The solution contains the steps to be performed at Snowflake database and Semarchy xDM design to call the function in enricher.
Detailed Solution
Title
Google Address validation API using UDF in Snowflake Native App.
1. Overview
This document describes how to configure Snowflake to call the Google Address Validation API securely using:
● Snowflake Secrets
● Network Rules
● External Access Integration (EAI)
● A Python UDF
● Role-based access control (RBAC)
This setup enables address validation directly within Snowflake SQL queries.
2. Architecture Overview
The solution includes:
1. Secure storage of Google API key using Snowflake Secret
2. Controlled outbound access via Network Rule
3. Secure API invocation via External Access Integration
4. Python-based User Defined Function (UDF) that:
○ Calls Google Address Validation API
○ Normalizes and validates address input
○ Returns structured output as VARIANT (JSON)
Section