following-up om my post from yesterday, I don’t know if someone reset my lab, but I decided to give it one more try and this time I finally got past the ETL job issue. However, after running the sql script, I got the following error messages at the end. Here is the full output from connecting to PSQL and running the script:
voclabs:~/environment/terraform $ psql --host=de-c1w4-vector-db.c144mao4s20l.us-east-1.rds.amazonaws.com --username=postgres --password --port=5432
Password:
psql (15.9, server 17.2)
WARNING: psql major version 15, server major version 17.
Some psql features might not work.
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, compression: off)
Type “help” for help.
postgres=> \c postgres;
Password:
psql (15.9, server 17.2)
WARNING: psql major version 15, server major version 17.
Some psql features might not work.
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, compression: off)
You are now connected to database “postgres” as user “postgres”.
postgres=> \i ‘…/sql/embeddings.sql’
psql:…/sql/embeddings.sql:1: NOTICE: installing required extension “aws_commons”
CREATE EXTENSION
CREATE EXTENSION
psql:…/sql/embeddings.sql:4: NOTICE: table “item_emb” does not exist, skipping
DROP TABLE
psql:…/sql/embeddings.sql:5: NOTICE: table “user_emb” does not exist, skipping
DROP TABLE
CREATE TABLE
CREATE TABLE
psql:…/sql/embeddings.sql:15: ERROR: HTTP 404. Requested file embeddings/item_embeddings.csv does not exist.
psql:…/sql/embeddings.sql:23: ERROR: HTTP 404. Requested file embeddings/user_embeddings.csv does not exist.
postgres=>
I interpreted the last two messages as some sort of failure to connect/access the embeddings bucket (I checked S3 and the bucket and the files were present). I decided to push on with the rest of the lab anyway and guess what, everything else seemed to work and I passed the grader with 100%. So my question is what is the meaning of the psql error messages? Was there actually an error in accessing the embeddings csv files? If yes, then why did the rest of the lab work and I passed the grader? If no, then what is the meaning of the error messages and how should they be interpreted? Thank you
Update: I just ran the lab again and was error free all the way through. I would still appreciate an explanation of the error messages I received earlier after running the sql script. Thank you.