Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
elislopes261
Contributor
Contributor

error loading data

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";

 

0 Replies