Loading CSV Data (COPY)

Problem

A vendor just dropped a 50GB CSV file in an S3 bucket. Inserting the rows one-by-one with standard INSERT statements would take 3 days. Write a query that outputs command with the value: "The COPY command is commonly used to bulk load CSV data from object storage into a data warehouse."

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