Hi do you know how I can bring the project over to my own jupyter notebook?

I’m working on the SQL guided project, and I’m having trouble bring over the notebook to my own jupyter notebook.

Whenever I run these commands they don’t work

%%capture
%load_ext sql
%sql sqlite:///chinook.db

Is there any fix? I’d like to upload this project to GitHub

2 Likes

Hey @hqiantan06

Can you tell me the error which you are encountering while running the above code in your local Jupyter notebook?

If you don’t see any error then, try to look into the tables inside the database by running this code -

%%sql
SELECT *
FROM sqlite_master
WHERE type=‘table’;

You should see the below output which indicates that you db is successfully loaded in the notebook then followed by tables available in the database

  • sqlite:///factbook.db Done.

Let me know if this helps.

Best
K!

1 Like