aws-samples / redshift-immersionday-labs

This GitHub project provides a series of lab exercises which help users get started using the Redshift platform.

Redshift Immersion Day Labs

This content has been moved. Pleaes visit https://redshift-immersion.workshop.aws/

redshift-immersionday-labs's Issues

lab5 does only work in us-west-2

in other region, spectrum queries fail with
The S3 bucket addressed by the query is in a different region from this cluster

(the copy commands work)

Maybe just to add a note on the Lab start (lab1, so we can get resources started in the right region)

Lab4 mentions about us-west-2 for the first time

Hi,

It may be better to update the README.md file or Lab-1 instructions to indicate that the Redshift Cluster has to be launched in the us-west-2 region.

Lab-4 states an assumption that the Redshift cluster has been created in us-west-2, whereas the cluster was created in Lab-1 (which does not mention the same).

Please update!!

Thanks,
Vaidy

Syntax error in Lab5-Predicate Pushdown

Query Execution Error in Lab5-Predicate Pushdown:
Amazon Invalid operation: syntax error at or near ")" Position: 517;

Correct SQL Script:

SELECT c.c_name, c.c_mktsegment, t.prettyMonthYear, uv.totalRevenue
FROM (
SELECT customer, visitYearMonth, SUM(adRevenue) as totalRevenue
FROM clickstream.uservisits_parquet1
WHERE customer <= 3 and visitYearMonth >= 199810
GROUP BY customer, visitYearMonth) as uv
RIGHT OUTER JOIN customer as c ON c.c_custkey = uv.customer
INNER JOIN (
SELECT DISTINCT d_yearmonthnum, (d_month||','||d_year) as prettyMonthYear
FROM dwdate WHERE d_yearmonthnum >= 199810) as t ON uv.visitYearMonth = t.d_yearmonthnum
ORDER BY c.c_name, c.c_mktsegment, uv.visitYearMonth ASC;