Results of 1 - 10 of about 28 for pass (0.003 sec.)
- GDAL Integration – DuckDB 13322
- 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 for the export. Use ST_Drivers() to list the names of all available drivers. LAYER_CREATION_OPTIONS : list of options to pass to the GDAL driver. See the GDAL docs for the driver you are using for a list of available options. SRS : Set a spatial re...for the export. This can be a WKT string, an EPSG code or a proj-string, basically anything you would normally be able to pass to GDAL. Note that this will not perform any reprojection of the input geometry, it just sets the metadata if the target d...ailable drivers driver extension geospatial vector system based export options list library read copy also through GeoJSON pass metadata Note supported Documentation 関連するページ Spatial Extension ODBC API Overview Extensions LOAD / INSTALL Stateme... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/gdal.html
- Iceberg REST Catalogs – DuckDB 12568
- 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
...in credentials for the OAuth2 service. CREATE SECRET iceberg_secret ( TYPE ICEBERG , CLIENT_ID ' admin ' , CLIENT_SECRET ' password ' , OAUTH2_SERVER_URI ' http://irc_host_url.com/v1/oauth/tokens ' ); If you already have a Bearer token, you can pass...g with the following ATTACH statement. ATTACH ' warehouse ' AS iceberg_catalog ( TYPE iceberg , SECRET iceberg_secret , -- pass a specific secret name to prevent ambiguity ENDPOINT https://rest_endpoint.com ); To see the available tables run SHOW ALL...torage layer OAUTH2_SERVER_URI VARCHAR NULL OAuth2 server url for getting a Bearer Token AUTHORIZATION_TYPE VARCHAR OAUTH2 Pass SigV4 for Catalogs the require SigV4 authorization The following options can only be passed to a CREATE SECRET statement,... - https://man.mtool.work/duckdb/1.3/core_extensions/iceberg/iceberg_rest_catalogs....
- Avro Extension – DuckDB 12191
- 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
...o ( 's3:// your-bucket / some_file .avro' ); should "just" work. You can also glob multiple files in a single read call or pass a list of files to the functions: FROM read_avro ( 'some_file_*.avro' ); FROM read_avro ([ 'some_file_1.avro' , 'some_file..._2.avro' ]); If the filenames somehow contain valuable information (as is unfortunately all-too-common), you can pass the filename argument to read_avro : FROM read_avro ( 'some_file_*.avro' , filename = true ); This will result in an addit...on files support union single also schema record currently There example filename contains level reading Apache table work pass list 関連するページ Union Functions Cloudflare R2 Import CSV Import Tips CREATE TYPE Statement Reading and Writing Parquet... - https://man.mtool.work/duckdb/1.3/core_extensions/avro.html
- Azure Extension – DuckDB 8832
- 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
...onfiguring a Proxy To configure proxy information when using secrets, you can add HTTP_PROXY , PROXY_USER_NAME , and PROXY_PASSWORD in the secret definition. For example: CREATE SECRET secret5 ( TYPE azure , CONNECTION_STRING ' value ' , HTTP_PROXY '...http://localhost:3128' , PROXY_USER_NAME 'john' , PROXY_PASSWORD 'doe' ); When using secrets, the HTTP_PROXY environment variable will still be honored except if you provide an explic...account_name Azure account name, when set, the extension will attempt to automatically detect credentials (not used if you pass the connection string). STRING - azure_endpoint Override the Azure endpoint for when the Azure credential providers are us... - https://man.mtool.work/duckdb/1.3/core_extensions/azure.html
- Utility Functions – DuckDB 8455
- 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
...schema() Return the name of the currently active schema. Default is main. current_schemas(boolean) Return list of schemas. Pass a parameter of true to include implicit schemas. current_setting('setting_name') Return the current value of the configura...schema. Default is main. Example current_schema() Result main current_schemas(boolean) Description Return list of schemas. Pass a parameter of true to include implicit schemas. Example current_schemas(true) Result ['temp', 'main', 'pg_catalog'] curre... - https://man.mtool.work/duckdb/1.3/sql/functions/utility.html
- COPY Statement – DuckDB 8455
- 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
...n. The WITH specifier is optional, but if any options are specified, the parentheses are required. Parameter values can be passed in with or without wrapping in single quotes. Any option that is a Boolean can be enabled or disabled in multiple ways....ON , or 1 to enable the option, and false , OFF , or 0 to disable it. The BOOLEAN value can also be omitted, e.g., by only passing (HEADER) , in which case true is assumed. With few exceptions, the below options are applicable to all formats written...d 22 (highest compression, slowest). Only supported for zstd compression. BIGINT 3 FIELD_IDS The field_id for each column. Pass auto to attempt to infer automatically. STRUCT (empty) ROW_GROUP_SIZE_BYTES The target size of each row group. You can pas... - https://man.mtool.work/duckdb/1.3/sql/statements/copy.html
- Delta Extension – DuckDB 8078
- 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
...ial_chain ); SELECT * FROM delta_scan ( 's3://some/delta/table/with/auth' ); To scan public buckets on S3, you may need to pass the correct region by creating a secret containing the region of your public S3 bucket: CREATE SECRET ( TYPE s3 , REGION '... - https://man.mtool.work/duckdb/1.3/core_extensions/delta.html
- Importing Data – DuckDB 8078
- 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
...ethods. The simplest is to use the CSV file's name: SELECT * FROM 'test.csv' ; Alternatively, use the read_csv function to pass along options: SELECT * FROM read_csv ( 'test.csv' , header = false ); Or use the COPY statement : COPY tbl FROM 'test.csv... - https://man.mtool.work/duckdb/1.3/data/overview.html
- Extension Distribution – DuckDB 8078
- 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
...ird-parties you will need to enable the allow_unsigned_extensions flag. To load unsigned extensions using the CLI client , pass the -unsigned flag to it on startup: duckdb -unsigned Now any extension can be loaded, signed or not: LOAD './some/local/e... - https://man.mtool.work/duckdb/1.3/extensions/extension_distribution.html
- Boolean Type – DuckDB 8078
- 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
...a SQL statement to filter out tuples from the result. In this case, tuples for which the predicate evaluates to true will pass the filter, and tuples for which the predicate evaluates to false or NULL will be filtered out. Consider the following exa... - https://man.mtool.work/duckdb/1.3/sql/data_types/boolean.html
DuckDB 1.3 Documentation / man.mtool.work