Dibs
New Contributor III

‎08-29-2024 06:57 PM

I had to change to 

 

%python
dbutils.fs.cp("dbfs:/mnt/dbacademy-users/YOURUSERID/data-engineering-with-databricks/ecommerce.db", "file:/tmp/ecommerce.db")
 
DROP TABLE IF EXISTS users_jdbc;

CREATE TABLE users_jdbc
USING JDBC
OPTIONS (
url = "jdbc:sqlite:/tmp/ecommerce.db",
dbtable = "users"
)