redshift_create_table_commands.txt

create schema airlines;

CREATE TABLE airlines.dim_airport_codes (
    airport_id BIGINT,
    city VARCHAR(100),
    state VARCHAR(100),
    name VARCHAR(200)
);

COPY airlines.dim_airport_codes
FROM 's3://airlines-data-ingestion-project/airport_dim/airports_codes.csv' 
IAM_ROLE 'arn:aws:iam::203918882713:role/service-role/AmazonRedshift-CommandsAccessRole-20250113T164521'
DELIMITER ','
IGNOREHEADER 1
REGION 'eu-north-1';

SELECT * from airlines.dim_airport_codes limit 5;

CREATE TABLE airlines.daily_flights_processed (
    carrier VARCHAR(10),
    dep_airport VARCHAR(200),
    arr_airport VARCHAR(200),
    dep_city VARCHAR(100),
    arr_city VARCHAR(100),
    dep_state VARCHAR(100),
    arr_state VARCHAR(100),
    dep_delay BIGINT,
    arr_delay BIGINT
);

SELECT * from airlines.daily_flights_processed LIMIT 5;

SELECT count(*) from airlines.daily_flights_processed;