C4_W1_Lab_1_Data_Normalization

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

When executing below I’m getting “KeyError: DEFAULT”

%%sql
select count(*) from classicmodels_obt.orders;

Please help

Thanks

Regards
Ranjit. S

2

Error_C4_W1_Lab_1
Error_C4_W1_Lab_1988×812 158 KB

3

Hello @ranjitsrinivasan,
I could reproduce the issue and getting the DEFAULT error. It seems its connected to the prettytable library. You can bypass this if you add a second cell after the libraries impoert. Code to ADD:

from prettytable import PrettyTable , PLAIN_COLUMNS
table = PrettyTable()
table.set_style(PLAIN_COLUMNS)

%config SqlMagic.style = ‘PLAIN_COLUMNS’

C4W1_lab_add_cell
C4W1_lab_add_cell1409×489 79.7 KB

3 Likes
4

Georgios

above solution works

Thanks

5

thank you Georgios.

your solution works :slight_smile:

6

another solution is to add cell with:
%config SqlMagic.style = '_DEPRECATED_DEFAULT'

right after cell with:
%load_ext sql

7

@Konstantin Yes I noticed it happens in other labs of this course and as well, I reported the issue and should be fixed soon. Your solution should work too, thanks:

1 Like