By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

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 EXPERT
    10 months ago

    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
    10 months ago

    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
    10 months ago

    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 EXPERT
    10 months ago

    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.

Topics
Analytics
Tags
Amazon AthenaAWS GlueAmazon Redshift
Language
English
Abubaker
asked a year ago259 views
1 Answer
0

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
AWS-User-9316779
answered 8 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content