DEA-C02 Data Movement — All Questions With Answers

COPY INTO my_table
FROM @my_stage/raw_data/
FILE_FORMAT = (TYPE = 'CSV' SKIP_HEADER = 1)
ON_ERROR = 'SKIP_FILE_10%'
PURGE = TRUE;

SELECT 
  $1:id::int, 
  $1:customer_name::string, 
  $1:metadata:source_ip::string 
FROM @my_internal_stage/logs/ (FILE_FORMAT => 'my_json_format');

COPY INTO orders_table
FROM @landing_zone/raw_data/
FILE_FORMAT = (TYPE = 'CSV' SKIP_HEADER = 1)
PATTERN = '.*orders.*\.csv'
ON_ERROR = 'ABORT_STATEMENT';

CREATE EXTERNAL TABLE ext_sales (
  id INT AS (value:id::int),
  amount FLOAT AS (value:amount::float),
  sale_date DATE AS (to_date(value:date::string))
)
LOCATION=@my_s3_stage/sales/
FILE_FORMAT=(TYPE=JSON)
AUTO_REFRESH=true;