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 EXPERTE
vor einem Jahr
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
vor einem Jahr
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
vor einem Jahr
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 EXPERTE
vor einem Jahr
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.

Themen

Analysen

Relevanter Inhalt

Warum erhalte ich die Fehlermeldung „You can only join an organization whose Seller of Record is same as your account", wenn ich versuche, einer Organisation beizutreten?
AWS OFFICIALAktualisiert vor 2 Jahren
Wie beeinflusse ich den Netzwerkverkehr meiner Direct-Connect-Verbindung zu On-Premises über mehrere Leitungen?
AWS OFFICIALAktualisiert vor 2 Jahren
Wie erstelle ich einen SQL Server Always On-Verfügbarkeitsgruppen-Cluster in der AWS Cloud?
AWS OFFICIALAktualisiert vor 4 Monaten
Wie kann ich den Fehler „View is stale; it must be re-created“ in Athena beheben?
AWS OFFICIALAktualisiert vor einem Jahr