Results of 1 - 6 of about 6 for notebooks (0.001 sec.)
- marimo Notebooks 13033
- marimo is an open-source reactive notebook for Python and SQL that's tightly integrated with DuckDB's Python client, letting you mix and match Python and SQL in a single git-versionable notebook. Unlike traditional notebooks, when you run a
...DB makes it well-suited to interactively working with data, and its representation as a Python file makes it simple to run notebooks as scripts. Installation To get started, install marimo from your terminal. Its sql extra also installs DuckDB, Polars and...pecial syntax or magic commands. df = mo.sql(f"SELECT 'Off and flying!' AS a_duckdb_column") This is because marimo stores notebooks as pure Python, for many reasons , such as git-friendly diffs and running notebooks as Python scripts. The SQL statement i...dependent cells when queries change Interactive UI elements that can be used to parameterize SQL queries Ability to export notebooks as standalone applications or Python scripts, or even run entirely in the browser with WebAssembly . Next Steps Read the m... - https://man.mtool.work/duckdb/2.0/guides/python/marimo.html
- Guides 9212
- The guides section contains compact how-to guides that are focused on achieving a single goal. For API references and examples, see the rest of the documentation. Note that there are many tools using DuckDB, which are not covered in the off
...and more!) Python Client How to install the Python client How to execute SQL queries How to easily query DuckDB in Jupyter Notebooks How to easily query DuckDB in marimo Notebooks How to use Multiple Python Threads with DuckDB How to use fsspec filesystem... - https://man.mtool.work/duckdb/2.0/guides/overview.html
- Jupyter Notebooks 8573
- DuckDB's Python client can be used directly in Jupyter notebooks with no additional configuration, as the first section shows. Additional libraries can simplify SQL query development; the rest of this guide uses the JupySQL package. See oth
...workflow is also available as a Google Colab notebook . Four additional libraries improve the DuckDB experience in Jupyter notebooks. jupysql : Convert a Jupyter code cell into a SQL cell Pandas : Clean table visualizations and compatibility with other an... - https://man.mtool.work/duckdb/2.0/guides/python/jupyter.html
- DBine SQL Editor 8573
- DBine is a free, open-source (Apache 2.0) desktop database manager for Windows, macOS, and Linux that works with 130+ databases and cloud services. Besides a SQL editor, it includes notebooks, charts built from query results, and schema com
... - https://man.mtool.work/duckdb/2.0/guides/sql_editors/dbine.html
- UI Extension 7933
- The ui extension adds a user interface for your local DuckDB instance. Usage To start the UI from the command line: duckdb -ui To start the UI from SQL: CALL start_ui(); Running either of these will open the UI in your default browser. The
...name⟩.csv';" -ui Running the UI in Read-Only Mode The DuckDB UI uses DuckDB tables as storage internally (e.g., for saving notebooks). Therefore, running the UI directly on a read-only database is not supported : duckdb -ui -readonly read_only_test.db In... - https://man.mtool.work/duckdb/2.0/core_extensions/ui.html
- Merge Statement for SCD Type 2 7457
- This is a practical, step-by-step guide to using DuckDB's MERGE statement (introduced in v1.4.0) to perform upserts and build Slowly Changing Dimension Type 2 (SCD Type 2) tables . Type 2 SCDs let you keep full historical versions of record
...ront end just run: duckdb -ui and you can navigate to http://localhost:4213/ to start writing your SQL code inside of your notebooks. Just copy and paste the following code blocks to follow this guide. Step 1: Create the Incoming (source) Table This table... - https://man.mtool.work/duckdb/2.0/guides/sql_features/merge.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work