SQLite
Users can create a SQLite database with the option to initiate the DB from a web-hosted seed backup file.
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
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 thesign 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.
- 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.
- 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.
Last modified 7mo ago