31:[{"id":"aedff21f07a22dc246ead8daff8fb37c77747b2accffe2353335a93856ec7a5ded3a0677972f916572687c5929196c4a9d67ae6abe21d97bff05d7bc5a4695cf","href":"https://static.observableusercontent.com/files/aedff21f07a22dc246ead8daff8fb37c77747b2accffe2353335a93856ec7a5ded3a0677972f916572687c5929196c4a9d67ae6abe21d97bff05d7bc5a4695cf","name":"databasesPanelSubMenu.png","type":"image/png","lastModified":1673390151148.226,"size":73092},{"id":"36df20656b75a0d347e4ea1528f8bccf5d2921e2b0ab11c4ff7de5b94128f5e2a7ef4454ad551680b2c565e91de062312e47494d38a0f249f175ba35ee7bb2b5","href":"https://static.observableusercontent.com/files/36df20656b75a0d347e4ea1528f8bccf5d2921e2b0ab11c4ff7de5b94128f5e2a7ef4454ad551680b2c565e91de062312e47494d38a0f249f175ba35ee7bb2b5","name":"dataTableCell_data_source.png","type":"image/png","lastModified":1673390151148.226,"size":30915},{"id":"74b846d252df358b985a9a2e700c5b3150af4cabd8e7cfb37329a496ce98482eea39e6d865e4258abcfa72fe04aaf0261b16c5466b1d769fe57cb53a20344782","href":"https://static.observableusercontent.com/files/74b846d252df358b985a9a2e700c5b3150af4cabd8e7cfb37329a496ce98482eea39e6d865e4258abcfa72fe04aaf0261b16c5466b1d769fe57cb53a20344782","name":"SQL_cell_data_source.png","type":"image/png","lastModified":1673390151148.226,"size":28463},{"id":"559579d6f0c2dd73583a283d786d681dc0f0d04c5acf0f5f6959518e87fce3ae1f53235bb5c0deffa0428f75a272be2b288110266f387d712b51cbfe75f163cd","href":"https://static.observableusercontent.com/files/559579d6f0c2dd73583a283d786d681dc0f0d04c5acf0f5f6959518e87fce3ae1f53235bb5c0deffa0428f75a272be2b288110266f387d712b51cbfe75f163cd","name":"databases2.svg","type":"image/svg+xml","lastModified":1673390151148.226,"size":9388},{"id":"1f8e2abfd8a3ed5e90993f74078943456b20dd4ea5498aaf9595c5bb4108cd381f46dc5cbe44707211ab77b072c6ac77f66a1c53058e9106625320adf22a68ef","href":"https://static.observableusercontent.com/files/1f8e2abfd8a3ed5e90993f74078943456b20dd4ea5498aaf9595c5bb4108cd381f46dc5cbe44707211ab77b072c6ac77f66a1c53058e9106625320adf22a68ef","name":"schemaArtistsExpanded.png","type":"image/png","lastModified":1673390151148.226,"size":41861},{"id":"5b250913b0f237ae3b59e95b2c551d1fa6db0ae61e2b660cf615e77f4fff44e76d79fc6e57392821e87c0c33f9d849d1099c707a22d367a91f5d8b66fdd34dad","href":"https://static.observableusercontent.com/files/5b250913b0f237ae3b59e95b2c551d1fa6db0ae61e2b660cf615e77f4fff44e76d79fc6e57392821e87c0c33f9d849d1099c707a22d367a91f5d8b66fdd34dad","name":"databasesSidePanelFull.png","type":"image/png","lastModified":1673390151148.226,"size":54622},{"id":"fc475ea06cd52501d4acbd15406d09ed8c3077e3e96fdd5b7cd710f3118002ac77343a155f23d4c95b5fe0aee36babcb1d23bd816375f718b9eef92a5991d054","href":"https://static.observableusercontent.com/files/fc475ea06cd52501d4acbd15406d09ed8c3077e3e96fdd5b7cd710f3118002ac77343a155f23d4c95b5fe0aee36babcb1d23bd816375f718b9eef92a5991d054","name":"expandedSchema.png","type":"image/png","lastModified":1673390151148.226,"size":87151},{"id":"f82ae3d4bbf6f2cd0dbe9943b6f2920b62f11353c6d3374c9125d1fccfb9273f7485b8d5ebf3b6333593c4f4f2b1d9253ec5978792b9b5632a58a0420f377e1a","href":"https://static.observableusercontent.com/files/f82ae3d4bbf6f2cd0dbe9943b6f2920b62f11353c6d3374c9125d1fccfb9273f7485b8d5ebf3b6333593c4f4f2b1d9253ec5978792b9b5632a58a0420f377e1a","name":"databasesPanel.png","type":"image/png","lastModified":1673390151148.226,"size":42488},{"id":"b3711cfd9bdf50cbe4e74751164d28e907ce366cd4bf56a39a980a48fdc5f998c42a019716a8033e2b54defdd97e4a55ebe4f6464b4f0678ea0311532605a115","href":"https://static.observableusercontent.com/files/b3711cfd9bdf50cbe4e74751164d28e907ce366cd4bf56a39a980a48fdc5f998c42a019716a8033e2b54defdd97e4a55ebe4f6464b4f0678ea0311532605a115","name":"chinook.db","type":"application/x-sqlite3","lastModified":1673390151148.226,"size":884736}] 2f:{"title":"Databases panel and schema viewer","cells":[{"id":0,"value":"# Databases panel and schema viewer","pinned":false,"hidden":false,"mode":"md"},{"id":5,"value":"Observable now has a side panel dedicated to databases. Clicking the ${databasesIconImage()} icon (along the right side of the browser window) causes the **Databases** side panel to appear:","pinned":false,"hidden":false,"mode":"md"},{"id":60,"value":"

\n \n

Databases panel.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":16,"value":"Another way to display the Databases panel is to click the ${databasesIconImage()} icon in a [SQL cell](https://observablehq.com/@observablehq/sql-cell):","pinned":false,"hidden":false,"mode":"md"},{"id":21,"value":"

\n \n

Databases icon in a SQL Cell.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":27,"value":"The icon is also available in a [data table cell](https://observablehq.com/@observablehq/data-table-cell):","pinned":false,"hidden":false,"mode":"md"},{"id":24,"value":"

\n \n

Databases icon in a data table cell.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":64,"value":"## Example using a SQL cell","pinned":false,"hidden":false,"mode":"md"},{"id":33,"value":"Let's say you have attached a [SQLite](https://observablehq.com/@observablehq/sqlite) file to your notebook in order to make use of it as a database:","pinned":false,"hidden":false,"mode":"md"},{"id":30,"value":"sampleDB = FileAttachment(\"chinook.db\").sqlite()","pinned":false,"hidden":false,"mode":"ojs"},{"id":35,"value":"You might then create a SQL cell that uses that database:","pinned":false,"hidden":false,"mode":"md"},{"id":15,"value":"","pinned":true,"hidden":false,"mode":"sql","output":"","database":"var:sampleDB"},{"id":41,"value":"If you then click the ${databasesIconImage()} icon, the Databases panel appears at the right side of your browser:","pinned":false,"hidden":false,"mode":"md"},{"id":45,"value":"

\n \n

Databases panel shows the Database cells.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":50,"value":"And if you subsequently click the database name, the schema of the database appears in the Databases panel:","pinned":false,"hidden":false,"mode":"md"},{"id":52,"value":"

\n \n

Expanded schema for the selected database cell.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":89,"value":"You can expand the schema entries to reveal more detail as available:","pinned":false,"hidden":false,"mode":"md"},{"id":92,"value":"

\n \n

You can expand schema entries.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":67,"value":"## Example using a database connection","pinned":false,"hidden":false,"mode":"md"},{"id":69,"value":"Databases that you have connected using a database connection offer a few additional capabilities; available from the (...) menu:","pinned":false,"hidden":false,"mode":"md"},{"id":73,"value":"

\n \n

Menu for database connections.

\n","pinned":false,"hidden":false,"mode":"html"},{"id":138,"value":"**Refresh schema** refreshes and displays the schema for the current database.","pinned":false,"hidden":false,"mode":"md"},{"id":80,"value":"**Insert into notebook** creates a new cell that is pre-configured to connect to the selected database.","pinned":false,"hidden":false,"mode":"md"},{"id":142,"value":"**Copy usage code** copies the code for the current data source; this can then be pasted into a JavaScript cell. (Currently this option appears only for some data sources.)","pinned":false,"hidden":false,"mode":"md"},{"id":78,"value":"**Edit details** takes you to the databases page of your **Settings**.","pinned":false,"hidden":false,"mode":"md"},{"id":7,"value":"---","pinned":false,"hidden":false,"mode":"md"},{"id":133,"value":"## Appendix","pinned":false,"hidden":false,"mode":"md"},{"id":100,"value":"databasesIconImage = icon2(FileAttachment(\"databases2.svg\"))","pinned":false,"hidden":false,"mode":"ojs"},{"id":96,"value":"async function icon2(file, {width = \"16px\"} = {}) {\n const src = await file.url();\n return () => htl.html`

`;\n}","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W31","stdlib":"1","titling":"auto"}