I am new to data analysis and i am taking a course. So, i ran onto this problem. I try to read the chinook database and i get the error " OperationalError: no such table: employees"
I work on a Jupyter Notebook. This is the block of code i use:
import sqlite3
conn= sqlite3.connect('chinook.db')
cur= conn.cursor()
cur.execute('SELECT * FROM employees LIMIT 5;')
results = cur.fetchall() # -> this gives output []I downloaded the chinook database from https://www.sqlitetutorial.net/sqlite-sample-database/ (locally in my pc, it is ~850 kb)
I upload the chinook.db on jupyter. I also tried to insert the path straight from my pc. I also tried another opencart sql file and still got the same error.
When i double-click and open the db files in jupyter they are just alphabetical characters. I mention this, because the sql file i mentioned before, when i open it in my pc as a text file, it is legit sql tables.
I am sorry for the long post. I try to give as many info as possible.