Paste code

CREATE EXTERNAL TABLE d_mdl_vpc_disc.mm_barrido_agenda
(
    `numruc` string,
    `num_doc` string,
    `flg_contacto_efectivo_1m` int,
    `flg_gestionado_1m` int,
    `flg_lo_pensara_creditos_nuevos_1m` int
)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
STORED AS TEXTFILE
LOCATION 's3://sagemaker-us-east-1-058528764918/vpc/propension/athena/MM_BARRIDO_informal/'
TBLPROPERTIES (
    'skip.header.line.count'='1',
    'has_encrypted_data'='false'
);