Creating an External Table

Problem

Your boss doesn't want to pay to duplicate 100 Terabytes of historical logs from S3 into Redshift, but still wants you to run occasional SQL queries on it. Write a query that outputs concept with the value: "External tables allow querying data directly from a data lake without moving it into the database storage."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution