Results of 1 - 10 of about 98 for available (0.315 sec.)
- DuckDB_% Metadata Functions – DuckDB 12257
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...this case too, the parentheses are mandatory. For some of the duckdb_% functions, there is also an identically named view available, which also resides in the main schema. Typically, these views do a SELECT on the duckdb_ table function with the same nam...as internal: SELECT * FROM duckdb_views ; duckdb_columns The duckdb_columns() function provides metadata about the columns available in the DuckDB instance. Column Description Type database_name The name of the database that contains the column object. VA...on top of duckdb_columns() ) duckdb_constraints The duckdb_constraints() function provides metadata about the constraints available in the DuckDB instance. Column Description Type database_name The name of the database that contains the constraint. VARCH... - https://man.mtool.work/duckdb/1.3/sql/meta/duckdb_table_functions.html
- UPDATE EXTENSIONS – DuckDB 11747
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...──┼──────────────────┼─────────────────┤ │ iceberg │ core_nightly │ UPDATED │ 6386ab5 │ b3ec51a │ │ icu │ core │ NO_UPDATE_AVAILABLE │ v1.2.1 │ v1.2.1 │ │ autocomplete │ core │ NO_UPDATE_AVAILABLE │ v1.2.1 │ v1.2.1 │ │ httpfs │ core_nightly │ NO_UPDATE_AV...AILABLE │ cf3584b │ cf3584b │ │ json │ core │ NO_UPDATE_AVAILABLE │ v1.2.1 │ v1.2.1 │ │ aws │ core_nightly │ NO_UPDATE_AVAILABLE │ d3c5013 │ d3c5013 │ └────────────────┴──────────────┴────...o be updated: UPDATE EXTENSIONS ( name_a , name_b , name_c ); How It Works UPDATE EXTENSIONS is implemented by storing, if available, the ETag information, and sending a GET request conditional on the fact that the remote extension is different (using the... - https://man.mtool.work/duckdb/1.3/sql/statements/update_extensions.html
- GDAL Integration – DuckDB 10101
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ion bundles its own copy of the GDAL library. This also means that spatial's version of GDAL may not be the latest version available or provide 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 not only enable importing geospatial file formats (through the ST_Rea...ath/filename.geojson' WITH ( FORMAT gdal , DRIVER 'GeoJSON' , LAYER_CREATION_OPTIONS 'WRITE_BBOX=YES' , SRS 'EPSG:4326' ); Available options: FORMAT : is the only required option and must be set to GDAL to use the GDAL based copy function. DRIVER : is the... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/gdal.html
- Profiling – DuckDB 9983
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...as for turning profiling on and off and controlling the level of detail in the profiling output. The following pragmas are available and can be set using either PRAGMA or SET . They can also be reset using RESET , followed by the setting name. For more in...sured over the entire query. The OPERATOR nodes refer to the individual operators in the query plan. Some metrics are only available for QUERY_ROOT nodes, while others are only for OPERATOR nodes. The table below describes each metric and which nodes they...are available for. Other than QUERY_NAME and OPERATOR_TYPE , it is possible to turn all metrics on or off. Metric Return type Unit Query... - https://man.mtool.work/duckdb/1.3/dev/profiling.html
- Extensions – DuckDB 9983
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ow and DuckDB autocomplete false Adds support for autocomplete in the shell … … … This list will show which extensions are available, which extensions are installed, at which version, where it is installed, and more. The list includes most, but not all, a...atform is documented in the list of core extensions . Installing More Extensions To make an extension that is not built-in available in DuckDB, two steps need to happen: Extension installation is the process of downloading the extension binary and verifyi...instance. DuckDB will search the local extension directory for the installed extension, then load it to make its features available. This means that every time DuckDB is restarted, all extensions that are used need to be (re)loaded Extension installation... - https://man.mtool.work/duckdb/1.3/extensions/overview.html
- Versioning of Extensions – DuckDB 9343
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...uped into a release and pushed to the core repository. Release notes describing what has been added each release should be available to make it easy to understand the difference between versions. Stable Extensions Stable extensions are the final step of e...isk for a combinatorial explosion. Therefore, not all combinations of nightly extension build and nightly DuckDB build are available. In general, there are 2 ways of using nightly builds: using a nightly DuckDB build and using a stable DuckDB build. Let's...xample: UPDATE EXTENSIONS ; extension_name repository update_result previous_version current_version httpfs core NO_UPDATE_AVAILABLE 70fd6a8a24 70fd6a8a24 delta core UPDATED d9e5cc1 04c61e4 azure core_nightly NO_UPDATE_AVAILABLE 49b63dc 49b63dc aws core N... - https://man.mtool.work/duckdb/1.3/extensions/versioning_of_extensions.html
- S3 API Support – DuckDB 8964
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...tication The preferred way to configure and authenticate to S3 endpoints is to use secrets . Multiple secret providers are available. To migrate from the deprecated S3 API , use a defined secret with a profile. See the “Loading a Secret Based on a Profile...dard AWS credential locations (environment variables, credential files, etc.). Therefore, your R2 credentials must be made available as AWS environment variables ( AWS_ACCESS_KEY_ID and AWS_SECRET_ACCESS_KEY ) for the credential chain to work properly. Fi...nally, R2 secrets are only available when using URLs starting with r2:// , for example: SELECT * FROM read_parquet ( 'r2:// some-file-that-uses-an-r2-secret .p... - https://man.mtool.work/duckdb/1.3/core_extensions/httpfs/s3api.html
- CSV Import – DuckDB 8337
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...R auto dateformat Date format used when parsing and writing dates. VARCHAR (empty) date_format Alias for dateformat ; only available in the COPY statement. VARCHAR (empty) decimal_separator Decimal separator for numbers. VARCHAR . delim Delimiter characte..., ; \t . The delimiter character can be up to 4 bytes, e.g., ?. Alias for sep . VARCHAR , delimiter Alias for delim ; only available in the COPY statement. VARCHAR , escape String used to escape the quote character within quoted values. VARCHAR " encoding...Encoding used by the CSV file. Options are utf-8 , utf-16 , latin-1 . Not available in the COPY statement (which always uses utf-8 ). VARCHAR utf-8 filename Add path of the containing file to each row, as a... - https://man.mtool.work/duckdb/1.3/data/csv/overview.html
- Information Schema – DuckDB 8337
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...e of the owner of the schema. Not yet implemented. VARCHAR 'duckdb' default_character_set_catalog Applies to a feature not available in DuckDB. VARCHAR NULL default_character_set_schema Applies to a feature not available in DuckDB. VARCHAR NULL default_ch...aracter_set_name Applies to a feature not available in DuckDB. VARCHAR NULL sql_path Applies to a feature not available in DuckDB. VARCHAR NULL tables : Tables and Views The.... One of: BASE TABLE , LOCAL TEMPORARY , VIEW . VARCHAR 'BASE TABLE' self_referencing_column_name Applies to a feature not available in DuckDB. VARCHAR NULL reference_generation Applies to a feature not available in DuckDB. VARCHAR NULL user_defined_type_... - https://man.mtool.work/duckdb/1.3/sql/meta/information_schema.html
- Editing – DuckDB 8088
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...Sitemap Live Demo Documentation / Client APIs / CLI Copy Markdown Editing The linenoise-based CLI editor is currently only available for macOS and Linux. DuckDB's CLI uses a line-editing library based on linenoise , which has shortcuts that are based on E...macs mode of readline . Below is a list of available commands. Moving Key Action Left Move back a character Right Move forward a character Up Move up a line. When on the first...ronment variable among DUCKDB_EDITOR , EDITOR or VISUAL (in that order). If none are set, vi is used. This feature is only available in the linenoise-based CLI editor, which is currently supported on macOS and Linux. Using Read-Line If you prefer, you can... - https://man.mtool.work/duckdb/1.3/clients/cli/editing.html
DuckDB 1.3 Documentation / man.mtool.work