Results of 1 - 10 of about 11 for drivers (0.003 sec.)
- GDAL Integration 13247
- 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
...e support for all of the file formats that a system-wide GDAL installation otherwise would. Refer to the section on the st_drivers table function to inspect which GDAL drivers are currently available. GDAL Based COPY Function The spatial extension does...ion and must be set to GDAL to use the GDAL based copy function. DRIVER : is the GDAL driver to use for the export. 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...s to GDAL. Note that this will not perform any reprojection of the input geometry, it just sets the metadata if the target driver supports it. Limitations Note that only vector based drivers are supported by the GDAL integration. Reading and writing ras... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/gdal.html
- Spatial Functions 9815
- Function Index Scalar Functions Function Summary DuckDB_PROJ_Compiled_Version Returns a text description of the PROJ library version that this instance of DuckDB was compiled against. DuckDB_Proj_Version Returns a text description of the PR
...ry in X and Y direction. This is a shorthand macro for calling ST_Affine. ST_Translate Table Functions Function Summary ST_Drivers Returns the list of supported GDAL drivers and file formats ST_GeneratePoints Generates a set of random points within the...GEOMETRY, dx double, dy double, dz double) GEOMETRY ST_Translate (geom GEOMETRY, dx double, dy double) Table Functions ST_Drivers Signature ST_Drivers () Description Returns the list of supported GDAL drivers and file formats Note that far from all of...these drivers have been tested properly. Some may require additional options to be passed to work as expected. If you run into any issue... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- ODBC Extension 9655
- Please note that DuckDB also offers an ODBC client , which allows you to connect to DuckDB via ODBC from other applications. The odbc_scanner extension allows connecting to other databases (using their ODBC drivers ) and run queries with th
...bc On macOS unixODBC can be installed using the Homebrew package manager : brew install unixodbc To use legacy x86_64 ODBC drivers under the Rosetta translator, the unixODBC must be installed using the x86_64 version of Homebrew: arch -x86_64 /bin/bash...SN=data_source1_name or without a configured data source in a form Driver={Driver name};parameter1=values1;... . odbc_list_drivers and odbc_list_data_sources functions can be used to find out available drivers and data sources. Example of connection str...yed. Connections and Concurrency DuckDB uses a multi-threaded execution engine to run parts of the query in parallel. ODBC drivers may or may not support using the same connection from different threads concurrently. To prevent possible concurrency prob... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/overview.html
- ODBC API Overview 9513
- Installation To use the DuckDB ODBC client, visit the ODBC installation page . The latest stable version of the DuckDB ODBC client is 2.0.0. This page describes the DuckDB ODBC driver, which lets other applications connect to DuckDB . To co
...to different flavors of Database Management Systems (DBMSs). The ODBC API consists of the Driver Manager (DM) and the ODBC drivers. The Driver Manager is part of the system library, e.g., unixODBC, which manages the communications between the user appli...cations and the ODBC drivers. Typically, applications are linked against the DM, which uses Data Source Name (DSN) to look up the correct ODBC driver.... - https://man.mtool.work/duckdb/2.0/clients/odbc/overview.html
- ODBC Configuration 9033
- This page documents the files using the ODBC configuration, odbc.ini and odbcinst.ini . These are either placed in the home directory as dotfiles ( .odbc.ini and .odbcinst.ini , respectively) or in a system directory. For platform-specific
...etails, see the pages for Linux , macOS , and Windows . odbc.ini and .odbc.ini The odbc.ini file contains the DSNs for the drivers, which can have specific knobs. An example of odbc.ini with DuckDB: [DuckDB] Driver = DuckDB Driver Database = /path/to/da...the database. odbcinst.ini and .odbcinst.ini The odbcinst.ini file contains general configurations for the ODBC installed drivers in the system. A driver section starts with the driver name between brackets, and then it follows specific configuration k... - https://man.mtool.work/duckdb/2.0/clients/odbc/configuration.html
- Tableau – A Data Visualization Tool 9033
- 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
...install a JDBC driver for Tableau to use. Both Tableau Desktop and Server need to be restarted any time you add or modify drivers. Driver Links The link here is for a recent version of the JDBC driver that is compatible with Tableau. If you wish to con...f the driver installed as there are multiple filenames in use. Download the JAR file . macOS: Copy it to ~/Library/Tableau/Drivers/ . Windows: Copy it to C:\Program Files\Tableau\Drivers . Linux: Copy it to /opt/tableau/tableau_driver/jdbc . Using the P... - https://man.mtool.work/duckdb/2.0/guides/data_viewers/tableau.html
- ODBC Extension Functions 8730
- 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) ->
...ata source description type ( VARCHAR ): data source type, USER or SYSTEM Example: FROM odbc_list_data_sources() odbc_list_drivers odbc_list_drivers() -> TABLE(description VARCHAR, attributes MAP(VARCHAR, VARCHAR)) Returns the list of ODBC drivers regis...tered in the OS. Uses driver manager call SQLDrivers . Parameters: None. Returns: A table with the following columns: description ( VARCHAR ): driver description attributes (...MAP(VARCHAR, VARCHAR) ): driver attributes as a name->value map Example: FROM odbc_list_drivers() odbc_query odbc_query(conn_handle BIGINT, query VARCHAR[, <optional named parameters>]) -> TABLE odbc_query(conn_string... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/functions.html
- ODBC API on Windows 8108
- Setup Using the DuckDB ODBC API on Windows requires the following steps: Microsoft Windows requires an ODBC Driver Manager to manage communication between applications and the ODBC drivers. The Driver Manager on Windows is provided in a DLL
...detailed below, or by connecting with SQLDriverConnect . A combination of the two is also possible. Furthermore, the ODBC driver supports all the configuration options included in DuckDB. If a configuration is set in both the connection string passed t...that has two subkeys: ODBC.INI and ODBCINST.INI . The ODBC.INI is where users usually insert DSN registry entries for the drivers. For example, the DSN registry for DuckDB would look like this: The ODBCINST.INI contains one entry for each ODBC driver a... - https://man.mtool.work/duckdb/2.0/clients/odbc/windows.html
- Client Overview 7326
- DuckDB is primarily an in-process database system, and as such, it offers client APIs (“drivers”) for several languages. Client API Maintainer Support tier Latest version C Core team 2.0.0 CLI (command line interface) Core team 2.0.0 Java (
... - https://man.mtool.work/duckdb/2.0/clients/overview.html
- ODBC API on macOS 7166
- A driver manager is required to manage communication between applications and the ODBC driver. DuckDB supports unixODBC , which is a complete ODBC driver manager for macOS and Linux. Users can install it from the command line via Homebrew :
...batch brew install unixodbc DuckDB releases ODBC drivers for macOS on Apple Silicon ( arm64 ) and Intel ( x86_64 ) CPUs. To download the driver for Apple Silicon, run: batch wget...iguration files, or by connecting with SQLDriverConnect . A combination of the two is also possible. Furthermore, the ODBC driver supports all the configuration options included in DuckDB. If a configuration is set in both the connection string passed t... - https://man.mtool.work/duckdb/2.0/clients/odbc/macos.html
DuckDB 2.0 Documentation / man.mtool.work