topic error loading data in Qlik Compose

topic error loading data in Qlik Compose https://community.qlik.com/t5/Qlik-Compose/error-loading-data/m-p/2056349#M1800 <P>Hello, I'm with problems to load my data, someone could help me with that please? </P> <P>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. </P> <P>Someone know how to fix that? </P> <P> </P> <P> </P> <P>follow the loading script:</P> <P> </P> <P> </P> <P>LIB CONNECT TO [Global:Athena];</P> <P>LOAD<BR />*;</P> <P>[sessions]:<BR />SELECT <BR />id as session,<BR />kind as kind_session,<BR />ticket,<BR />agent,<BR />queue,<BR />channel,<BR />provider,<BR />"started_at",<BR />"finished_at",<BR />"year",<BR />"month"<BR />FROM AwsDataCatalog."customer_cx".sessions;</P> <P>LIB CONNECT TO [Global:Athena];</P> <P>LOAD<BR />*;</P> <P>[queues]:<BR />SELECT <BR />"id" as queue,<BR />"name" as queue_name,<BR />"channel",<BR />"area" as queue_area,<BR />if("country" = 'BR' , 'BRASIL' , 'MEXICO') as queue_country<BR />FROM AwsDataCatalog."customer_cx".queues;</P> <P>LIB CONNECT TO [Global:Athena];</P> <P>LOAD<BR />*;</P> <P>[eventline]:<BR />SELECT <BR />ticket,<BR />agent,<BR />channel,<BR />provider,<BR />queue,<BR />date(moment) as moment,<BR />event,<BR />kind as eventline_kind,<BR />payload <BR />FROM AwsDataCatalog."customer_cx".eventline;</P> <P>LIB CONNECT TO [Global:Athena];</P> <P>LOAD<BR />*;</P> <P>[daily_vision]:<BR />SELECT <BR />"date",<BR />if("country" = 'BR' , 'BRASIL' , 'MEXICO') as daily_vision_country,<BR />"active_drivers"<BR />FROM AwsDataCatalog.enrichments."daily_vision";</P> <P>LIB CONNECT TO [Global:Athena];</P> <P><BR />LOAD<BR />*;</P> <P>[tickets]:<BR />SELECT <BR />id as ticket,<BR />"created_at",<BR />driver as driver_id,<BR />city as ticket_city,<BR />state as ticket_state,<BR />if("country" = 'BR' , 'BRASIL' , 'MEXICO') as ticket_country,<BR />direction,<BR />"conversation_segment_link",<BR />"ticket_rating",<BR />"caller_phone",<BR />"dialed_number"<BR />FROM AwsDataCatalog."customer_cx".tickets;</P> <P>LIB CONNECT TO [Global:Athena];</P> <P>LOAD<BR />*;</P> <P>[channels]:<BR />SELECT id as channel,<BR />name as channel_name,<BR />kind as channel_kind,<BR />provider<BR />FROM AwsDataCatalog."customer_cx".channels;</P> <P>LIB CONNECT TO [Global:Athena];</P> <P><BR />LOAD<BR />*;</P> <P>[agents]:<BR />SELECT id as agent,<BR />email<BR />FROM AwsDataCatalog."customer_cx".agents;</P> <P>LIB CONNECT TO [Global:Athena];</P> <P><BR />LOAD<BR />*;</P> <P>[providers]:<BR />SELECT id as provider,<BR />name as provider_name<BR />FROM AwsDataCatalog."customer_cx".providers;</P> <P><BR />LIB CONNECT TO [Global:Athena];</P> <P><BR />LOAD<BR />"date_moment",<BR />country,<BR />active_drivers;</P> <P>[daily_vision]:<BR />SELECT "date" as date_moment,<BR />country,<BR />active_drivers<BR />FROM AwsDataCatalog.enrichments."daily_vision";</P> <P> </P> Thu, 20 Mar 2025 15:56:15 GMT elislopes261 2025-03-20T15:56:15Z error loading data https://community.qlik.com/t5/Qlik-Compose/error-loading-data/m-p/2056349#M1800 <P>Hello, I'm with problems to load my data, someone could help me with that please? </P> <P>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. </P> <P>Someone know how to fix that? </P> <P> </P> <P> </P> <P>follow the loading script:</P> <P> </P> <P> </P> <P>LIB CONNECT TO [Global:Athena];</P> <P>LOAD<BR />*;</P> <P>[sessions]:<BR />SELECT <BR />id as session,<BR />kind as kind_session,<BR />ticket,<BR />agent,<BR />queue,<BR />channel,<BR />provider,<BR />"started_at",<BR />"finished_at",<BR />"year",<BR />"month"<BR />FROM AwsDataCatalog."customer_cx".sessions;</P> <P>LIB CONNECT TO [Global:Athena];</P> <P>LOAD<BR />*;</P> <P>[queues]:<BR />SELECT <BR />"id" as queue,<BR />"name" as queue_name,<BR />"channel",<BR />"area" as queue_area,<BR />if("country" = 'BR' , 'BRASIL' , 'MEXICO') as queue_country<BR />FROM AwsDataCatalog."customer_cx".queues;</P> <P>LIB CONNECT TO [Global:Athena];</P> <P>LOAD<BR />*;</P> <P>[eventline]:<BR />SELECT <BR />ticket,<BR />agent,<BR />channel,<BR />provider,<BR />queue,<BR />date(moment) as moment,<BR />event,<BR />kind as eventline_kind,<BR />payload <BR />FROM AwsDataCatalog."customer_cx".eventline;</P> <P>LIB CONNECT TO [Global:Athena];</P> <P>LOAD<BR />*;</P> <P>[daily_vision]:<BR />SELECT <BR />"date",<BR />if("country" = 'BR' , 'BRASIL' , 'MEXICO') as daily_vision_country,<BR />"active_drivers"<BR />FROM AwsDataCatalog.enrichments."daily_vision";</P> <P>LIB CONNECT TO [Global:Athena];</P> <P><BR />LOAD<BR />*;</P> <P>[tickets]:<BR />SELECT <BR />id as ticket,<BR />"created_at",<BR />driver as driver_id,<BR />city as ticket_city,<BR />state as ticket_state,<BR />if("country" = 'BR' , 'BRASIL' , 'MEXICO') as ticket_country,<BR />direction,<BR />"conversation_segment_link",<BR />"ticket_rating",<BR />"caller_phone",<BR />"dialed_number"<BR />FROM AwsDataCatalog."customer_cx".tickets;</P> <P>LIB CONNECT TO [Global:Athena];</P> <P>LOAD<BR />*;</P> <P>[channels]:<BR />SELECT id as channel,<BR />name as channel_name,<BR />kind as channel_kind,<BR />provider<BR />FROM AwsDataCatalog."customer_cx".channels;</P> <P>LIB CONNECT TO [Global:Athena];</P> <P><BR />LOAD<BR />*;</P> <P>[agents]:<BR />SELECT id as agent,<BR />email<BR />FROM AwsDataCatalog."customer_cx".agents;</P> <P>LIB CONNECT TO [Global:Athena];</P> <P><BR />LOAD<BR />*;</P> <P>[providers]:<BR />SELECT id as provider,<BR />name as provider_name<BR />FROM AwsDataCatalog."customer_cx".providers;</P> <P><BR />LIB CONNECT TO [Global:Athena];</P> <P><BR />LOAD<BR />"date_moment",<BR />country,<BR />active_drivers;</P> <P>[daily_vision]:<BR />SELECT "date" as date_moment,<BR />country,<BR />active_drivers<BR />FROM AwsDataCatalog.enrichments."daily_vision";</P> <P> </P> Thu, 20 Mar 2025 15:56:15 GMT https://community.qlik.com/t5/Qlik-Compose/error-loading-data/m-p/2056349#M1800 elislopes261 2025-03-20T15:56:15Z