Snowflake Badge - DWW09 not passing but can't tell why(!)
I created the streamlit app as per instructions. The app works just fine and writes the fruit and root depth to garden_plants.fruits.fruit_details, but when I run the test script as presented:
--Set your worksheet drop list role to ACCOUNTADMIN --Set your worksheet drop list database and schema to the location of your GRADER function
-- DO NOT EDIT ANYTHING BELOW THIS LINE. THE CODE MUST BE RUN EXACTLY AS IT IS WRITTEN select GRADER(step, (actual = expected), actual, expected, description) as graded_results from ( SELECT 'DWW09' as step ,( select iff(count()=0, 0, count()/count(*)) from snowflake.account_usage.query_history where query_text like 'execute streamlit "GARDEN_PLANTS"."FRUITS".%' ) as actual , 1 as expected ,'SiS App Works' as description );
it fails with output: GRADED_RESULTS [ { "_": "⛔", "actual": 0, "description": "SiS App Works", "expected": 1, "passed": false, "step": "DWW09" } ]
I'm wondering about the tests reference to "query_text like 'execute streamlit "GARDEN_PLANTS"."FRUITS".%'"
In the instructions the picture for when you create the streamlit app has inputs for a location (garden_plans.fruits); however, when I created the streamlit app I was not prompted for a location, only "Add New -> Streamlit App _> Title, Compute Pool, Query Warehouse" ... maybe they changed something?
EDIT: I did also try going to the app, and clicked 'Deploy' - after which I AM prompted for location, added it to the fruits schema, used it once, and Dora still failed it. I would have thought that might create the 'execute streamlit "GARDEN_PLANTS"."FRUITS".%' it is looking for.