SQLite

Users can create a SQLite database with the option to initiate the DB from a web-hosted seed backup file.
Prepare
You will need the following information to create the connection:
(Optional) Web-hosted seed backup file
(Optional) Timeout setting for pulling down the web-hosted seed backup file
Create connections
To create a data connection:
1.Pick connection type.
2.Store credentials.
3.Start or restart the kernel.
There are multiple places you can create data connections:
Notebook
Resource Page
To add a data connection from the notebook: 
1.Open the Data Connections panel by clicking on the database icon (
) in the left sidebar. 
2.Click on the 
 sign to launch the Create a data connection modal.
3.Select SQLite for the connection type.
4.Provide a Name for the data connection and a description, if desired.
5.Provide the URL to the web-hosted seed backup file (if used)
6.Set the timeout in seconds for downloading the web-hosted seed backup file (if used)
7.Choose the connection's Visibility - this cannot be changed later: 
Private connections can only be seen, managed, or accessed by the user who created the connections, and can be used in any space.
Space-level connections can be seen and managed by all users who have Contributor or Owner access for the space but can only be used in notebooks within the designated space.
8.Click Create.
9.Restart the kernel, if prompted.
To add a data connection from the resources page: 
1.Click on the Data Connections link in the main sidebar. This sidebar is visible from all space or project pages. 
2.Click on the +Create a data connection button to launch the Add data connection modal.
3.Select SQLite for the connection type.
4.Provide a Name for the data connection and a description, if desired.
5.Provide the URL to the web-hosted seed backup file (if used)
6.Set the timeout in seconds for downloading the web-hosted seed backup file (if used)
7.Choose the connection's Visibility - this cannot be changed later: 
Private connections can only be seen, managed, or accessed by the user who created the connections, and can be used in any space.
Space-level connections can be seen and managed by all users who have Contributor or Owner access for the space but can only be used in notebooks within the designated space.
8.Click Create.
9.Restart any running kernels to use this connection.
Use connections
Learn more about how to use SQL cells here. 
​
Last modified 7mo ago