Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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