Results of 1 - 10 of about 23 for allowed (0.005 sec.)
- Securing DuckDB – DuckDB 14444
- 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
...or write from files. Functions such as read_csv , read_parquet , read_json , etc. cannot read from an external source. The allowed_directories and allowed_paths Options You can restrict DuckDB's access to certain directories or files using the allowed_d...irectories and allowed_paths options (respectively). These options allows fine-grained access control for the file system. For example, you can s...et DuckDB to only use the /tmp directory. SET allowed_directories = [ '/tmp' ]; SET enable_external_access = false ; FROM read_csv ( 'test.csv' ); With the setting applied, Duc... - https://man.mtool.work/duckdb/1.3/operations_manual/securing_duckdb/overview.htm...
- Configuration – DuckDB 11729
- 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
...secrets BOOLEAN false allow_unsigned_extensions Allow to load extensions with invalid or missing signatures BOOLEAN false allowed_directories List of directories/prefixes that are ALWAYS allowed to be queried - even when enable_external_access is false...VARCHAR[] [] allowed_paths List of files that are ALWAYS allowed to be queried - even when enable_external_access is false VARCHAR[] [] arrow_l...ustom endpoint for extension installation on autoloading VARCHAR autoinstall_known_extensions Whether known extensions are allowed to be automatically installed when a query depends on them BOOLEAN false autoload_known_extensions Whether known extension... - https://man.mtool.work/duckdb/1.3/configuration/overview.html
- Numeric Functions – DuckDB 10774
- 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
...the modulo value. Always returns a DOUBLE value. gamma(x) Interpolation of the factorial of x - 1 . Fractional inputs are allowed. gcd(x, y) Computes the greatest common divisor of x and y . greatest_common_divisor(x, y) Computes the greatest common di...s INTEGER) Alias of roundbankers(v, s) . Round to s decimal places using the rounding half to even rule . Values s < 0 are allowed. round(v NUMERIC, s INTEGER) Round to s decimal places. Values s < 0 are allowed. setseed(x) Sets the seed to be used for...value. Example fmod(5, 2) Result 1.0 gamma(x) Description Interpolation of the factorial of x - 1 . Fractional inputs are allowed. Example gamma(5.5) Result 52.34277778455352 gcd(x, y) Description Computes the greatest common divisor of x and y . Examp... - https://man.mtool.work/duckdb/1.3/sql/functions/numeric.html
- Typecasting – DuckDB 9182
- 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
...lways be converted between types. The following matrix describes which conversions are supported. When implicit casting is allowed, it implies that explicit casting is also possible. Even though a casting operation is supported based on the source and t...type, it does not necessarily mean the cast operation will succeed at runtime. Deprecated Prior to version 0.10.0, DuckDB allowed any type to be implicitly cast to VARCHAR during function binding. Version 0.10.0 introduced a breaking change which no lo...note that this flag will be deprecated in the future. Lossy Casts Casting operations that result in loss of precision are allowed. For example, it is possible to explicitly cast a numeric type with fractional digits – such as DECIMAL , FLOAT or DOUBLE... - https://man.mtool.work/duckdb/1.3/sql/data_types/typecasting.html
- Numeric Types – DuckDB 8227
- 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
...whole numbers, that is, numbers without fractional components, of various ranges. Attempts to store values outside of the allowed range will result in an error. The types UTINYINT , USMALLINT , UINTEGER , UBIGINT and UHUGEINT store whole unsigned numbe...rs. Attempts to store negative numbers or values outside of the allowed range will result in an error. Name Aliases Min Max Size in bytes TINYINT INT1 - 2^7 2^7 - 1 1 SMALLINT INT2 , INT16 , SHO... - https://man.mtool.work/duckdb/1.3/sql/data_types/numeric.html
- Azure Extension – DuckDB 8060
- 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
...L azure ; LOAD azure ; Usage Once the authentication is set up, you can query Azure storage as follows: Azure Blob Storage Allowed URI schemes: az or azure SELECT count ( * ) FROM 'az:// my_container / path / my_file . parquet_or_csv ' ; Globs are also...LECT * FROM 'az:// my_storage_account .blob.core.windows.net/ my_container / path /*.csv' ; Azure Data Lake Storage (ADLS) Allowed URI schemes: abfss SELECT count ( * ) FROM 'abfss:// my_filesystem / path / my_file . parquet_or_csv ' ; Globs are also su... - https://man.mtool.work/duckdb/1.3/core_extensions/azure.html
- Spatial Functions – DuckDB 8060
- 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
...ntial_layer_scan BOOLEAN , layer VARCHAR , sibling_files VARCHAR [], spatial_filter WKB_BLOB , spatial_filter_box BOX_2D , allowed_drivers VARCHAR [], open_options VARCHAR []) Description Read and import a variety of geospatial file formats using the GD...name of the layer to read from the file. If NULL, the first layer is returned. Can also be a layer index (starting at 0). allowed_drivers VARCHAR[] A list of GDAL driver names that are allowed to be used to open the file. If empty, all drivers are allo... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/functions.html
- Pragmas – DuckDB 7909
- 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
...ahead log size memory_usage VARCHAR , -- memory used by the database buffer manager memory_limit VARCHAR -- maximum memory allowed for the database Storage Information To get storage information: PRAGMA storage_info ( 'table_name' ); CALL pragma_storage...; SET default_order = 'DESCENDING' ; Ordering by Non-Integer Literals By default, ordering by non-integer literals is not allowed: SELECT 42 ORDER BY 'hello world' ; -- Binder Error: ORDER BY non-integer literal has no effect. To allow this behavior, u... - https://man.mtool.work/duckdb/1.3/configuration/pragmas.html
- SQL on Pandas – DuckDB 7909
- 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
...lts = duckdb . sql ( "SELECT * FROM my_df" ). df () The seamless integration of Pandas DataFrames to DuckDB SQL queries is allowed by replacement scans , which replace instances of accessing the my_df table (which does not exist in DuckDB) with a table... - https://man.mtool.work/duckdb/1.3/guides/python/sql_on_pandas.html
- Timestamp with Time Zone Functions – DuckDB 7909
- 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
...uding the starting timestamp, but stopping before the ending timestamp), stepping by the interval. Infinite values are not allowed as table function bounds. generate_series(timestamptz, timestamptz, interval) Description Generate a table of timestamps i...ONE '2001-02-16 20:38:40-05' AT TIME ZONE 'America/Denver' AS ts ; 2001-02-16 18:38:40 Note that numeric timezones are not allowed: SELECT TIMESTAMP '2001-02-16 20:38:40-05' AT TIME ZONE '0200' AS ts ; Not implemented Error: Unknown TimeZone '0200' Infi... - https://man.mtool.work/duckdb/1.3/sql/functions/timestamptz.html
DuckDB 1.3 Documentation / man.mtool.work