I have a SQLite DB

Solved!
UserBird
Dataiker
I have a SQLite DB
How can I access it?
1 Solution
jrouquie
Dataiker Alumni

DSS comes with drivers for SQLite, but you still need to create the connection:




  • Browse to “Administration → Connections”.

  • Create a new connection of type “Other SQL databases”.

  • Fill the form this way:

        JDBC driver class: org.sqlite.JDBC

        JDBC URL: jdbc:sqlite:/path/to/your/database.sqlite3

  • Test the connection and save.



You can then create new datasets using this connection.



But, be aware that SQLite is not fully supported in DSS. It will be mainly okay for reading the tables. For writing, you can get some problems, especially if you are working with dates.



You can find more information in the User Guide about supported connection: http://doc.dataiku.com/dss/latest/connecting/connections.html

View solution in original post

1 Reply
jrouquie
Dataiker Alumni

DSS comes with drivers for SQLite, but you still need to create the connection:




  • Browse to “Administration → Connections”.

  • Create a new connection of type “Other SQL databases”.

  • Fill the form this way:

        JDBC driver class: org.sqlite.JDBC

        JDBC URL: jdbc:sqlite:/path/to/your/database.sqlite3

  • Test the connection and save.



You can then create new datasets using this connection.



But, be aware that SQLite is not fully supported in DSS. It will be mainly okay for reading the tables. For writing, you can get some problems, especially if you are working with dates.



You can find more information in the User Guide about supported connection: http://doc.dataiku.com/dss/latest/connecting/connections.html