Exercise

Find what schema a table is in

We can use either SVV_REDSHIFT_TABLES or SVV_ALL_TABLES to see details about tables such as database name, schema name, and more. These views act as a window into the internal structure of Redshift, allowing you to explore and understand the organization of your data.

Leverage one of those views to determine which schema the ecommerce_sales table belongs to.

Instructions

50 XP

Possible answers

information_schema

datacamp_course_prod

spectrumdb

local

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}Exercise

Instructions

Possible answers

Exercise