Whether your data is hosted on the web, stored in a database, or saved in a local file, you can access it from Observable with these techniques.

Mike Bostock

Observable

Introduction to data

File attachments

Visnu Pitiyanuvath

Connecting to databases

Self-hosted database proxies

Annie Zhang

SQL cell

Wiltse Carpenter

Cloud files

Introduction to secrets

Cobus Theunissen

AWS S3 private file access

Justin Ting

Data table cell

Databases panel and schema viewer

Sample datasets

Ian Johnson

Curated datasets

SQLite

Custom database clients for use with Observable SQL cells.

Database Clients

Learn how Observable works, from first edit to publish.

Documentation

Getting Data In and Out

My cloud file is larger than 50 Mb so I cannot attach it to the notebook after downloading it. Is there any other way to publish a notebook with cloud file information?

In that case, we don't have a straightforward way to access it. You could place it at a public URL somewhere (maybe Dropbox, S3) and you can `fetch` it from your notebook.

Notice that Google Sheet supports creating public TSV files from sheet documents that are very easy to use with observableHQ. A good alternative that does not involve granting observablehq generic access to cloud files at google.

Andreas Åkre Solberg

Screen Shot 2021-09-28 at 3.05.32 PM.png

Screen Shot 2021-09-28 at 3.11.36 PM.png

cloud_files.mp4

Google cloud files.mp4

Google drive scopes.png