25:["$","title",null,{"children":"Learning Observable: Getting data into Observable | thinkerlee | Observable"}] 49:T57d,## File attachments You can attach files to notebooks by clicking on the paper clip in the toolbar on the right , which opens the files pane. Then, either click on the plus sign or drag and drop files straight onto the pane to upload files for use. Attached files can be easily accessed by using the _insert into notebook_ function to insert a new cell with a code snippet like the one below.4a:T674,## Cloud files ProLearn more about Pro For Pro and Enterprise workspaces, Observable 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.4b:[{"id":"a5d2a1c33ca85f55d87650718b7f6f9935ba8d4283a0b49da3562191282eff931ee1bed3292fc44039b390678d6f13afdb2767ca0b49d1665e3de621306fdf52","href":"https://static.observableusercontent.com/files/a5d2a1c33ca85f55d87650718b7f6f9935ba8d4283a0b49da3562191282eff931ee1bed3292fc44039b390678d6f13afdb2767ca0b49d1665e3de621306fdf52","name":"new-users-course-access-data.png","type":"image/png","lastModified":1675994966382.227,"size":691603},{"id":"17e6d989bd5c1007aac5c6418d4ccaf1d21baa74b02fadfb5c69af50b9581c3dd8a441a49abc718bf81b3570cee4305fcc621e63bcf109a9e31ea3c09f1e86ce","href":"https://static.observableusercontent.com/files/17e6d989bd5c1007aac5c6418d4ccaf1d21baa74b02fadfb5c69af50b9581c3dd8a441a49abc718bf81b3570cee4305fcc621e63bcf109a9e31ea3c09f1e86ce","name":"array-object.png","type":"image/png","lastModified":1675994966382.227,"size":126890},{"id":"44842c52dee809a24944ff2fdb94a3c2525f188ea09be5b6aa08a6aac6f6840bd813fe9ab730a9ee1754f510d3be8c493ef3f31db5d22939f0263caa045c1aea","href":"https://static.observableusercontent.com/files/44842c52dee809a24944ff2fdb94a3c2525f188ea09be5b6aa08a6aac6f6840bd813fe9ab730a9ee1754f510d3be8c493ef3f31db5d22939f0263caa045c1aea","name":"copy-import-data.mov","type":"video/quicktime","lastModified":1675994966382.227,"size":5351066},{"id":"036293060a3d1be9b3ad33fca12dbd546157c3a20cbc2dcee6400a04c4e26b407d247697c0b5a6b23c9c03d263698913e9f5055b1c3fa2cfe6fc1826ec8c7ad0","href":"https://static.observableusercontent.com/files/036293060a3d1be9b3ad33fca12dbd546157c3a20cbc2dcee6400a04c4e26b407d247697c0b5a6b23c9c03d263698913e9f5055b1c3fa2cfe6fc1826ec8c7ad0","name":"Laser_Report_2020.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1675994966382.227,"size":462969},{"id":"ef6a1db36bb73db906acf1ddea92c62529b6313b154c469e52534d15cd34dbe302a42143ec8e4b0d587c555316129dcb052d0d0f9ef95a19cb816964e2c6cebb","href":"https://static.observableusercontent.com/files/ef6a1db36bb73db906acf1ddea92c62529b6313b154c469e52534d15cd34dbe302a42143ec8e4b0d587c555316129dcb052d0d0f9ef95a19cb816964e2c6cebb","name":"cloud.mov","type":"video/quicktime","lastModified":1675994966382.227,"size":440709},{"id":"b3711cfd9bdf50cbe4e74751164d28e907ce366cd4bf56a39a980a48fdc5f998c42a019716a8033e2b54defdd97e4a55ebe4f6464b4f0678ea0311532605a115","href":"https://static.observableusercontent.com/files/b3711cfd9bdf50cbe4e74751164d28e907ce366cd4bf56a39a980a48fdc5f998c42a019716a8033e2b54defdd97e4a55ebe4f6464b4f0678ea0311532605a115","name":"chinook.db","type":"application/x-sqlite3","lastModified":1675994966382.227,"size":884736},{"id":"356a149fdb489597280d5aeeefedc0c35702d0bb02398b3cb74d767d73b164bcffcf0162ec502b80f63882a27154c852a47a204c6403ec97b3ee9c570c018a08","href":"https://static.observableusercontent.com/files/356a149fdb489597280d5aeeefedc0c35702d0bb02398b3cb74d767d73b164bcffcf0162ec502b80f63882a27154c852a47a204c6403ec97b3ee9c570c018a08","name":"new-users-course-sm-get-data@1.png","type":"image/png","lastModified":1675994966382.227,"size":221131}] 29:{"id":"7d6024198b075499","slug":null,"title":"Learning Observable: Getting data into Observable","thumbnail":"bb4462ea72147b6d42c0970f3daa584369a8770ddcbb28e1c9d6ed2bd8ab5289","access_level":"public","create_time":"$D2023-02-10T02:09:26.382Z","update_time":"$D2023-02-10T03:05:31.073Z","view_time":null,"first_public_time":"$D2023-02-10T02:09:26.382Z","has_unpublished_edits":null,"fork":{"id":"efe521f15727533a","slug":"learning-observable-getting-data-into-observable","title":"Learning Observable: Getting data into Observable","owner":{"id":"f35c755083683fe5","login":"observablehq","name":"Observable"}},"stars":0,"starred":false,"owner":{"type":"team","id":"9ec98d2371a90bbb","login":"thinkerlee1989","name":"thinkerlee","avatar_url":"https://avatars-next.observableusercontent.com/c1c109bbb3c6d7c508d2f8b85ac0dbc135e2fe5d7626ec04176bb99d61855941","tier":"starter_2024","bio":"","followed_by_you":false,"follows_you":false},"version":443,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"f1eaa23933abc255","login":"thinkerlee1989","name":"thinkerlee","avatar_url":"https://avatars-next.observableusercontent.com/c1c109bbb3c6d7c508d2f8b85ac0dbc135e2fe5d7626ec04176bb99d61855941","tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"f1eaa23933abc255","login":"thinkerlee1989","name":"thinkerlee","avatar_url":"https://avatars-next.observableusercontent.com/c1c109bbb3c6d7c508d2f8b85ac0dbc135e2fe5d7626ec04176bb99d61855941","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Learning Observable: Getting data into Observable","cells":[{"id":0,"value":"# Learning Observable: Getting data into Observable","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":57,"value":"

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":366,"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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":34,"value":"## Database access \nProLearn more about Pro\n\nConnecting to secure databases is available for [Enterprise and Pro Teams](https://observablehq.com/pricing) on Observable. But anyone can work with databases in Observable, for example by uploading one, or creating a new one right in Observable from existing files (CSV, parquet, arrow, XLSX, txt, and more!) using an in-browser database client like [DuckDB](https://observablehq.com/@observablehq/duckdb).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":67,"value":"Once your database is connected, you can query, clean and analyze the data in Observable's SQL cell. Create a SQL cell by choosing 'Database query' from the Add Cell menu. Select the connected database you want to start working with, then write your SQL code. Your query's output will show as an interactive table like the one shown below. ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":68,"value":"SELECT * FROM customers \n JOIN invoices ON customers.CustomerId = invoices.CustomerId\n WHERE Country = \"Brazil\" ","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"chinook.db"},{"id":36,"value":"## APIs\n\nObservable supports fetching API results directly in notebooks, making it simple to work with live data. Here is an example of retrieving the results from a live API on New York City subway ridership.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":384,"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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":386,"value":"Observable supports API secrets for Enterprise, Pro Teams, and Pro Individual workspaces. Free Teams or Free Individuals can still fetch API results, using basic authentication.\n\n| Resources | |\n| :-- | --- | \n| [Fetch with Basic Auth example](https://observablehq.com/@mbostock/fetch-with-basic-auth) | An example of using Basic Auth |\n| [Observable Secrets](https://observablehq.com/@observablehq/secrets) | Documentation for securely storing API tokens and secrets |\n| [GitHub API starter template](https://observablehq.com/@observablehq/github-api-starter) | Quickly get started using the GitHub API |\n| [AWS S3 starter template](https://observablehq.com/@observablehq/aws-s3-api-starter) | Quickly get started using the AWS S3 API |","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":62,"value":"### Data Table cell\n\nObservable's Data Table cell provides an easy way to put your data in table form and perform some no-code data wrangling and exploration. From the Add Cell menu, search for or scroll to \"Data table.\" Then, choose the data source you want to explore (if it's a connected database, you'll also choose a table within that database). ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":63,"value":"An interactive view of the table will appear, with summary information atop each variable and options for filtering, selecting columns, sorting, and slicing rows below. Play with the interactive table below, which shows the \"customers\" table from the attached \"chinook.db\" database.\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":64,"value":"await FileAttachment(\"chinook.db\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":65,"value":"While the existing features in a Data Table cell cover some common data wrangling needs, you'll eventually need to do more customized querying and analysis (e.g. joins, grouping, renaming, cleaning, and more). \n\nYou can switch over to SQL code using the 'Convert to SQL mode' button, which will convert your current query to SQL and keep adding or editing custom SQL code.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":407,"value":"Next up, learn about how to visualize data with [Observable Plot](https://observablehq.com/@observablehq/learning-observable-observable-plot?collection=@observablehq/intro-to-observable). ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":273,"value":"newUsersCourseSmGetData1 = FileAttachment(\"new-users-course-sm-get-data@1.png\").image({width: 200})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W4b","stdlib":"1"}} 24:null