Week 4 - Lab Batch and streaming ingestion

Course Q&A Data Engineering Introduction to Data Engineering
1

I am getting “…/sql/embeddings.sql: No such file or directory” error msg when running the following cmd: postgres-> \i ‘…/sql/embeddings.sql’
I am connected and can see that the file exist. Please see the code below
postgres=> \c postgres;
Password:
psql (15.8, server 16.2)
WARNING: psql major version 15, server major version 16.
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’
…/sql/embeddings.sql: No such file or directory
postgres=> ls
postgres-> \i ‘…/sql/embeddings.sql’
…/sql/embeddings.sql: No such file or directory

Please advice
Thanks

2

It looks like 3 dots but I am making sure it is \i …‘/sql/embeddings.sql’

3

it is only two dots going back to the sql folder.

4

figured it out the path is ./sql/embeddings.sql (single dot not the double dot the doc says to use)

1 Like