MemSQL Telco Customer Churn Dataset

schema.sql

DROP DATABASE IF EXISTS churn_example;
CREATE DATABASE churn_example;
USE churn_example;

CREATE TABLE telco_customer_churn
(
    customerID TEXT,
    gender TEXT,
    SeniorCitizen BOOLEAN,
    Partner TEXT,
    Dependents TEXT,
    tenure INT,
    PhoneService TEXT,
    MultipleLines TEXT,
    InternetService TEXT,
    OnlineSecurity TEXT,
    OnlineBackup TEXT,
    DeviceProtection TEXT,
    TechSupport TEXT,
    StreamingTV TEXT,
    StreamingMovies TEXT,
    Contract TEXT,
    PaperlessBilling TEXT,
    PaymentMethod TEXT,
    MonthlyCharges DECIMAL(13, 4),
    TotalCharges DECIMAL(13, 4),
    Churn TEXT,
    PRIMARY KEY (customerID)
);

CREATE or REPLACE PIPELINE `telco_customer_churn` AS
    LOAD DATA S3 'download.memsql.com/first-time/WA_Fn-UseC_-Telco-Customer-Churn.csv'
    CONFIG '{"region": "us-east-1"}'
    SKIP DUPLICATE KEY ERRORS
    INTO TABLE `telco_customer_churn`
    FIELDS
        TERMINATED BY ','
        OPTIONALLY ENCLOSED BY '"'
    IGNORE 1 LINES;

START PIPELINE `telco_customer_churn` FOREGROUND;