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.
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
use role accountadmin;
create or replace external function util_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, current_account_name)
as 'https://awy6hshxy4.execute-api.us-west-2.amazonaws.com/dev/edu_dora/grader'
;
Troubleshooting the Grader
If you cannot find your integration or grader, consider some of the options below.
