Results of 1 - 10 of about 18 for verify (0.002 sec.)
- Multiple Connections 14944
- For tests whose purpose is to verify that the transactional management or versioning of data works correctly, it is generally necessary to use multiple connections. For example, if we want to verify that the creation of tables is correctly
...statement or query . All queries with the same connection label will be executed in the same connection. A test that would verify the above property would look as follows: statement ok con1 BEGIN TRANSACTION statement ok con1 CREATE TABLE integers (i I... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/multiple_connections.html
- HTTP(S) Support 10569
- With the httpfs extension, it is possible to directly query files over the HTTP(S) protocol. This works for all files supported by DuckDB or its various extensions, and provides read-only access. SELECT * FROM 'https://domain.tld/file.exten
...all HTTP requests using an HTTP secret you can do so with the following statement: CREATE SECRET disable_ssl ( TYPE HTTP, VERIFY_SSL 0 ); To enable it again for one specific endpoint, you can take advantage of the scope parameter: CREATE SECRET enable..._ssl_for_your_website ( TYPE HTTP, SCOPE 'https://⟨your-website.com⟩', VERIFY_SSL 1 );... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/https.html
- S3 API Support 8888
- The httpfs extension supports reading/writing/ globbing files on object storage servers using the S3 API. S3 offers a standard API to read and write to remote files (while regular http servers, predating S3, do not offer a common write API)
...th S3 , GCS , R2 STRING vhost for S3 , path for R2 and GCS USE_SSL Whether to use HTTPS or HTTP S3 , GCS , R2 BOOLEAN true VERIFY_SSL Whether to verify the SSL certificate of the server S3 , GCS , R2 BOOLEAN true ACCOUNT_ID The R2 account ID to use for... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/s3api.html
- MySQL Extension 8888
- The mysql extension allows DuckDB to directly read and write data from/to a running MySQL instance. The data can be queried directly from the underlying MySQL database. Data can be loaded from MySQL tables into DuckDB tables, or vice versa.
...d parameters. Setting Description ssl_mode The security state to use for the connection to the server: disabled, required, verify_ca, verify_identity or preferred (default: preferred ) ssl_ca The path name of the Certificate Authority (CA) certificate... - https://man.mtool.work/duckdb/2.0/core_extensions/mysql.html
- Loops 8630
- Loops can be used in sqllogictests when it is required to execute the same query many times but with slight modifications in constant values. For example, suppose we want to fire off 100 queries that check for the presence of the values 0..
...ate the table 'integers' with values 0...100 statement ok CREATE TABLE integers AS SELECT * FROM range(0, 100, 1) t1(i); # verify individually that all 100 values are there loop i 0 100 # execute the query, replacing the value query I SELECT count(*) F... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/loops.html
- Pragmas 8390
- The PRAGMA statement is a SQL extension adopted by DuckDB from SQLite. PRAGMA statements can be issued in a similar manner to regular SQL statements. PRAGMA commands may alter the internal state of the database engine, and can influence the
...able_verification; Disable query verification: PRAGMA disable_verification; Enable force parallel query processing: PRAGMA verify_parallelism; Disable force parallel query processing: PRAGMA disable_verify_parallelism; Block Sizes When persisting a dat... - https://man.mtool.work/duckdb/2.0/configuration/pragmas.html
- Connect 8150
- Overview The Go client works through the standard database/sql types: a *sql.DB is a pool of connections to a DuckDB database. This page covers opening in-memory and file-backed databases, passing DuckDB configuration options, running initi
...arily open a connection: it validates its arguments and returns a *sql.DB that opens connections lazily. Call db.Ping() to verify that the database is reachable. Data Source Names DuckDB configuration options are appended to the DSN as URL-style name=v... - https://man.mtool.work/duckdb/2.0/clients/go/connecting.html
- Result Verification 8150
- The standard way of verifying results of queries is using the query statement, followed by the letter I times the number of columns that are expected in the result. After the query, four dashes ( ---- ) are expected followed by the result v
...s existence. Query Labels Another feature that can be used for result verification are query labels . These can be used to verify that different queries provide the same result. This is useful for comparing queries that are logically equivalent, but fo... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/result_verification.html
- Extension Distribution 8150
- Platforms Extension binaries are distributed for several platforms (see below). For platforms where packages for certain extensions are not available, users can build them from source and install the resulting binaries manually . Most offic
...g Signed Extensions Extensions can be signed with a cryptographic key. By default, DuckDB uses its built-in public keys to verify the integrity of extensions before loading them. All core and community extensions are signed by the DuckDB team. In addit... - https://man.mtool.work/duckdb/2.0/extensions/extension_distribution.html
- Tableau – A Data Visualization Tool 8150
- Tableau is a popular commercial data visualization tool. In addition to a large number of built-in connectors, it also provides generic database connectivity via ODBC and JDBC connectors. Tableau has two main versions: Desktop and Online (S
...ableau\Connectors . Then issue these commands to disable signature validation: tsm configuration set -k native_api.disable_verify_connector_plugin_signature -v true tsm pending-changes apply The last command will restart the server with the new setting...ment to disable signature validation: /Applications/Tableau\ Desktop\ ⟨year⟩.⟨quarter⟩.app/Contents/MacOS/Tableau -DDisableVerifyConnectorPluginSignature=true You can also package this up with AppleScript by using the following script: do shell script..."\"/Applications/Tableau Desktop 2023.2.app/Contents/MacOS/Tableau\" -DDisableVerifyConnectorPluginSignature=true" quit Create this file with the Script Editor (located in /Applications/Utilities ) and save... - https://man.mtool.work/duckdb/2.0/guides/data_viewers/tableau.html
DuckDB 2.0 Documentation / man.mtool.work