Identifying internal and external schemas
Continuing to troubleshoot the performance on the coffee county weather table, you decide to check if its schema, public_intro_redshift, is internal or external so you can chose the next step to improve it's performance.
Bu egzersiz
Introduction to Redshift
kursunun bir parçasıdırEgzersiz talimatları
- Select the schema name and type from the all schemas system view.
- Order the results by the schema name.
Uygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
-- Query the schema name and type
SELECT ___,
___
-- Use the proper system view to via all schemas
FROM ___
-- Sort by the schema name
ORDER BY ___;