Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I'm with problems to load my data, someone could help me with that please?
I don't know whats is happening, because in a month ago It was working normally, and suddenly, the same script, the same data, was not working.
Someone know how to fix that?
follow the loading script:
LIB CONNECT TO [Global:Athena];
LOAD
*;
[sessions]:
SELECT
id as session,
kind as kind_session,
ticket,
agent,
queue,
channel,
provider,
"started_at",
"finished_at",
"year",
"month"
FROM AwsDataCatalog."customer_cx".sessions;
LIB CONNECT TO [Global:Athena];
LOAD
*;
[queues]:
SELECT
"id" as queue,
"name" as queue_name,
"channel",
"area" as queue_area,
if("country" = 'BR' , 'BRASIL' , 'MEXICO') as queue_country
FROM AwsDataCatalog."customer_cx".queues;
LIB CONNECT TO [Global:Athena];
LOAD
*;
[eventline]:
SELECT
ticket,
agent,
channel,
provider,
queue,
date(moment) as moment,
event,
kind as eventline_kind,
payload
FROM AwsDataCatalog."customer_cx".eventline;
LIB CONNECT TO [Global:Athena];
LOAD
*;
[daily_vision]:
SELECT
"date",
if("country" = 'BR' , 'BRASIL' , 'MEXICO') as daily_vision_country,
"active_drivers"
FROM AwsDataCatalog.enrichments."daily_vision";
LIB CONNECT TO [Global:Athena];
LOAD
*;
[tickets]:
SELECT
id as ticket,
"created_at",
driver as driver_id,
city as ticket_city,
state as ticket_state,
if("country" = 'BR' , 'BRASIL' , 'MEXICO') as ticket_country,
direction,
"conversation_segment_link",
"ticket_rating",
"caller_phone",
"dialed_number"
FROM AwsDataCatalog."customer_cx".tickets;
LIB CONNECT TO [Global:Athena];
LOAD
*;
[channels]:
SELECT id as channel,
name as channel_name,
kind as channel_kind,
provider
FROM AwsDataCatalog."customer_cx".channels;
LIB CONNECT TO [Global:Athena];
LOAD
*;
[agents]:
SELECT id as agent,
email
FROM AwsDataCatalog."customer_cx".agents;
LIB CONNECT TO [Global:Athena];
LOAD
*;
[providers]:
SELECT id as provider,
name as provider_name
FROM AwsDataCatalog."customer_cx".providers;
LIB CONNECT TO [Global:Athena];
LOAD
"date_moment",
country,
active_drivers;
[daily_vision]:
SELECT "date" as date_moment,
country,
active_drivers
FROM AwsDataCatalog.enrichments."daily_vision";