Results of 1 - 10 of about 19 for relevant (0.001 sec.)
- Load Extensions 12191
- Overview DuckDB-Wasm's (dynamic) extension loading is modeled after regular DuckDB's extension loading, with a few relevant differences due to the difference in platform. A growing subset of core, community, and external extensions is suppo
...fic limitations that prevent some extensions from matching their native capabilities or that make them behave differently. Relevant differences for DuckDB-hosted extensions are documented below. HTTPFS The native HTTPFS extension is not compiled into Duc...b.org , which is used as the extension repository unless custom_extension_repository is set. When installing extensions, a relevant URL will be built that will look like extensions.duckdb.org/$duckdb_version_hash/$duckdb_platform/$name.duckdb_extension.g... - https://man.mtool.work/duckdb/2.0/clients/wasm/extensions.html
- Quack on WebAssembly 11867
- CloudFormation Stack We provide an example template for initializing a CloudFormation stack, based on pre-baked public AMI, based on Ubuntu, which will: via DuckDB, install and load Quack, create a randomized token, and do quack_serve on th
...class, and click Launch Stack . This will incur billing. Make sure you check the stack page afterward, and delete the non-relevant anymore stacks. Deploy via aws CLI To deploy a Quack demo with the name my-quack-demo in the us-east-2 region, run: aws cl...cks \ --stack-name my-quack-demo \ --region us-east-2 \ --query 'Stacks[0].Outputs' \ --output table Now you can visit the relevant link, that will encode connecting to the just created quack server via DuckDB-Wasm. Destroy aws cloudformation delete-stac... - https://man.mtool.work/duckdb/2.0/quack/setup/quack_wasm.html
- Querying Parquet Files 11218
- To run a query directly on a Parquet file, use the read_parquet function in the FROM clause of a query. SELECT * FROM read_parquet('input.parquet'); The Parquet file will be processed in parallel. Filters will be automatically pushed down i
...nto the Parquet scan, and only the relevant columns will be read automatically. For more information see the blog post “Querying Parquet with Precision using DuckDB”... - https://man.mtool.work/duckdb/2.0/guides/file_formats/query_parquet.html
- Deploy 9903
- Overview Deploying DuckDB-Wasm means serving its components so that the browser can fetch and instantiate them. This page describes each component a deployment needs to serve, how the worker and WebAssembly variants relate, how extensions a
...nt. Compiled as a WebAssembly file and instantiated by the browser. For further details, see below. DuckDB Extensions. Any relevant extensions the deployment loads. For further details, see below. Main Library Component This component is distributed as T...he default extension endpoint: https://extensions.duckdb.org . If you are deploying duckdb-wasm you can consider mirroring relevant extensions at a different endpoint, possibly allowing for air-tight deployments on internal networks. SET custom_extension... - https://man.mtool.work/duckdb/2.0/clients/wasm/deploying_duckdb_wasm.html
- S3 Parquet Import 9903
- Prerequisites To load a Parquet file from S3, the httpfs extension is required. This can be installed using the INSTALL SQL command. This only needs to be run once. INSTALL httpfs; To load the httpfs extension for usage, use the LOAD SQL co
...torage (GCS) and Cloudflare R2 DuckDB can also handle Google Cloud Storage (GCS) and Cloudflare R2 via the S3 API. See the relevant guides for details.... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/s3_import.html
- NULL Values 8930
- NULL values are special values that are used to represent missing data in SQL. Columns of any type can contain NULL values. Logically, a NULL value can be seen as “the value of this field is unknown”. A NULL value can be inserted to any fie
...t , list and array_agg . To exclude NULL values from these results, use a FILTER clause with a predicate that excludes the relevant null rows, such as list(x) FILTER (WHERE x IS NOT NULL) . A different filter predicate does not remove NULL values from ro... - https://man.mtool.work/duckdb/2.0/sql/data_types/nulls.html
- S3 and AWS Authentication 8605
- This page is the entry point for authenticating to S3 and other AWS services from DuckDB. Authentication is configured using secrets , and the detailed reference material lives on the S3 API Support and AWS Extension pages. The sections bel
...ow explain which method to use and link to the relevant reference. Choosing an Authentication Method There are two S3 secret providers. Use the config provider when you have stat... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/authentication.html
- Troubleshooting of Extensions 8605
- You might be visiting this page directed via a DuckDB error message, similar to: INSTALL non_existing; HTTP Error: Failed to download extension "non_existing" at URL "http://extensions.duckdb.org/v2.0.0/osx_arm64/non_existing.duckdb_extensi
...nual Process to Download Extensions via the Browser To check if an extension is available, consider trying to download the relevant extension resource, for example via your browser visiting https://extensions.duckdb.org/v2.0.0/osx_arm64/spatial.duckdb_ex... - https://man.mtool.work/duckdb/2.0/extensions/troubleshooting.html
- Writing Tests 8264
- Development and Testing It is crucial that any new features that get added have correct tests that not only test the “happy path”, but also test edge cases and incorrect usage of the feature. In this section, we describe how DuckDB tests ar
...framework . Client Connector Tests DuckDB also has tests for various client connectors. These are generally written in the relevant client language, and can be found in tools/*/tests . They also double as documentation of what should be doable from a giv... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/writing_tests.html
- sqllogictest Introduction 7940
- For testing plain SQL, we use an extended version of the SQL logic test suite, adopted from SQLite . Every test is a single self-contained file located in the test/sql directory. To run tests located outside of the default test directory, s
...always the relative file path of the file. The group is the folder that the file is in. The name and group of the test are relevant because they can be used to execute only that test in the unittest group. For example, if we wanted to execute only the ab... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/intro.html
DuckDB 2.0 Documentation / man.mtool.work