C4_W4 Practice Lab issue with SQL connection

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

Every time I run an SQL query in the notebook, there is a message that counts the number of rows effected. However, the data is not displayed. I get an error in each cell:

KeyError: ‘DEFAULT’

The postgresql endpoint was properly configured and the connection was verified.

I looked at all the input variables for the database connection and there is nothing with a key label ‘DEFAULT’

I’m not even sure how to debug this issue

Any insight on how to repair this issue would be appreciated, I tried going through this three times.

2

Hello @dan_herman,
You can check this post for a solution. Basically others had similar issue with other labs in this course and add this cell. Hope it helps

3

That worked, thank you.

1 Like