Results of 1 - 10 of about 23 for Script (0.001 sec.)
- Install Script 13623
- You can install the DuckDB CLI client using an install script. Linux and macOS To use the DuckDB install script on Linux and macOS, run: curl https://install.duckdb.org | bash Click to see the output of the install script. % Total % Receive
...Total Spent Left Speed 100 13209 100 13209 0 0 126k 0 --:--:-- --:--:-- --:--:-- 127k *** DuckDB Linux/MacOS installation script, version 2.0.0 *** .;odxdl, .xXXXXXXXXKc 0XXXXXXXXXXXd cooo: ,XXXXXXXXXXXXK OXXXXd 0XXXXXXXXXXXo cooo: .xXXXXXXXXKc .;odxd...ttps://install.duckdb.org | DUCKDB_VERSION=1.2.2 bash Installing the C/C++ Libraries Starting with DuckDB 2.0, the install script can also install the DuckDB C/C++ headers and libraries using the DUCKDB_INSTALL variable. It takes a comma-separated list...kdb/lib/2.0.0/release_osx_arm64 . For more details, see Linking Extensions . Windows On Windows, we provide a beta install script. To use it, run the following command from the Run menu (Win+R) or the Command Prompt: powershell -NoExit -ExecutionPolicy... - https://man.mtool.work/duckdb/2.0/operations_manual/installing_duckdb/install_sc...
- Command Line Arguments 11897
- The table below summarizes DuckDB's command line options. To list all command line options, use the command: duckdb -help For a list of dot commands available in the CLI shell, see the Dot Commands page . Argument Description -agent Render
...e to csv -dark-mode Use dark mode colors for syntax highlighting -echo Print commands before execution -f FILENAME Run the script in FILENAME and exit. Note that the ~/.duckdbrc is read and executed first (if it exists) -format Format SQL read from std...he result to stdout -format-file FILENAME Format the SQL in FILENAME , writing the result to stdout -init FILENAME Run the script in FILENAME upon startup (instead of ~/.duckdbrc ) -header Turn headers on -h Show the help message -help Show the help me...duckdb -csv -c 'SELECT 42 AS hello' -json -c 'SELECT 84 AS world' Returns the following: hello 42 [{"world":84}] The -init script (or the default ~/.duckdbrc when -init is not given) is an exception: it always runs at startup, before any -cmd , -c , or... - https://man.mtool.work/duckdb/2.0/clients/cli/arguments.html
- Tableau – A Data Visualization Tool 10070
- 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
...espite what the Tableau documentation says, the real security risk is in the JDBC driver code, not the small amount of JavaScript in the Taco file.) Server (Online) On Linux, copy the Taco file to /opt/tableau/connectors . On Windows, copy the Taco fil...⟩.⟨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\" -DDisa...bleVerifyConnectorPluginSignature=true" quit Create this file with the Script Editor (located in /Applications/Utilities ) and save it as a packaged application : You can then double-click it to launc... - https://man.mtool.work/duckdb/2.0/guides/data_viewers/tableau.html
- ODBC API on Linux 9936
- Driver Manager A driver manager is required to manage communication between applications and the ODBC driver. We tested and support unixODBC that is a complete ODBC driver manager for Linux. Users can install it from the command line: On De
...m64 (AArch64) The package contains the following files: libduckdb_odbc.so : the DuckDB driver. unixodbc_setup.sh : a setup script to aid the configuration on Linux. To extract them, run: batch mkdir duckdb_odbc && unzip duckdb_odbc-linux-amd64.zip -d d...uckdb_odbc The unixodbc_setup.sh script performs the configuration of the DuckDB ODBC Driver. It is based on the unixODBC package that provides some commands to h...f not provided. -D driver_path: the driver file path (i.e., the path for libduckdb_odbc.so), the default is using the base script directory ``` The ODBC setup on Linux is based on the .odbc.ini and .odbcinst.ini files. These files can be placed to the... - https://man.mtool.work/duckdb/2.0/clients/odbc/linux.html
- Unit Tester Configuration 9568
- There are three ways of setting options for the unit tester: Command Line Arguments Configuration File Environment Variables Configuration Options List See the Configuration Options List for the full list of available options. Command Line
...int-on-shutdown # other types unittest --checkpoint-wal-size 100000 Command line options --settings , --on-init and --init-script can be used to specify DuckDB configuration . Configuration File A JSON file that can be passed in using --test-config . S..."checkpoint_on_shutdown": "false" } The following additional options can also be used in the configuration file: Option Description extends List of config files to extend from inherit_skip_tests Path of config to inherit skip_tests from skip_tests Tes...T_CHECKPOINT_ON_SHUTDOWN=1 unittest Configuration Options List The following configuration options are available: Option Description --autoloading <none|available|all> Loading strategy for extensions not bundled in --base-config <path> Config file to l... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/test_configuration.html
- Importing Duckbox Tables 9568
- The scripts provided in this page work on Linux, macOS, and WSL. By default, the DuckDB CLI client renders query results in the duckbox format , which uses rich, ASCII-art inspired tables to show data. These tables are often shared verbatim
...─┘ What if we would like to load this data back to DuckDB? This is not supported by default but it can be achieved by some scripting: we can turn the table into a │ -separated file and read it with DuckDB's CSV reader . Note that the separator is not t...consult the Securing DuckDB page for more details. Limitations Please consider the following limitations when running this script: This approach only works if the table does not have long pipe │ characters. It also trims spaces from the table cell valu...es. Make sure to factor in these assumptions when running the script. The script is compatible with both BSD sed (which is the default on macOS) and GNU sed (which is the default on Linux and... - https://man.mtool.work/duckdb/2.0/guides/snippets/importing_duckbox_tables.html
- DuckDB Installation 8344
- Search Shortcut cmd + k | ctrl + k DuckDB Installation Client Command line Python Go Java Node.js C / C++ R Rust ODBC Wasm More Platform Linux macOS Windows Installation 2.0.0 (LTS) 1.5.6 1.4.5 (LTS) Alternative download methods Client docu
...094c4b776348fe Docker Image docker run --rm -it -v " $( pwd ) :/workspace" -w /workspace duckdb /duckdb:2.0.0 Installation Script Run the following command from the Run menu (Win+R) or the Command Prompt: powershell -NoExit -ExecutionPolicy Bypass -Com...7f17d17773a3a3 Docker Image docker run --rm -it -v " $( pwd ) :/workspace" -w /workspace duckdb /duckdb:1.5.6 Installation Script Run the following command from the Run menu (Win+R) or the Command Prompt: powershell -NoExit -ExecutionPolicy Bypass -Com...0c7a32e2bfc298 Docker Image docker run --rm -it -v " $( pwd ) :/workspace" -w /workspace duckdb /duckdb:1.4.5 Installation Script Run the following command from the Run menu (Win+R) or the Command Prompt: powershell -NoExit -ExecutionPolicy Bypass -Com... - https://man.mtool.work/duckdb/2.0/installation.html
- DuckDB Installation 8344
- Search Shortcut cmd + k | ctrl + k DuckDB Installation Client Command line Python Go Java Node.js C / C++ R Rust ODBC Wasm More Platform Linux macOS Windows Installation 2.0.0 (LTS) 1.5.6 1.4.5 (LTS) Alternative download methods Client docu
...094c4b776348fe Docker Image docker run --rm -it -v " $( pwd ) :/workspace" -w /workspace duckdb /duckdb:2.0.0 Installation Script Run the following command from the Run menu (Win+R) or the Command Prompt: powershell -NoExit -ExecutionPolicy Bypass -Com...7f17d17773a3a3 Docker Image docker run --rm -it -v " $( pwd ) :/workspace" -w /workspace duckdb /duckdb:1.5.6 Installation Script Run the following command from the Run menu (Win+R) or the Command Prompt: powershell -NoExit -ExecutionPolicy Bypass -Com...0c7a32e2bfc298 Docker Image docker run --rm -it -v " $( pwd ) :/workspace" -w /workspace duckdb /duckdb:1.4.5 Installation Script Run the following command from the Run menu (Win+R) or the Command Prompt: powershell -NoExit -ExecutionPolicy Bypass -Com... - https://man.mtool.work/duckdb/2.0/installation/
- installation_content.html 8344
- DuckDB Installation Client Command line Python Go Java Node.js C / C++ R Rust ODBC Wasm More Platform Linux macOS Windows Installation 2.0.0 (LTS) 1.5.6 1.4.5 (LTS) Alternative download methods Client documentation page curl https://install
...094c4b776348fe Docker Image docker run --rm -it -v " $( pwd ) :/workspace" -w /workspace duckdb /duckdb:2.0.0 Installation Script Run the following command from the Run menu (Win+R) or the Command Prompt: powershell -NoExit -ExecutionPolicy Bypass -Com...7f17d17773a3a3 Docker Image docker run --rm -it -v " $( pwd ) :/workspace" -w /workspace duckdb /duckdb:1.5.6 Installation Script Run the following command from the Run menu (Win+R) or the Command Prompt: powershell -NoExit -ExecutionPolicy Bypass -Com...0c7a32e2bfc298 Docker Image docker run --rm -it -v " $( pwd ) :/workspace" -w /workspace duckdb /duckdb:1.4.5 Installation Script Run the following command from the Run menu (Win+R) or the Command Prompt: powershell -NoExit -ExecutionPolicy Bypass -Com... - https://man.mtool.work/duckdb/2.0/installation_content.html
- Profiling 8110
- 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
...ing RESET , followed by the setting name. For more information, see the “Profiling” section of the pragmas page. Setting Description Default Options enable_profiling , enable_profile Turn on profiling query_tree query_tree , json , query_tree_optimizer...to/output.json', coverage := 'select', metrics := ['query.sql', 'query.total_time', 'operator.timing'] ); Parameter Type Description metrics LIST , STRUCT , or JSON Specifies which metrics to enable mode VARCHAR Deprecated, has no effect (detailed prof...ust be output in the json format and stored in a file. After writing a profiling output to its designated file, the Python script can render it as a query graph. The script requires the duckdb Python module to be installed. It generates an HTML file an... - https://man.mtool.work/duckdb/2.0/dev/profiling.html
DuckDB 2.0 Documentation / man.mtool.work