Datalore allows you to use different kinds of data sources in your notebooks.
Datalore users can connect to databases from the Home page and use the Attached data tool to retrieve their data for further use in the notebook. Read more about these procedures in Database integration.
Supported database types (Expand to view)
Amazon Aurora MySQL
Apache Derby (Embedded)
Apache Derby (Remote)
Apache Phoenix Thin
Azure SQL Database
Google Cloud Spanner
IBM Db2 (JTOpen)
IBM Db2 for 9.X, 10.X
Oracle for 9.X, 10.X, 11.1
You can use files from your file system or an external URL source. You have options:
Notebook files: can only be used in the notebook they are attached to.
Workspace files: can be used in any notebook from the workspace they are attached to.
Quick file upload
This is the quickest way to add a file to your notebook and start using it in the code:
Drag a file from your file system and drop it anywhere in the editor.
To refer to the file in your code, use the file name.
For example, the code below uses a file called 'libraries_by_python_version.csv'.libraries = pd.read_csv('libraries_by_python_version.csv') libraries
Use previously uploaded data
To access the data of already uploaded notebook attachments or workspace files, do the following:
Go to Attached data icon on the left-hand sidebar. You can see two categories of attached files there:or click the
Click the category you want to use to expand the list and see the attached files.
(Optional) If you are working from the default Home workspace, you must explicitly provide access to its files. Click Select data to attach and select Home workspace files.
Right-click the file you want to use in the code and select Copy path to clipboard.
Paste the copied path into your code.
Find more information in Attached files.
Cloud storage data sources
Datalore provides interface for mounting S3 or Google Cloud Storage buckets directly inside your notebooks. Here are the main benefits of using such data sources:
You extend your storage as you do not have to upload to notebooks those files that you store in buckets.
You can grant read or write access to the files stored in buckets.
Find more details about this option in Use cloud storage data sources.