Results of 1 - 10 of about 10 for manage (0.002 sec.)
- ODBC API on macOS 11799
- 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 :
... - https://man.mtool.work/duckdb/2.0/clients/odbc/macos.html
- Lakehouse Formats 11799
- Lakehouse formats, often referred to as open table formats, are specifications for storing data in object storage while maintaining some guarantees such as ACID transactions or keeping snapshot history. Over time, multiple lakehouse formats
...e columns ✅ ✅ ❌ ✅ Add/drop columns ✅ ✅ ❌ ✅ Alter column type ✅ ✅ ❌ ✅ Compaction and maintenance ✅ ✅ ❌ ✅ Encryption ✅ ❌ ❌ ❌ Manage table properties ✅ ✅ ✅ ** ❌ Time travel ✅ ✅ ✅ ❌ Query table changes ✅ ❌ ❌ ❌ * Through the unity_catalog extension. ** Tabl...erformance optimizations such as complex filter pushdowns (with file-level and row-group level pruning) and improve memory management.... - https://man.mtool.work/duckdb/2.0/lakehouse_formats.html
- ODBC API on Linux 10333
- 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
...i files. These files can be placed to the user home directory /home/⟨username⟩ or in the system /etc directory. The Driver Manager prioritizes the user configuration files over the system files. For the details of the configuration parameters, see the... - https://man.mtool.work/duckdb/2.0/clients/odbc/linux.html
- ODBC API on Windows 9600
- 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
... - https://man.mtool.work/duckdb/2.0/clients/odbc/windows.html
- Securing Extensions 8849
- 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
...e allow users to report malicious extensions and show adoption statistics like GitHub stars and download count. Because we manage the repository, we can remove problematic extensions from distribution quickly. Despite this, installing and loading DuckD... - https://man.mtool.work/duckdb/2.0/operations_manual/securing_duckdb/securing_ext...
- PostgreSQL Extension and the Secret Manager 8116
- User credentials and other PostgreSQL database connection details can be stored using the DuckDB Secrets Manager . The following syntax can be used to create a secret: CREATE SECRET ( TYPE postgres, HOST '127.0.0.1', PORT 5432, DATABASE pos
...NT SECRET command . Persistent secrets can be used across sessions. Managing Multiple Secrets Named secrets can be used to manage connections to multiple PostgreSQL database instances. Secrets can be given a name upon creation. CREATE SECRET postgres_s...including your credentials, may appear in the resulting error message. For better security, store credentials using DuckDB-managed secrets. Secret Configuration Options Secrets of type postgres support a number of configuration options. The following o...ion, see details in the next section below: AWS_RDS_SECRET – the name of the secret of type rds AWS RDS IAM Authentication Managed PostgreSQL databases running on RDS/Aurora services allow to use IAM authentication . In that case the authentication tok... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/secrets.html
- MySQL Extension 7383
- 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.
...NT SECRET command . Persistent secrets can be used across sessions. Managing Multiple Secrets Named secrets can be used to manage connections to multiple MySQL database instances. Secrets can be given a name upon creation. CREATE SECRET mysql_secret_on... - https://man.mtool.work/duckdb/2.0/core_extensions/mysql.html
- ODBC Extension 7383
- 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
...is also available under the alias odbc . Installing and Loading On Linux and macOS the extension requires unixODBC driver manager to be installed. See below for installation instructions. The extension can be installed automatically, but needs to be l...lickHouse: basic types covered Spark: basic types covered Arrow Flight SQL: basic types covered Installing unixODBC Driver Manager on Linux or macOS On Linux unixODBC can be installed using the system package manager. Depending on the Linux distributio...ora: sudo dnf install unixODBC Alpine: sudo apk add unixodbc 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 us... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/overview.html
- Securing DuckDB 7383
- 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
...iguration, memory_limit and threads can still be changed, while all other settings are locked. Secrets Secrets are used to manage credentials to log into third party services like AWS or Azure. DuckDB can show a list of secrets using the duckdb_secrets..., for example via the config argument when connecting from a client. Queries can access the secrets defined in the Secrets Manager. For example, if there is a secret defined to authenticate with a user, who has write privileges to a given AWS S3 bucket... - https://man.mtool.work/duckdb/2.0/operations_manual/securing_duckdb/overview.htm...
- ODBC 101: A Duck Themed Guide to ODBC 6650
- What is ODBC? ODBC which stands for Open Database Connectivity, is a standard that allows different programs to talk to different databases including, of course, DuckDB. This makes it easier to build programs that work with many different d
...r has the following handle types. Environment | Handle name | Environment | | Type name | SQL_HANDLE_ENV | | Description | Manages the environment settings for ODBC operations, and provides a global context in which to access data. | | Use case | Initi...| Connection | | Type name | SQL_HANDLE_DBC | | Description | Represents a connection to a data source. Used to establish, manage, and terminate connections. Defines both the driver and the data source to use within the driver. | | Use case | Establish... - https://man.mtool.work/duckdb/2.0/guides/odbc/general.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work