Results of 1 - 9 of about 9 for validation (0.002 sec.)
- AWS Extension 12798
- The aws extension adds functionality, e.g., authentication, on top of the httpfs extension's S3 capabilities , using the AWS SDK. Installing and Loading The aws extension will be transparently autoloaded on first use from the official exten
...adding a region to your profile in ~/.aws/config or configure the AWS_REGION or AWS_DEFAULT_REGION environment variables. Validation The AWS credential_chain provider will look for any required credentials during CREATE SECRET time, failing if absent/unav...ailable. This behavior may be configured via the VALIDATION option as follows: CREATE OR REPLACE SECRET secret ( TYPE s3, PROVIDER credential_chain, VALIDATION 'exists' ); Two valida...) requires present credentials. none allows CREATE SECRET to succeed for credential_chain s with no available credentials. VALIDATION 'exists' validates only the presence of a credential, not its operational readiness . Thus, no attempt is made to convert... - https://man.mtool.work/duckdb/2.0/core_extensions/aws.html
- Tableau – A Data Visualization Tool 11683
- 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
...s . On Windows, copy the Taco file to C:\Program Files\Tableau\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...itory/Connectors folder. Then launch Tableau Desktop from the Terminal with the command line argument to disable signature validation: /Applications/Tableau\ Desktop\ ⟨year⟩.⟨quarter⟩.app/Contents/MacOS/Tableau -DDisableVerifyConnectorPluginSignature=true...en launch Tableau Desktop from a shell with the -DDisableVerifyConnectorPluginSignature=true argument to disable signature validation. Output Once loaded, you can run queries against your data! Here is the result of the first H2O.ai benchmark query from th... - https://man.mtool.work/duckdb/2.0/guides/data_viewers/tableau.html
- Configuration 8592
- DuckDB has a number of configuration options that can be used to change the behavior of the system. The configuration options can be set using either the SET statement or the PRAGMA statement . They can be reset to their original values usi
...t The WAL size threshold at which to automatically trigger a checkpoint, e.g., 1GB. VARCHAR 16.0 MiB current_transaction_invalidation_policy Which types of exceptions invalidate the database for the current transaction. VARCHAR STANDARD_POLICY custom_exten...SCENDING default_secret_storage Allows switching the default storage for secrets. VARCHAR local_file default_transaction_invalidation_policy When to invalidate transactions when errors occur. SYNTACTIC_ERRORS_DO_NOT_INVALIDATE means that parser and binder...dialect compatibility for a certain engine, e.g., SET dialect_compatibility_mode='spark' . VARCHAR NONE disable_database_invalidation Disables invalidating the database instance when encountering a fatal error. Should be used with great care, as DuckDB can... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
- S3 and AWS Authentication 8592
- 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
...STS) Web Identity (IRSA) Single Sign-On (SSO) For behavior common to all credential_chain secrets, see Region Resolution , Validation , and Auto-Refresh . Secret Parameters The full list of S3 secret parameters that apply to both providers ( ENDPOINT , REG... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/authentication.html
- sqllogictest Introduction 8142
- 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
...be done through the following PRAGMA statement: statement ok PRAGMA enable_verification Query verification performs extra validation to ensure that the underlying code runs correctly. The most important part of that is that it verifies that optimizers do... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/intro.html
- What's New in the Docs for 2.0 8142
- This page tracks the documentation for the features introduced in DuckDB 2.0, organized around the themes of the DuckDB 2.0.0 release announcement . Each section links to the relevant documentation. DuckDB as a Server: Quack and CONNECT Sin
...e files use the v2.0.0 storage format by default. The format adds lazy metadata loading, better compression and corruption validation. DuckDB versions before 2.0 cannot read files in the new format, so a migration guide covers upgrading existing deployment... - https://man.mtool.work/duckdb/2.0/whats_new_in_the_docs.html
- S3 API Support 7693
- 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)
...f credential_chain options — CHAIN values, profile selection, assuming roles, SSO, web identity (IRSA), region resolution, validation, and auto-refresh — see the AWS extension page . Overview of S3 Secret Parameters Below is a complete list of the supporte... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/s3api.html
- Storage Versions and Format 7693
- Compatibility Backward Compatibility Backward compatibility refers to the ability of a newer DuckDB version to read storage files created by an older DuckDB version. Version 0.10 is the first release of DuckDB that supports backward compati
...ng compression method by default (see Compression ); stores row deletions more compactly; and performs stronger corruption validation when reading data. Explicit Storage Versions DuckDB 1.2.0 introduced the STORAGE_VERSION option , which allows explicitly... - https://man.mtool.work/duckdb/2.0/internals/storage.html
- Reading and Writing Parquet Files 7477
- Examples Read a single Parquet file: SELECT * FROM 'test.parquet'; Figure out which columns/types are in a Parquet file: DESCRIBE SELECT * FROM 'test.parquet'; Create a table from a Parquet file: CREATE TABLE test AS SELECT * FROM 'test.par
...s if it has the supplied schema. The MAP can be keyed by field-id ( INTEGER ) or by column name ( VARCHAR ). MAP NULL utf8_validation How to handle invalid UTF-8 in string columns. With strict , an error is thrown. With replace , invalid bytes are replaced... - https://man.mtool.work/duckdb/2.0/data/parquet/overview.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work