C4W4 - Capstone Project Part 2 - Redshift DB wan't created

Course Q&A Data Engineering Data Modeling, Transformation, and Serving
1

During the Capstone Project Part 2 the deftunes_transform and deftunes_serving schemas in REDSHIFT DB wasn’t created (step 2.7.).
All ingestion and transformation jobs were finished successfully.

Account id is: 211125491008

2

Hello @Morosus
I tried the lab, and unfortunately I was not able to reproduce the issue.

  1. Please, check that you have inputted the correct date in the terraform/modules/transform_job/glue.tf in step 2.2.
  2. Please, check that you have inputted the correct <REDSHIFT_ENDPOINT> in step 2.6. The endpoint should not contain a http:// and should look like the following.
    image
    image1356×217 8.49 KB
  3. If the issue persists, please, attach a screenshot of the output of the cells in step 2.6 and 2.7.
3

Hello, I get the same issue where the tables have not been created without any previous errors leading up to this point.

FYI, I traced back trouble-shooting after getting terraform errors during step 3.1.2. (see vs code terminal screenshot)

Please help! Thank you.

cells_2.6_2.7_20250106
cells_2.6_2.7_202501061887×955 154 KB

vs_source_code_terraform_errors_20250106
vs_source_code_terraform_errors_202501061909×1019 118 KB

4

Hello @Andrew_Wilkie
Seems like there has been a problem connecting to the AWS Glue endpoint. Actually this is new, and we haven’t faced an error like this before. I guess it might be stemming from a temporary error in the AWS services. Can you please try again in a fresh lab start and see if the issue persists?