Results of 1 - 10 of about 12 for body (0.002 sec.)
- Integration with Ibis 14167
- Ibis is a Python dataframe library that supports 20+ backends, with DuckDB as the default. Ibis with DuckDB provides a Pythonic interface for SQL with great performance. Warning Ibis 12.0.0 and earlier do not support DuckDB 2.0. The example
...DatabaseTable: penguins species string island string bill_length_mm float64 bill_depth_mm float64 flipper_length_mm int64 body_mass_g int64 sex string year int64 Ibis is lazily evaluated, so instead of seeing the data, we see the schema of the table...the table as a pandas DataFrame. penguins.head().to_pandas() species island bill_length_mm bill_depth_mm flipper_length_mm body_mass_g sex year 0 Adelie Torgersen 39.1 18.7 181.0 3750.0 male 2007 1 Adelie Torgersen 39.5 17.4 186.0 3800.0 female 2007...DatabaseTable: penguins species string island string bill_length_mm float64 bill_depth_mm float64 flipper_length_mm int64 body_mass_g int64 sex string year int64 Limit[r0, n=5] Ibis returns results as a pandas DataFrame using to_pandas , but isn't u... - https://man.mtool.work/duckdb/2.0/guides/python/ibis.html
- Securing Quack with a Reverse Proxy 10612
- By default, the Quack server binds to localhost and speaks plain HTTP. See Security for the rationale behind these configurations. For any deployment beyond local-only, the recommended pattern is the same as for any other HTTP-based databas
...tra config. 1. Run Caddy Save this Caddyfile : localhost:8443 { reverse_proxy 127.0.0.1:9494 { flush_interval -1 } request_body { max_size 256MB } } Then start Caddy: brew install caddy # macOS, for other platforms see https://caddyserver.com/docs/in...large: PREPARE carries SQL, APPEND carries # inserted DataChunks. The 1 MiB nginx default will fail mid-INSERT. client_max_body_size 256M; # Long-running queries can sit on the wire between FETCHes for # minutes. Raise the timeouts above nginx's defa...onses pass through immediately instead of # being buffered in Caddy. flush_interval -1 } # Equivalent of nginx `client_max_body_size`. PREPARE / APPEND bodies # can be much larger than the default request body cap. request_body { max_size 256MB } } C... - https://man.mtool.work/duckdb/2.0/quack/setup/reverse_proxy.html
- Iceberg Options 8702
- This page lists the options of the iceberg extension: the parameters accepted by the Iceberg functions , the options of the ATTACH and CREATE SECRET statements used to connect to a catalog , and the global settings. ATTACH Options To make a
...rver-side scan planning endpoint (if the catalog provides it) instead of planning the scan in DuckDB. iceberg_logging_post_body_truncate_limit UBIGINT 10000 Maximum number of characters of a REST Catalog POST request body to include in Iceberg log me...ssages. Longer bodies are truncated with a trailing ... (truncated) marker. Set to 0 to omit the body. Scan Options The following parameters can be passed to iceberg_scan , iceberg_column_stats , iceberg_metadata , iceberg_p... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_options.html
- SAMPLE Clause 8525
- The SAMPLE clause allows you to run the query on a sample from the base table. This can significantly speed up processing of queries, at the expense of accuracy in the result. Samples can also be used to quickly see a snapshot of the data w
...effect, not where the clause is written. Syntactically, the USING SAMPLE clause appears at the end of the SELECT statement body: after the WHERE , GROUP BY , HAVING , and QUALIFY clauses, and before ORDER BY and LIMIT . So it is written after groupin... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/sample.html
- Extension Repositories 8366
- New Support for custom extension repositories was introduced in DuckDB 2.0. This feature is currently work-in-progress and the syntax may still change. By default, DuckDB installs extensions from its built-in repositories ( core , core_nigh
......'; Extensions are signed using 2048-bit RSA keys. The key can be provided either in PEM format or as the base64-encoded body of the PEM format. Using a Repository Once a repository is registered, install and load its extensions by referring to the... - https://man.mtool.work/duckdb/2.0/extensions/extension_repositories.html
- COPY Statement 8101
- Examples Read a CSV file into the lineitem table, using auto-detected CSV options: COPY lineitem FROM 'lineitem.csv'; Read a CSV file into the lineitem table, using manually specified CSV options: COPY lineitem FROM 'lineitem.csv' (DELIMITE
...n DuckDB 2.0. For other data-modifying statements in CTEs, see Data-Modifying CTEs . COPY ... TO can also be used as a CTE body. The CTE returns the number of rows written. COPY ... FROM cannot be used as a CTE body. WITH copied(rows_written) AS ( CO... - https://man.mtool.work/duckdb/2.0/sql/statements/copy.html
- Import Data 8012
- Overview DuckDB-Wasm has multiple ways to import data, depending on the format of the data. Importing happens in two steps. The data file is registered in a virtual file system using one of the register functions ( registerFileBuffer , regi
...rray([255, 255, 255, 255, 0, 0, 0, 0]); const streamResponse = await fetch(`someapi`); const streamReader = streamResponse.body.getReader(); const streamInserts = []; while (true) { const { value, done } = await streamReader.read(); if (done) break;... - https://man.mtool.work/duckdb/2.0/clients/wasm/data_ingestion.html
- Create Synthetic Data 8012
- DuckDB lets you quickly generate synthetic datasets by combining a few building blocks: functions and clauses that generate rows , functions that generate values to fill those rows, and extensions that generate whole benchmark datasets. Thi
...oup under boy no… │ true │ │ 17776805813723356275 │ 2000-10-21 │ Commercial occur. │ Professor big but executive plan fast body b… │ false │ │ 13540103502347468651 │ 2023-08-23 │ Specific author. │ Across cut market eight. Thing pull open spa… │ fals... - https://man.mtool.work/duckdb/2.0/guides/snippets/create_synthetic_data.html
- Samples 8012
- Samples are used to randomly select a subset of a dataset. Examples Select a sample of exactly 5 rows from tbl using reservoir sampling: SELECT * FROM tbl USING SAMPLE 5; Select a sample of approximately 10% of the table using system sampli
...lias if one is present, and samples only that table. The USING SAMPLE clause is written at the end of the SELECT statement body and samples the result of the entire FROM clause, after all joins have been resolved. This distinction is relevant when th... - https://man.mtool.work/duckdb/2.0/sql/samples.html
- Security 7924
- This page covers Quack's security posture end to end: what the server exposes, what stays local, the role of a TLS-terminating reverse proxy, and the authentication / authorization callbacks the server runs on every connection and every que
...the Beyond SQL Macros section. Beyond SQL Macros SQL macros cover most authentication and authorization cases, but a macro body is restricted to a single expression and cannot execute DML directly: there is no INSERT , UPDATE , or DELETE inside a mac... - https://man.mtool.work/duckdb/2.0/quack/security.html
DuckDB 2.0 Documentation / man.mtool.work