Results of 1 - 10 of about 69 for pass (0.002 sec.)
- GDAL Integration 15412
- The spatial extension integrates the GDAL translator library to read and write spatial data from a variety of geospatial vector file formats. See the documentation for the st_read table function for how to make use of this in practice. In o
...t. Use ST_Drivers() to list the names of all available drivers. GEOMETRY_TYPE : the geometry type for the created layer to pass to the GDAL driver. One of POINT , LINESTRING , POLYGON , MULTIPOINT , MULTILINESTRING , MULTIPOLYGON and GEOMETRYCOLLECTI...ON . LAYER_NAME : assign an alternate name to the new layer LAYER_CREATION_OPTIONS : list of layer creation options to pass to the GDAL driver. Use parenthesis to pass a list of options. See the GDAL docs for the driver you are using for a list o...f available options. DATASET_CREATION_OPTIONS : list of dataset creation options to pass to the GDAL driver. Use parenthesis to pass a list of options. See the GDAL docs for the driver you are using for a list o... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/gdal.html
- ODBC Extension Functions 11793
- odbc_begin_transaction odbc_bind_params odbc_close odbc_commit odbc_connect odbc_copy odbc_create_params odbc_list_data_sources odbc_list_drivers odbc_query odbc_rollback odbc_begin_transaction odbc_begin_transaction(conn_handle BIGINT) ->
...with odbc_create_params params ( STRUCT ): parameters values Returns: Parameters handle ( BIGINT ), the same one that was passed as a second argument. Example: SELECT odbc_bind_params(getvariable('conn'), getvariable('params1'), row(42, 'foo')) odbc...able('conn')) odbc_connect odbc_connect(conn_string VARCHAR) -> BIGINT odbc_connect(conn_string VARCHAR, username VARCHAR, password VARCHAR) -> BIGINT Opens an ODBC connection to a remote DB. If username and password (positional) parameters are speci..., they are appended to the connection string as UID and PWD . Parameters: conn_string ( VARCHAR ): ODBC connection string, passed to the Driver Manager. Returns: Connection handle that can be placed into a VARIABLE . Connection is not closed automati... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/functions.html
- Quack Remote Protocol 10138
- The Quack extension turns a DuckDB instance into a server that other DuckDB instances (clients) can connect to over HTTP. This page covers the protocol at a glance and walks through basic usage on both sides of the wire. For the full list o
...the default authentication function is in use, the auth_token that clients need to connect. To choose the token yourself, pass the token parameter (see Security ): {:.codebox-server} CALL quack_serve('quack:localhost', token = '⟨my_token⟩'); Tip The...By default the server refuses to bind anything other than a local hostname. To listen on an externally-reachable address, pass allow_other_hostname = true : {:.codebox-server} CALL quack_serve('quack:0.0.0.0:9494', allow_other_hostname = true); Non-...local servers serve HTTPS by default, using a self-signed certificate unless you pass ssl_cert_file and ssl_key_file (see the Reference ). For production deployments, we recommend binding the server to localh... - https://man.mtool.work/duckdb/2.0/quack/overview.html
- Python DB API 9968
- The standard DuckDB Python API provides a SQL interface compliant with the DB-API 2.0 specification described by PEP 249 similar to the SQLite Python API . Connection To use the module, you must first create a DuckDBPyConnection object that
...ELECT * FROM tbl") ┌───────┐ │ a │ │ int32 │ ├───────┤ │ 42 │ └───────┘ To make another connection the default connection, pass it to duckdb.set_default_connection() : import duckdb con = duckdb.connect() con.execute("CREATE TABLE answer AS SELECT 42...eter sets of an executemany() call. It is -1 after a query and after a statement with a RETURNING clause. Query Parameters Pass parameter values as the second argument to execute() . Use ? with a list in placeholder order, $1 to reuse a list value or...$name with a dictionary. Pass values separately from the SQL text. The query then runs as a prepared statement , and the values are converted according... - https://man.mtool.work/duckdb/2.0/clients/python/dbapi.html
- Avro Extension 8328
- The avro extension enables DuckDB to read Apache Avro files. The avro extension was released as a community extension in late 2024 and became a core extension in early 2025. The read_avro Function The extension adds a single DuckDB function
...avro('s3://⟨your-bucket⟩/⟨some_file⟩.avro'); should "just" work. You can also glob multiple files in a single read call or pass a list of files to the functions: FROM read_avro('some_file_*.avro'); FROM read_avro(['some_file_1.avro', 'some_file_2.avr...o']); If the filenames somehow contain valuable information (as is unfortunately all-too-common), you can pass the filename argument to read_avro : FROM read_avro('some_file_*.avro', filename=true); This will result in an additional... - https://man.mtool.work/duckdb/2.0/core_extensions/avro.html
- Delta Extension 8328
- The delta extension adds support for the Delta Lake open-source storage format . It is built using the Delta Kernel . The extension reads Delta tables, local and remote, and writes them: it can create tables and append to them. For implemen
...⟩, ⟨app_id⟩) , which returns NULL if no version has been recorded yet. Attach Options When attaching a Delta table you can pass the following options to ATTACH : Option Type Default Description VERSION UBIGINT latest Attach the table at a specific ta...e. have_deletes BOOLEAN Whether the file has an associated deletion vector. To list the files of an earlier table version, pass version => ⟨version⟩ . To add a delete_count column with the number of rows each file's deletion vector removes, pass dele...e v1.5.1, delta_domain_metadata returns one row per domain of a table, with the VARCHAR columns domain and configuration . Pass version => ⟨version⟩ for an earlier version: SELECT domain, configuration FROM delta_domain_metadata('file:///⟨path⟩'); Fo... - https://man.mtool.work/duckdb/2.0/core_extensions/delta.html
- Deploy as Native Image 8158
- Overview The JDBC driver runs inside GraalVM Native Image executables. Graal Native Image compiles a Java application ahead of time into a standalone binary that starts in milliseconds and requires no JVM on the target machine, which suits
...he tracing agent : bash java -agentlib:native-image-agent=config-output-dir=⟨config_dir⟩ -cp ⟨classpath⟩ ⟨MainClass⟩ Next, pass the directory to the build with -H:ConfigurationFileDirectories=⟨config_dir⟩ . Requirements GraalVM for JDK 22 or later is...t image build time, which bakes a build machine path into the executable and fails at run time with UnsatisfiedLinkError . Pass --enable-native-access=ALL-UNNAMED to native-image , or add it as a build argument in the Native Build Tools Maven or Grad...bed the Library in the Executable Add a resource entry naming your platform's library, either in a configuration directory passed via -H:ConfigurationFileDirectories or under META-INF/native-image in your own project: { "resources": { "includes": [ {... - https://man.mtool.work/duckdb/2.0/clients/java/deploy_native_image.html
- Catalogs 8003
- The iceberg extension supports attaching Iceberg REST Catalogs. Attaching a catalog is required for writing to Iceberg . Before attaching an Iceberg REST Catalog, you must install the iceberg extension by following the instructions located
...ogin credentials for the OAuth2 service. CREATE SECRET iceberg_secret ( TYPE iceberg, CLIENT_ID '⟨admin⟩', CLIENT_SECRET '⟨password⟩', OAUTH2_SERVER_URI '⟨http://iceberg_rest_catalog_url.com/v1/oauth/tokens⟩' ); If you already have a Bearer token, yo...u can pass it directly to your CREATE SECRET statement CREATE SECRET iceberg_secret ( TYPE iceberg, TOKEN '⟨bearer_token⟩' ); You can...following ATTACH statement. LOAD httpfs; ATTACH '⟨warehouse⟩' AS iceberg_catalog ( TYPE iceberg, SECRET iceberg_secret, -- pass a specific secret name to prevent ambiguity URI '⟨https://rest_endpoint.com⟩' ); To see the available tables run SHOW ALL... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/catalogs.html
- Profiling 7833
- Profiling is essential to help understand why certain queries exhibit specific performance characteristics. DuckDB contains several built-in features to enable query profiling, which this page covers. For a high-level example of using EXPLA
...However, it is often also necessary to examine the performance numbers of individual operators and the cardinalities that pass through them. The EXPLAIN ANALYZE statement enables obtaining these, as it pretty-prints the query plan and also executes...t format: 'query_tree' , 'json' , 'query_tree_optimizer' , 'no_output' All parameters are optional and named. You can also pass metrics as an unnamed parameter: CALL enable_profiling(['query.total_time', 'query.total_intermediate_size_bytes']); disab... - https://man.mtool.work/duckdb/2.0/dev/profiling.html
- Securing Quack with a Reverse Proxy 7833
- 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
...inutes. Raise the timeouts above nginx's default 60s. proxy_read_timeout 600s; proxy_send_timeout 600s; location / { proxy_pass http://127.0.0.1:9494; # Keep-alive against upstream. Quack relies on persistent # connections to keep server-side `quack_...reverse_proxy 127.0.0.1:9494 { # Equivalent of nginx `proxy_buffering off`. Required so Quack's # streamed FETCH responses pass through immediately instead of # being buffered in Caddy. flush_interval -1 } # Equivalent of nginx `client_max_body_size`... - https://man.mtool.work/duckdb/2.0/quack/setup/reverse_proxy.html
DuckDB 2.0 Documentation / man.mtool.work