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.

主题: 分析
标签: Amazon Redshift AWS Glue Amazon Athena
语言: English

Abubaker

已提问 2 年前414 查看次数

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

添加回答

相关内容