Badge 1: Data Warehousing Workshop

You created the schema called VEGGIES but when you run the SHOW SCHEMAS command (see above) it does not appear. Assuming your current worksheet role has access to the schema, what could you do to make the schema appear in the results?

1. Change your default role to SYSADMIN (and run again).
2. Set the worksheet database drop menu to GARDEN_PLANTS (and run again).
3. Set the worksheet warehouse drop menu to VEGGIES_WH (and run again).
4. Add "all" to the show schemas command (and run again).
5. Add "in account" to the show schemas command (and run again).
6. Add "where schema = 'VEGGIES' " to the show schemas command (and run again).