C1W4 lab:Error messages after running sql script, but the rest of the lab worked and I passed

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.

Hello @aezazi
Seems like you had run \i '.../sql/embeddings.sql' instead of \i '../sql/embeddings.sql'. When working with files in an OS, ../ means the parent directory, but .../ has no specific meaning. So, you just had an extra dot in your command, and it seems like that was the problem.

Stupid mistake on my part.
Thanks Amir.