data-engineer-learning-path icon indicating copy to clipboard operation
data-engineer-learning-path copied to clipboard

Error during Execution- DE 2.2

Open MohamedSubair opened this issue 3 years ago • 1 comments

DROP TABLE IF EXISTS users_jdbc;

CREATE TABLE users_jdbc USING JDBC OPTIONS ( url = "jdbc:sqlite:${DA.paths.ecommerce_db}", dbtable = "users" )

while executing above I'm getting following : Error in SQL statement: SQLException: path to '/dbfs/mnt/dbacademy-users/[email protected]/data-engineer-learning-path/ecommerce.db': '/dbfs/mnt' does not exist

MohamedSubair avatar Dec 01 '22 10:12 MohamedSubair