Snowflake - Build and Architect Data Pipelines Using AWS - Lab - Create External Function in Snowflake

This video tutorial guides you through the process of setting up an external function in Snowflake that interacts with an AWS API Gateway and Lambda function. It covers creating an integration object, configuring IAM trust policies, and finally creating and testing the external function for currency conversion. The tutorial provides step-by-step instructions and highlights key considerations such as using the correct IAM roles and ensuring no spaces in copied values.

What is the first step in creating an external function in Snowflake?

• Create an integration object

• Set up a Lambda function

• Create an IAM role

• Configure API Gateway

Which role is required to create an integration object in Snowflake?

• Database Admin

• Security Admin

• Account Admin

• User Admin

What value needs to be copied for the API allowed prefixes?

• Lambda Function Name

• API Gateway ID

• Resource Invocation URL

• IAM Role ARN

Where do you paste the API AWS IAM user ARN in the trust policy?

• Line #5

• Line #7

• Line #9

• Line #11

What is the purpose of the external function created in Snowflake?

• To store data in S3

• To convert currency values

• To manage user roles

• To monitor API usage

What parameters does the external function take?

• Currency codes

• User IDs

• API keys

• Database names

What is the expected output of the external function?

• A JSON object

• A string message

• A variant

• An integer