Skip to main content

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. 

If you'd like to, you can watch the 5 minute step-by-step video and follow along. If you have previous database experience, you won't probably need to watch the video. 

Demo Video of GRADER Setup Process


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 = ('');


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 ''

Troubleshooting the Grader

If you cannot find your integration or grader, consider some of the options below.

This is the image alt text. This is the image alt text.