Results of 1 - 10 of about 43 for disable (0.002 sec.)
- Pragmas 14685
- 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
...s: PRAGMA enable_progress_bar; Or: PRAGMA enable_print_progress_bar; Don't show a progress bar for running queries: PRAGMA disable_progress_bar; Or: PRAGMA disable_print_progress_bar; EXPLAIN Output The output of EXPLAIN can be configured to show only t...; Database drivers and other applications can also access profiling information through API calls, in which case users can disable any other output. Even though the parameter reads no_output , it is essential to note that this only affects printing to t...ic_type, unit FROM duckdb_available_metrics(); The profiling documentation contains an overview of the available metrics . Disable Profiling To disable profiling: PRAGMA disable_profiling; PRAGMA disable_profile; Query Optimization Optimizer To disable... - https://man.mtool.work/duckdb/2.0/configuration/pragmas.html
- Configuration 10859
- 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
...ase. ENABLED requests a checkpoint, but the checkpoint does not occur if another connection still references the database. DISABLED never checkpoints, DEFAULT defers to the global checkpoint_on_shutdown setting. VARCHAR DEFAULT checkpoint_threshold , wa...ty_mode Enable SQL 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 gre...at care, as DuckDB cannot guarantee correct behavior after a fatal error. BOOLEAN false disable_parquet_prefetching Disable the prefetching mechanism in Parquet BOOLEAN false disable_timestamptz_casts Disable casting f... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
- Profiling 10643
- 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
...ers the query graph and opens it in a web browser, and the .web dot command does the same for the previous query. Both are disabled in safe mode . Pragmas DuckDB supports several pragmas for turning profiling on and off and controlling the level of deta...ct ['*'] (all metrics) A list of metric glob patterns, e.g. ['query.*', 'optimizer.*'] . ( List of all available metrics ) disable_profiling , disable_profile Turn off profiling Table Functions These table functions were introduced in DuckDB 1.5.0. Duck...DB provides table functions to enable and disable profiling, consolidating multiple settings into a single call. enable_profiling() The enable_profiling() function configur... - https://man.mtool.work/duckdb/2.0/dev/profiling.html
- Building Extensions 9795
- Extensions can be built from source and installed from the resulting local binary. Building Extensions To build using extension flags, set the BUILD_EXTENSIONS flag to the list of extensions that you want to be built. For example: BUILD_EXT
...e TPC-H and TPC-DS, jemalloc is not an extension. It is only supported on 64-bit Linux, where it is enabled by default. To disable it, set BUILD_JEMALLOC=0 . BUILD_TPCE When this flag is set, the TPCE library is built. Unlike TPC-H and TPC-DS this is no...rnalException in debug builds. With this flag enabled, when the assertion triggers it will instead directly cause a crash. DISABLE_STRING_INLINE In our execution format string_t has the feature to “inline” strings that are under a certain length (12 byt...es), this means they don't require a separate allocation. When this flag is set, we disable this and don't inline small strings. DISABLE_MEMORY_SAFETY Our data structures that are used extensively throughout the no... - https://man.mtool.work/duckdb/2.0/dev/building/building_extensions.html
- Securing DuckDB 9378
- DuckDB is a powerful analytical database engine. It can read and write files, access the network, load extensions, and use system resources. Like any powerful tool, these capabilities require appropriate configuration when working with sens
...re extensions when certain SQL statements require them. To maintain full control over which extensions are loaded, you can disable autoloading: SET autoload_known_extensions = false; SET autoinstall_known_extensions = false; Core vs. Community Extension...M community . These are not maintained by the DuckDB team, so only install community extensions from sources you trust. To disable community extensions entirely: SET allow_community_extensions = false; Serving DuckDB over the Network With the quack exte...local file system, for example: SELECT * FROM read_csv('/etc/passwd', sep = ':'); Disabling File Access File access can be disabled in two ways. First, you can disable individual file systems. For example: SET disabled_filesystems = 'LocalFileSystem'; S... - https://man.mtool.work/duckdb/2.0/operations_manual/securing_duckdb/overview.htm...
- Tableau – A Data Visualization Tool 9270
- 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
.../tableau/connectors . 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-ch...s/My Tableau Repository/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 -DDisableVerifyConnector...ript 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... - https://man.mtool.work/duckdb/2.0/guides/data_viewers/tableau.html
- Persistent Testing 9054
- By default, all tests are run in in-memory mode (unless --force-storage is enabled). In certain cases, we want to force the usage of a persistent database. We can initiate a persistent database using the load command, and trigger a reload o
...= '0KB' – meaning a checkpoint is triggered after every statement. WAL tests typically run with the following settings to disable this behavior: statement ok PRAGMA disable_checkpoint_on_shutdown statement ok SET wal_autocheckpoint = '1TB'... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/persistent_testing.html
- Building Configuration 8530
- Build Types DuckDB can be built in many different settings, most of these correspond directly to CMake but not all of them. release This build has been stripped of all the assertions and debug symbols and code, optimized for performance. de
...hen this flag is set, DuckDB's in-house benchmark suite is built. More information about this can be found in the README . DISABLE_SHELL The CLI is built by default. When this flag is set, the CLI is not built. Miscellaneous Flags DISABLE_UNITY To impro...ve compilation time, we use Unity Build to combine translation units. This can however hide include bugs, this flag disables using the unity build so these errors can be detected. DISABLE_SANITIZER In some situations, running an executable that h...ers enabled is not supported / can cause problems. Julia is an example of this. With this flag enabled, the sanitizers are disabled for the build. Overriding Git Hash and Version It is possible to override the Git hash and version when building from sou... - https://man.mtool.work/duckdb/2.0/dev/building/build_configuration.html
- Securing Extensions 8530
- DuckDB has a powerful extension mechanism, which has the same privileges as the user running DuckDB's (parent) process. This introduces security considerations. Therefore, we recommend reviewing the configuration options listed on this page
...database is running. If you run DuckDB in an environment where only extensions signed by the DuckDB team should be loaded, disable custom repositories: SET allow_extension_repositories = 'forbidden'; Community Extensions DuckDB has a Community Extension...g Autoinstalling and Autoloading Known Extensions By default, DuckDB automatically installs and loads known extensions. To disable autoinstalling known extensions, run: SET autoinstall_known_extensions = false; To disable autoloading known extensions, r... - https://man.mtool.work/duckdb/2.0/operations_manual/securing_duckdb/securing_ext...
- Quack Remote Protocol 8422
- 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
...utomatically for local URIs ( localhost , 127.0.0.1 , ::1 ) and HTTPS otherwise. Either default can be overridden with the DISABLE_SSL configuration option. Stateless Queries with quack_query You can run any SQL against a server without attaching it. To..., run: {:.codebox-client} FROM quack_query( 'quack:remote.com', 'SELECT 42', token = '⟨MY_QUACK_TOKEN_01234567890ABCDEF⟩', disable_ssl = true ); The query executes remotely and the server streams the result back. Errors occurring on the server (parse er...plain-HTTP remote: {:.codebox-client} ATTACH 'quack:remote.com' AS remote_db ( TOKEN '⟨MY_QUACK_TOKEN_01234567890ABCDEF⟩', DISABLE_SSL true ); Once attached, remote tables look and behave like local ones: {:.codebox-client} CREATE TABLE remote_db.t AS F... - https://man.mtool.work/duckdb/2.0/quack/overview.html
DuckDB 2.0 Documentation / man.mtool.work