Results of 1 - 10 of about 20 for visible (0.002 sec.)
- Transaction Management 14070
- DuckDB supports ACID database transactions . Transactions provide isolation, i.e., changes made by a transaction are not visible from concurrent transactions until it is committed. A transaction can also be aborted, which discards any chang
...ansaction To start a transaction, run: BEGIN TRANSACTION; Committing a Transaction You can commit a transaction to make it visible to other transactions and to write it to persistent storage (if using DuckDB in persistent mode). To commit a transaction,... - https://man.mtool.work/duckdb/2.0/sql/statements/transactions.html
- ALTER VIEW Statement 12065
- The ALTER VIEW statement changes the schema of an existing view in the catalog. Examples Rename a view: ALTER VIEW view1 RENAME TO view2; ALTER VIEW changes the schema of an existing view. All the changes made by ALTER VIEW fully respect th
...e transactional semantics, i.e., they will not be visible to other transactions until committed, and can be fully reverted through a rollback. Note that other views that rely on th... - https://man.mtool.work/duckdb/2.0/sql/statements/alter_view.html
- Security 9278
- This page covers Quack's security posture end to end: what the server exposes, what stays local, the role of a TLS-terminating reverse proxy, and the authentication / authorization callbacks the server runs on every connection and every que
...to the connection that created them. Quack invokes each callback on a fresh server-side connection, so Python UDFs are not visible at dispatch time and cannot be used as authentication or authorization callbacks. Register the function via a DuckDB exten...sion to make it globally visible. Example: Read-Only Queriers A self-contained example: a server that requires per-user tokens and limits each user to read... - https://man.mtool.work/duckdb/2.0/quack/security.html
- ODBC API on Linux 8887
- 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
...ctory to setup the ODBC init files. batch ./unixodbc_setup.sh -u The -s option changes the system level files that will be visible for all users, because of that it requires root privileges. batch sudo ./unixodbc_setup.sh -s The option --help shows the... - https://man.mtool.work/duckdb/2.0/clients/odbc/linux.html
- DuckDB_% Metadata Functions 8887
- DuckDB offers a collection of table functions that provide metadata about the current database. These functions reside in the main schema and their names are prefixed with duckdb_ . The resultset returned by a duckdb_ table function may be
...alue pairs. MAP(VARCHAR, VARCHAR) temporary Whether this sequence is temporary. Temporary sequences are transient and only visible within the current connection. BOOLEAN start_value The initial value of the sequence. This value will be returned when nex...is a user-defined table. BOOLEAN temporary Whether this is a temporary table. Temporary tables are not persisted and only visible within the current connection. BOOLEAN has_primary_key true if this table object defines a PRIMARY KEY . BOOLEAN estimated...s a user-defined view. BOOLEAN temporary true if this is a temporary view. Temporary views are not persistent and are only visible within the current connection. BOOLEAN column_count The number of columns defined by this view object. BIGINT sql The defi... - https://man.mtool.work/duckdb/2.0/sql/meta/duckdb_table_functions.html
- Deploy as Native Image 8496
- Overview The JDBC driver runs inside GraalVM Native Image executables. Graal Native Image compiles a Java application ahead of time into a standalone binary that starts in milliseconds and requires no JVM on the target machine, which suits
...e first connection: Class.forName("org.duckdb.DuckDBDriver"); Driver auto-registration through ServiceLoader is not always visible to Graal Native Image's closed world analysis, and the explicit load makes registration deterministic. Providing the Share... - https://man.mtool.work/duckdb/2.0/clients/java/deploy_native_image.html
- ODBC API on Windows 8496
- 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
...rator tool odbcad32.exe . It also can be launched through the Windows start: Default DuckDB DSN The newly installed DSN is visible on the System DSN in the Windows ODBC Data Source Administrator tool: Changing DuckDB DSN When selecting the default DSN (... - https://man.mtool.work/duckdb/2.0/clients/odbc/windows.html
- Azure Extension 8496
- The azure extension lets DuckDB read and write files in Azure Blob Storage and Azure Data Lake Storage (ADLS) Gen2. Installing and Loading The azure extension will be transparently autoloaded on first use from the official extension reposit
...o the number of blocks after which an intermediate commit happens. Warning An intermediate commit makes an incomplete file visible to readers. A Parquet file cannot be read until its footer is written at the end, so keep the default 0 for Parquet files...ntermediate commit happens. With 0 , all blocks are committed when the file is closed. Non-zero values make partial writes visible sooner, at the cost of extra requests. This option does not change the 50,000-block limit. UBIGINT 0 azure_transport_optio... - https://man.mtool.work/duckdb/2.0/core_extensions/azure.html
- Export to Apache Arrow 8496
- All results of a query can be exported to an Apache Arrow Table using the to_arrow_table function. Alternatively, results can be returned as a RecordBatchReader using the to_arrow_reader function and results can be read one batch at a time.
...or batch in reader: print(batch.to_pydict()) {'i': [0, 1]} {'i': [2, 3]} {'i': [4]} The small batch size makes the batches visible here. Omit it to use the default size. Export from Relational API Arrow objects can also be exported from the Relational A... - https://man.mtool.work/duckdb/2.0/guides/python/export_arrow.html
- Secrets Manager 8089
- The Secrets manager provides a unified user interface for secrets across all backends that use them. Secrets can be scoped, so different storage prefixes can have different secrets, allowing for example to join data across organizations in
...ts. Connection-Scoped Secrets New As of DuckDB 2.0, a secret can be stored in connection-scoped storage so that it is only visible to queries running on the same connection. Use the IN connection clause: CREATE SECRET my_secret IN connection ( TYPE s3,... - https://man.mtool.work/duckdb/2.0/configuration/secrets_manager.html
DuckDB 2.0 Documentation / man.mtool.work