Results of 1 - 4 of about 4 for az (0.001 sec.)
- Azure Extension 12445
- 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
...ory. If you would like to install and load it manually, run: INSTALL AND LOAD azure; Usage Queries need a secret ; for a public container, a secret with the storage account name is enough (see the CONFIG...provider ). Then 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 supported: SELECT * FROM 'az://⟨my_container⟩/⟨path⟩/*.csv'; SELECT * FROM 'az://⟨my_container⟩/⟨path⟩/**'; Or with a fully qualified path syntax: SELE... - https://man.mtool.work/duckdb/2.0/core_extensions/azure.html
- Delta Extension 8284
- The delta extension adds support for the Delta Lake open-source storage format . It is built using the Delta Kernel . The extension reads Delta tables, local and remote, and writes them: it can create tables and append to them. For implemen
...secret: CREATE SECRET ( TYPE s3, REGION '⟨my_region⟩' ); SELECT * FROM delta_scan('s3://⟨my_bucket⟩/⟨path⟩'); Reading from Azure Blob Storage To scan a Delta table in an Azure Blob Storage container , run: SELECT * FROM delta_scan('az://⟨my_contain...er⟩/⟨path⟩'); To authenticate, create a secret : CREATE SECRET ( TYPE azure, PROVIDER credential_chain, ACCOUNT_NAME '⟨storage_account_name⟩' ); SELECT * FROM delta_scan('az://⟨my_container⟩/⟨pat...lude different ones by default. If more than one source is available, e.g., a service principal in the environment and the Azure CLI, credential loading may be inconsistent. Configure exactly one credential type in the chain of your secret. Since v... - https://man.mtool.work/duckdb/2.0/core_extensions/delta.html
- Unit Tester Configuration 8118
- There are three ways of setting options for the unit tester: Command Line Arguments Configuration File Environment Variables Configuration Options List See the Configuration Options List for the full list of available options. Command Line
...a-dir <path> Root dir for test data; default WORKING_DIR/data. Relative values resolve per test cwd; absolute/remote (e.g. az://... ) values are used verbatim. --database-destroy <on|off|on-success> Default on-success: keep on failure --description... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/test_configuration.html
- Collations 8118
- Collations provide rules for how text should be sorted or compared in the execution engine. Collations are useful for localization, as the rules for how text should be ordered are different for different languages or for different countries
...the pragma_collations function. PRAGMA collations; SELECT list(collname) FROM pragma_collations(); [af, am, ar, ar_sa, as, az, be, bg, bn, bo, br, bs, ca, ceb, chr, cs, cy, da, de, de_at, dsb, dz, ee, el, en, en_us, eo, es, et, fa, fa_af, ff, fi, f... - https://man.mtool.work/duckdb/2.0/sql/expressions/collations.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work