AWS announces preview of AWS Interconnect - multicloud

AWS announces AWS Interconnect – multicloud (preview), providing simple, resilient, high-speed private connections to other cloud service providers. AWS Interconnect - multicloud is easy to configure and provides high-speed, resilient connectivity with dedicated bandwidth, enabling customers to interconnect AWS networking services such as AWS Transit Gateway, AWS Cloud WAN, and Amazon VPC to other cloud service providers with ease.

Need help on CloudQuest Cloud Data Warehouse LAB

-1

on this lab I have created a materialized view as following:

by player (mv_players_purchases_amount)-

SELECT g.id as Id, p.name as Name, '$'||SUM(g.purchases) as Total_Purchases FROM players_schema.players_data p, players_schema.games_data g WHERE p.game_details = g.id GROUP BY g.id, p.name

how do I query the created materialized view to find the total purchases by a player with id 12345. Now I have queried FROM players_schema.players_data p, players_schema.games_data g but I cannot do it FROM by player (mv_players_purchases_amount)... I get an error stating The redshift statement failed. Review it and try again!....

please if anyone out there can help, I would appreciate it.

Gonzalo Herreros 전문가
2년 전
This is really a Redshift question, don't see why you have the Athena and Glue tags. Test the materialized view query by itself.
Abubaker
2년 전
yes I have tried the materialized view but it states that Total_Purchases is not queried by the mv_players_purchases_amount... when I query with mv_players_purchases - it works but somehow with _amount it doesn't work. ugh
Abubaker
2년 전
how would the query go ? has anyone out there done this Cloud Data warehouse Lab on cloud quest under Data Analytics please help.

Update: it gives me and ERROR: column "total_purchases" does not exist in mv_players_purchases_amount
Jon Roberts 전문가
2년 전
You need to provide more details with a reproducible test case. It should include the DDL for the tables and materialized view and include the SQL query you are executing with the error message.

주제: 분석
태그: AWS Glue 아마존 Redshift 아마존 Athena
언어: English

Abubaker

질문됨 2년 전410회 조회

1개 답변

최신
최다 투표
가장 많은 댓글

이 답변이 도움이 되었나요?커뮤니티가 여러분의 지식을 활용할 수 있도록 정답을 찬성하세요.

I had a similar issue that was actually a typo, particularly with the word "purchases" vs "purchase". Double check your spelling of the table and the query to confirm.

AWS-User-9316779

답변함 2년 전

Need help on CloudQuest Cloud Data Warehouse LAB

답변 추가

관련 콘텐츠