You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hey all! So I'm receiving the errors above. I'm assuming that it's related to my new data source. I'm loosely following the instructions in the getting started-connect to data, except I'm connecting to a local postgresql DB.
My configurations are as follows:
host = "localhost"
port = "5432"
username = "iq"
password = "SOME_PASSWORD"
database = "fsdl"
schema_name = "fashion_mnist"
# A table that you would like to add initially as a Data Asset
table_name = "fashion_mnist"
The name of the database is fsdl, and the name of the table is fashion_mnist. I'm not running into any issues in the rest of the notebook when I run all the cells. However, when I follow the tutorial all the way to the last page: validate data, I'm running into the following error:
ProgrammingError: (psycopg2.errors.UndefinedTable) relation "fashion_mnist.fashion_mnist" does not exist
LINE 2: FROM fashion_mnist.fashion_mnist
^
[SQL: CREATE TEMPORARY TABLE "ge_temp_e3111833" AS SELECT *
FROM fashion_mnist.fashion_mnist
WHERE true]
(Background on this error at: https://sqlalche.me/e/14/f405)
I ASSUME that it's related to my DB, but I'm not sure. I'm assuming I'm putting the wrong name for the schema, but I'm not sure what the name SHOULD be. I googled around and didn't really find anything that helped me (but maybe I was skimming just a tad bit too much). I've tried changing the schema value to be the same as my table such that the error would read LINE 2: FROM fsdl.fashion_mnist, but no dice.
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
Hey all! So I'm receiving the errors above. I'm assuming that it's related to my new data source. I'm loosely following the instructions in the getting started-connect to data, except I'm connecting to a local postgresql DB.
My configurations are as follows:
The name of the database is
fsdl
, and the name of the table isfashion_mnist
. I'm not running into any issues in the rest of the notebook when I run all the cells. However, when I follow the tutorial all the way to the last page: validate data, I'm running into the following error:I ASSUME that it's related to my DB, but I'm not sure. I'm assuming I'm putting the wrong name for the schema, but I'm not sure what the name SHOULD be. I googled around and didn't really find anything that helped me (but maybe I was skimming just a tad bit too much). I've tried changing the
schema
value to be the same as my table such that the error would readLINE 2: FROM fsdl.fashion_mnist
, but no dice.Any help would be greatly appreciated!
Beta Was this translation helpful? Give feedback.
All reactions