DORA Auto-Grader
To use the DORA Auto-grader you need to run two set up scripts. You'll run an API Integration set-up script once per Snowflake account. You'll also need to run a script that creates a function called GRADER. You can run this so that you create multiple copies of the grader function - in many different databases and schemas, or you can create it in just one Database.Schema and use qualifiers to run it.
Watch the 3 minute video first, if you'd like.
API INTEGRATION
Run this code once per Snowflake Trial Account.
use role accountadmin;
create or replace api integration dora_api_integration
api_provider = aws_api_gateway
api_aws_role_arn = 'arn:aws:iam::321463406630:role/snowflakeLearnerAssumedRole'
enabled = true
api_allowed_prefixes = ('https://awy6hshxy4.execute-api.us-west-2.amazonaws.com/dev/edu_dora');
GRADER FUNCTION
Run this code once per Database.
use role accountadmin;
create or replace external function demo_db.public.grader(
step varchar
, passed boolean
, actual integer
, expected integer
, description varchar)
returns variant
api_integration = dora_api_integration
context_headers = (current_timestamp,current_account, current_statement)
as 'https://awy6hshxy4.execute-api.us-west-2.amazonaws.com/dev/edu_dora/grader'
;
Troubleshooting the Grader
Watch this video to learn more about context, ownership, and transferring ownership. The video is not quick but it covers many common issues people have when trying to set up the GRADER and use it.
Launch video
