Results of 1 - 6 of about 6 for scenarios (0.001 sec.)
- ALTER DATABASE Statement 12174
- Warning The ALTER DATABASE statement is not supported in DuckDB 2.0.0: ALTER DATABASE ⟨old_name⟩ RENAME TO ⟨new_name⟩ fails with Parser Error: syntax error at or near "RENAME" . To rename an attached database, DETACH it and ATTACH it again
...with a different alias. Syntax RENAME DATABASE The following scenarios are not supported when renaming a DuckDB database with ALTER DATABASE : Renaming a database to certain reserved keywords s... - https://man.mtool.work/duckdb/2.0/sql/statements/alter_database.html
- PostgreSQL Extension and the Secret Manager 10656
- 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
...o use this provider for secrets that do not include confidential credentials (like the s3 example above). For multi-tenant scenarios it is expected that Postgres Row-Level Security policies can be used to prevent users to see secrets of other users. Diffe...g all the stored secrets available in the current session. This allows to use such persistent secrets with “direct attach” scenarios, when only a connection string is specified to the duckdb command (other DuckDB clients may require slightly different syn... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/secrets.html
- Troubleshooting of Extensions 9139
- You might be visiting this page directed via a DuckDB error message, similar to: INSTALL non_existing; HTTP Error: Failed to download extension "non_existing" at URL "http://extensions.duckdb.org/v2.0.0/osx_arm64/non_existing.duckdb_extensi
...db.org/docs/current/extensions/troubleshooting?version=v2.0.0&platform=osx_arm64&extension=non_existing There are multiple scenarios for which an extension might not be available in a given extension repository at a given time: * the extension has not bee... - https://man.mtool.work/duckdb/2.0/extensions/troubleshooting.html
- Multiple Python Threads 8627
- This page demonstrates how to simultaneously insert into and read from a DuckDB database across multiple Python threads. This could be useful in scenarios where new data is flowing in and an analysis should be periodically re-run. Note that
... - https://man.mtool.work/duckdb/2.0/guides/python/multiple_threads.html
- ODBC Extension 7110
- 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 strictly single-threaded. When submitting issues related only to performance please check the performance in comparable scenarios, for example with pyodbc .... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/overview.html
- Reading Faulty CSV Files 7110
- CSV files can come in all shapes and forms, with some presenting many errors that make the process of cleanly reading them inherently difficult. To help users read these files, DuckDB supports detailed error messages, the ability to skip fa
...rations, it is also necessary to know exactly which lines are corrupted and what errors the parser discovered on them. For scenarios like these, it is possible to use DuckDB's CSV Rejects Table feature. By default, this feature creates two temporary table... - https://man.mtool.work/duckdb/2.0/data/csv/reading_faulty_csv_files.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work