Can't get my Jupyter to work with Guided SQL (CIA Factbook)

[ale_aleivaar]

I am just starting the guided project to analyze CIA Factbook in the SQL Fundamentals course.

When I ran this code:

%load_ext sql
%sql sqlite:///factbook.db```

I copied it in and ran it and nothing happens. 

I am supposed to get:

'Connected: [email protected]'

I did notice that the factbook database file was created in the same folder as the Jupyter notebook.

When I run a Query:

```%%sql
SELECT *
  FROM facts
LIMIT 5;```

I get the following:

 * sqlite:///factbook.db
(sqlite3.OperationalError) no such table: facts
[SQL: SELECT *
  FROM facts
LIMIT 5;]
(Background on this error at: http://sqlalche.me/e/e3q8)

Help.

[Rucha]

Hi @ale_aleivaar

following posts are similar:

• Intro to SQL - CIA Factbook GP - Empty Database - Factbook.db

• this is for R but error is same - Guided Project: Analyzing CIA Factbook Data Using SQLite and R

As you have said a database file got created in the same folder, it might be an empty file and the downloaded database file is in a different folder.

Try to point that file to connect with, and let us know if this doesn’t work.