2f:null 30:["$","title",null,{"children":"Enterprise & Pro Team Onboarding: Securely connecting to data | Observable | Observable"}] 35:T520,## Cloud files Observable also supports access to [cloud files](https://observablehq.com/@observablehq/cloud-files) hosted on Google or Microsoft. To connect, open up the files pane by clicking the icon, the click on "Cloud Files." You'll be directed to authenticate and grant access to Observable.36:T4b4,When working privately in an Enterprise or Pro team, Observable supports [secrets](https://observablehq.com/@observablehq/secrets). Secrets allow you to securely save access tokens that only you or authenticated teammates can use to interact with secure APIs. For examples see our [GitHub API starter template](https://observablehq.com/@observablehq/github-api-starter) and [AWS S3 starter template](https://observablehq.com/@observablehq/aws-s3-api-starter). Sometimes all you need is basic authentication, in which case you can reference the [fetch with basic authentication example](https://observablehq.com/@mbostock/fetch-with-basic-auth). | Resources | | :-- | --- | | [Observable Secrets](https://observablehq.com/@observablehq/secrets) | Documentation for securely storing API tokens and secrets | | [GitHub API starter template](https://observablehq.com/@observablehq/github-api-starter) | Quickly get started using the GitHub API | | [AWS S3 starter template](https://observablehq.com/@observablehq/aws-s3-api-starter) | Quickly get started using the AWS S3 API | | [Fetch with Basic Auth example](https://observablehq.com/@mbostock/fetch-with-basic-auth) | An example of using Basic Auth |37:[{"id":"8004255bff06ddebc5cf7d0a8bd3b04fc3e4dfd9ef115a1e2e27d8f02cb2f465b9824fdaa0cd0a50530583083b6871279bc1cdb6a1b190e3e5f65207a5cf9f49","href":"https://static.observableusercontent.com/files/8004255bff06ddebc5cf7d0a8bd3b04fc3e4dfd9ef115a1e2e27d8f02cb2f465b9824fdaa0cd0a50530583083b6871279bc1cdb6a1b190e3e5f65207a5cf9f49","name":"connect-to-data.png","type":"image/png","lastModified":1669840252177.877,"size":744489},{"id":"7564c3008a15ae5d94d9d56137643942d1804fe336f9c9121577805c96c317e9330595c9e4e24d1b71b87a41b373889e028ca0b7113d3f932c07b668790a04f2","href":"https://static.observableusercontent.com/files/7564c3008a15ae5d94d9d56137643942d1804fe336f9c9121577805c96c317e9330595c9e4e24d1b71b87a41b373889e028ca0b7113d3f932c07b668790a04f2","name":"SQL.mov","type":"video/quicktime","lastModified":1669843038030.685,"size":2127633},{"id":"df5f686a5d73b06dd26399c334b1bba1d74f76eee6d524aec03d516d4de8e080d42ab8f3b144b1bc3c86343cac6ce42c4ea696324c58c1ea2ebc4aace4bc8dc6","href":"https://static.observableusercontent.com/files/df5f686a5d73b06dd26399c334b1bba1d74f76eee6d524aec03d516d4de8e080d42ab8f3b144b1bc3c86343cac6ce42c4ea696324c58c1ea2ebc4aace4bc8dc6","name":"database.mov","type":"video/quicktime","lastModified":1669842214483.771,"size":3121772},{"id":"5ef61922bcb2950e7fbdf5217eb31db0d4dd701cd989a5fd3de491f24fef190bfd98d7e09b7d50e9c296c77fa81f7f22498bb291fe1eff1619edbda3a668a3ae","href":"https://static.observableusercontent.com/files/5ef61922bcb2950e7fbdf5217eb31db0d4dd701cd989a5fd3de491f24fef190bfd98d7e09b7d50e9c296c77fa81f7f22498bb291fe1eff1619edbda3a668a3ae","name":"sqlInput.mov","type":"video/quicktime","lastModified":1669843432537.343,"size":4113704},{"id":"ef6a1db36bb73db906acf1ddea92c62529b6313b154c469e52534d15cd34dbe302a42143ec8e4b0d587c555316129dcb052d0d0f9ef95a19cb816964e2c6cebb","href":"https://static.observableusercontent.com/files/ef6a1db36bb73db906acf1ddea92c62529b6313b154c469e52534d15cd34dbe302a42143ec8e4b0d587c555316129dcb052d0d0f9ef95a19cb816964e2c6cebb","name":"cloud.mov","type":"video/quicktime","lastModified":1669847189260.635,"size":440709},{"id":"e6480f1a586562b5647eaad4c0b6e3299377dd1bd38b9d5a0873de477a3daa282dbe6dd579231a261c7867d0f6b29e6741b2576ae31f44470a22702e953d3702","href":"https://static.observableusercontent.com/files/e6480f1a586562b5647eaad4c0b6e3299377dd1bd38b9d5a0873de477a3daa282dbe6dd579231a261c7867d0f6b29e6741b2576ae31f44470a22702e953d3702","name":"fileInput.mov","type":"video/quicktime","lastModified":1669849370365.208,"size":2653585},{"id":"c5b1412c07e5be362d3df38ce4b4aa22e6113ad9b1345f6f3d1493def9c867bfd058b370a3dee2fa9953a90f53356688e36ef875bfbb972f20d13927081aa917","href":"https://static.observableusercontent.com/files/c5b1412c07e5be362d3df38ce4b4aa22e6113ad9b1345f6f3d1493def9c867bfd058b370a3dee2fa9953a90f53356688e36ef875bfbb972f20d13927081aa917","name":"small-collaborate.png","type":"image/png","lastModified":1669850893014.883,"size":1201956},{"id":"801420317acc8c075f4d8179c639959eae31f4d0e7d0059d6f292ff3a5f15ad4cc4145af36a0377510b3a5cdf09afcb6c42fc0f14d82e4e387bca9e541cf3e46","href":"https://static.observableusercontent.com/files/801420317acc8c075f4d8179c639959eae31f4d0e7d0059d6f292ff3a5f15ad4cc4145af36a0377510b3a5cdf09afcb6c42fc0f14d82e4e387bca9e541cf3e46","name":"files@1.mov","type":"video/quicktime","lastModified":1669848453730.815,"size":870662}] 33:{"id":"7f213bf737afc8f3","slug":"enterprise-pro-team-onboarding-securely-connecting-to-data","title":"Enterprise & Pro Team Onboarding: Securely connecting to data","thumbnail":"d62a4fcf83d0edbb8240491fcd3d150c99719168108112f1302d5972b7b0d06d","access_level":"public","create_time":"$D2022-11-28T19:44:28.252Z","update_time":"$D2023-05-16T15:05:25.318Z","view_time":null,"first_public_time":"$D2022-12-12T19:35:33.956Z","has_unpublished_edits":null,"fork":false,"stars":1,"starred":false,"owner":{"type":"team","id":"f35c755083683fe5","login":"observablehq","name":"Observable","avatar_url":"https://avatars-next.observableusercontent.com/424c6c1f7794371c9915a160519bdfb34cf34e50069fcd6def38a1a04d4e9702","tier":"enterprise_2024"},"version":272,"publish_version":null,"role":null,"authored":false,"authors":[],"members":[{"type":"team","id":"f35c755083683fe5","login":"observablehq","name":"Observable","avatar_url":"https://avatars-next.observableusercontent.com/424c6c1f7794371c9915a160519bdfb34cf34e50069fcd6def38a1a04d4e9702","tier":"enterprise_2024","role":"editor"}],"comments":[{"id":"0633e4430c453985","reply_to_id":null,"content":"Switch 1 & 2? Connecting to data seems weird to teach / learn w/o some notebook basics & inspiration","create_time":"$D2022-11-30T00:32:44.741Z","update_time":null,"resolved":true,"user":{"type":"individual","id":"b71e24965feea6d8","login":"allisonhorst","name":"Allison Horst","avatar_url":"https://avatars-next.observableusercontent.com/323c217177f0f20e4e8ed3aa302fec1408cf22b57cbd726e37e76182d5f82a65","tier":null}},{"id":"2195f63c8be22e5a","reply_to_id":"0633e4430c453985","content":"Yup, I agree","create_time":"$D2022-11-30T01:19:00.724Z","update_time":null,"resolved":true,"user":{"type":"individual","id":"42520cea6c99d3c8","login":"pstuffa","name":"Paul Buffa","avatar_url":"https://avatars-next.observableusercontent.com/32c09bb97a2bb742225b949dcc4cf81a03dcd2b0caae97325970223a48a14b94","tier":null}}],"custom_thumbnail":true,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":{"id":"7d602801a42f7e34","slug":"enterprise-training-curriculum","title":"Enterprise & Pro Team Onboarding","owner":{"id":"f35c755083683fe5","login":"observablehq","name":"Observable"}},"type":"notebook","body":{"title":"Enterprise & Pro Team Onboarding: Securely connecting to data","cells":[{"id":0,"value":"# Enterprise & Pro Team Onboarding: Securely connecting to data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":73,"value":"

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":80,"value":"Data comes in all shapes and sizes, and Observable supports working with all of it. Whether it's SQL databases, spreadsheets, live APIs, or files of any kind, you can quickly bring your data into Observable for faster exploration, analysis and insights.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":82,"value":"When working in Enterprise and Pro Teams, you have access to even more ways of connecting your data into Observable.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":13,"value":"## Databases\n\nFor Enterprise and Pro teams, Observable offers a straightforward way to [connect to databases](https://observablehq.com/@observablehq/databases). To start, go to your team settings, [click on \"Databases\"](/settings/databases) then \"New Database,\" where you can enter your database credentials.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":89,"value":"

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":87,"value":"If you want to use your notebooks to query a database on your local computer or on a private network, we also provide a [self-hosted database proxy](https://observablehq.com/@observablehq/self-hosted-database-proxies).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":92,"value":"Once you've connected your database, you and members of your team will have access to the database in all team notebooks, and can query directly within a notebook using the [SQL cell](https://observablehq.com/@observablehq/sql-cell).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":97,"value":"

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":102,"value":"Just like in JavaScript, Markdown, and HTML cells, you can embed variables into SQL cells. Using Observable Inputs, you can create simple data apps that allow non-technical users to run custom queries. ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":104,"value":"

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":52,"value":"$35","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":111,"value":"

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":116,"value":"Once you've authenticated, you'll see all your cloud files available to import directly into a notebook, just like you would with file attachments. To learn more, read our walk through on [cloud files](https://observablehq.com/@observablehq/cloud-files).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":16,"value":"## APIs & Secrets","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":121,"value":"Observable supports fetching [API](https://observablehq.com/@observablehq/working-with-apis-remote-files?collection=@observablehq/working-with-data) results directly in notebooks, making it simple to work with live data. Here is an example of a JavaScript fetching the results from a live API on New York City subway ridership.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":126,"value":"d3.csv('https://data.ny.gov/api/views/vxuj-8kew/rows.csv?accessType=DOWNLOAD&sorting=true')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":123,"value":"$36","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":31,"value":"## Local files\n\nOne of the most powerful ways to work with files in Observable is to attach them to your notebook. ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":146,"value":"

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":140,"value":"For more details on using file attachments see the [file attachments](https://observablehq.com/@observablehq/file-attachments) documentation.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":69,"value":"## File Inputs\n\nIf you would like to load data with a file, but not save it as an attachment to your notebook, the [file input](https://observablehq.com/@observablehq/input-file) is a good alternative. Using file input, the file is not uploaded and data is only available temporarily in memory.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":153,"value":"

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":250,"value":"### Security quick reference\nWhen you connect your data to Observable, what information is stored on our servers? This quick reference outlines the data flows of each data connection method. \n\n|Method | Security implications |\n|--- |---\n|File Attachment | Stored on our S3 bucket. data flows from our S3 bucket to the user's browser |\n|APIs using secrets | Secret is stored encrypted on our S3 bucket |\n|Cloud Files | Data flows from cloud file provider to the user's browser. User has to sign in to grant access to the cloud file storage|\n| Database connections using Observable's proxy | Data flows from user's database through a proxy hosted on Observable's server to the user's browser|\n|Database connection using self-hosted proxy | If the database is on a local network, this method ensures that data never leaves the network. It travels from the local database through the locally installed database proxy to the user's browser|\n|Inputs:file| File only exists in browser memory |\n\n
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":172,"value":"Now that you're up and running with the basics of working in Observable notebooks and connecting to data, continue to the next section to learn about [collaborating with teammates and sharing your work](https://observablehq.com/d/ae94d8d2ac25da0f?collection=@observablehq/enterprise-training-curriculum).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":168,"value":"smallCollaborate = FileAttachment(\"small-collaborate.png\").image({width: 200})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W37","stdlib":"1","titling":"auto"}} 34:"$33:body"