Results of 1 - 10 of about 14 for ⟩.⟨ (0.002 sec.)
- Amazon RDS with IAM Authentication 12656
- Managed PostgreSQL databases on Amazon RDS and Aurora can authenticate with short-lived IAM tokens instead of a static password. DuckDB supports this through the postgres and aws extensions: the aws extension generates the token from an AWS
...et ( TYPE rds, PROVIDER credential_chain, CHAIN 'env;sso', REGION '⟨eu-west-1⟩', RDS_USER '⟨postgres⟩', RDS_HOST '⟨instance⟩.⟨identifier⟩.⟨region⟩.rds.amazonaws.com', RDS_PORT '5432' ); Then create a secret of type postgres that references it via AW...rated by the rds secret is used (and refreshed) automatically: CREATE SECRET pg_rds_secret ( TYPE postgres, HOST '⟨instance⟩.⟨identifier⟩.⟨region⟩.rds.amazonaws.com', PORT '5432', USER '⟨postgres⟩', DATABASE '⟨postgres⟩', SSLMODE require, AWS_RDS_SE... - https://man.mtool.work/duckdb/2.0/guides/database_integration/rds_iam.html
- Keywords and Identifiers 12516
- Identifiers Similarly to other SQL dialects and programming languages, identifiers in DuckDB's SQL are subject to several rules. Unquoted identifiers need to conform to a number of rules: They must not be a reserved keyword (see duckdb_keyw
...fier Resolution Identifiers can be qualified to remove ambiguity. A fully qualified column reference has the form ⟨database⟩.⟨schema⟩.⟨table⟩.⟨column⟩ , and any leading part can be omitted when the remaining name is unambiguous. Table names can like...wise be qualified as ⟨database⟩.⟨schema⟩.⟨table⟩ . When a name is not fully qualified, DuckDB resolves it using the catalog search path. The search path is...controlled by the schema and search_path configuration options : schema sets a single default ⟨catalog⟩.⟨schema⟩ entry, while search_path sets a comma-separated list of such entries that are searched in order. Both options write... - https://man.mtool.work/duckdb/2.0/sql/dialect/keywords_and_identifiers.html
- Unity Catalog Extension 9365
- The unity_catalog extension attaches a Unity Catalog catalog, on Databricks or Unity Catalog OSS, as a DuckDB database. You can list, read, insert into and create its Delta Lake tables. It uses the delta extension to access the tables. For
...BOOLEAN false Plan scans on the server (Databricks only); see Server-Side Scan Planning . Reading Tables are named ⟨catalog⟩.⟨schema⟩.⟨table⟩ ; names without a schema resolve to DEFAULT_SCHEMA : SHOW ALL TABLES; SELECT * FROM my_catalog.my_schema.my...ion supports: Listing available tables: SHOW ALL TABLES; Interacting with tables using standard SQL: SELECT * FROM ⟨catalog⟩.⟨schema⟩.⟨table⟩; Time travel : SELECT * FROM ... AT (VERSION => ...); and SELECT * FROM ... AT (TIMESTAMP => ...); Inserts:... - https://man.mtool.work/duckdb/2.0/core_extensions/unity_catalog.html
- Azure Extension 9102
- 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
...e 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_conta...qualified path syntax: SELECT count(*) FROM 'az://⟨my_storage_account⟩.blob.core.windows.net/⟨my_container⟩/⟨path⟩/⟨my_file⟩.⟨parquet_or_csv⟩'; SELECT * FROM 'az://⟨my_storage_account⟩.blob.core.windows.net/⟨my_container⟩/⟨path⟩/*.csv'; Azure Data L...Allowed URI schemes: abfss or abfs (both connect over HTTPS) SELECT count(*) FROM 'abfss://⟨my_filesystem⟩/⟨path⟩/⟨my_file⟩.⟨parquet_or_csv⟩'; Globs are also supported: SELECT * FROM 'abfss://⟨my_filesystem⟩/⟨path⟩/*.csv'; SELECT * FROM 'abfss://⟨m... - https://man.mtool.work/duckdb/2.0/core_extensions/azure.html
- Catalogs 9102
- The iceberg extension supports attaching Iceberg REST Catalogs. Attaching a catalog is required for writing to Iceberg . Before attaching an Iceberg REST Catalog, you must install the iceberg extension by following the instructions located
...st all tables: SHOW ALL TABLES; You can query a table as follows: SELECT count(*) FROM my_s3_tables_catalog.⟨namespace_name⟩.⟨table_name⟩; AWS Glue (Amazon SageMaker Lakehouse) The iceberg extension supports reading Iceberg tables through the Amazon...rked, list all tables: SHOW ALL TABLES; You can query a table as follows: SELECT count(*) FROM glue_catalog.⟨namespace_name⟩.⟨table_name⟩; If you have an S3 Tables federated catalog, you can create a table using the standard CREATE TABLE syntax; CRE...ATE TABLE glue_catalog.⟨namespace_name⟩.⟨table_name⟩ (a INTEGER, b VARCHAR); If the catalog is not federated by S3 Tables, you may need to create pass a location ta... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/catalogs.html
- S3 Express One 9102
- In late 2023, AWS announced the S3 Express One Zone , a high-speed variant of traditional S3 buckets. DuckDB can read S3 Express One buckets using the httpfs extension . Credentials and Configuration The configuration of S3 Express One buck
...buckets with one exception: you must specify the endpoint according to the following pattern: s3express-⟨availability_zone⟩.⟨region⟩.amazonaws.com where the ⟨availability_zone⟩ (e.g., use-az5 ) can be obtained from the S3 Express One bucket's confi...OSFODNN7EXAMPLE⟩', SECRET '⟨wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY⟩', REGION '⟨us-east-1⟩', ENDPOINT 's3express-⟨use1-az5⟩.⟨us-east-1⟩.amazonaws.com' ); Instance Location For best performance, ensure the EC2 instance is in the same availability zo... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/s3_express_one.ht...
- Iceberg Extension 8314
- The iceberg extension implements support for the Apache Iceberg open table format . There are two ways to work with Iceberg in DuckDB: Individual tables are read directly from storage, by pointing at a table's metadata. This requires no cat
...atalog.example.com⟩' ); Once attached, the catalog behaves like any other DuckDB database: reference its tables as ⟨catalog⟩.⟨schema⟩.⟨table⟩ and query or modify them with regular SQL. SHOW ALL TABLES; SELECT count(*) FROM my_catalog.default.events;... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/overview.html
- AWS Extension 7929
- The aws extension adds functionality, e.g., authentication, on top of the httpfs extension's S3 capabilities , using the AWS SDK. Installing and Loading The aws extension will be transparently autoloaded on first use from the official exten
...ret ( TYPE rds, PROVIDER credential_chain, CHAIN 'env;sso', REGION '⟨eu-west-1⟩', RDS_USER '⟨db_user⟩', RDS_HOST '⟨instance⟩.⟨identifier⟩.⟨region⟩.rds.amazonaws.com', RDS_PORT '5432' ); The rds secret type is registered by the postgres extension , n... - https://man.mtool.work/duckdb/2.0/core_extensions/aws.html
- S3 API Support 7789
- The httpfs extension supports reading/writing/ globbing files on object storage servers using the S3 API. S3 offers a standard API to read and write to remote files (while regular http servers, predating S3, do not offer a common write API)
...ses/a/gcs/secret⟩.parquet'); Reading Reading files from S3 is now as simple as: SELECT * FROM 's3://⟨your-bucket⟩/⟨filename⟩.⟨extension⟩'; Partial Reading The httpfs extension supports partial reading from S3 buckets. Pinning Object Versions By defa...upload files at high speed. Writing to S3 works for both CSV and Parquet: COPY table_name TO 's3://⟨your-bucket⟩/⟨filename⟩.⟨extension⟩'; Partitioned copy to S3 also works: COPY table TO 's3://⟨your-bucket⟩/partitioned' ( FORMAT parquet, PARTITION_... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/s3api.html
- Dot Commands 7527
- Dot commands are available in the DuckDB CLI client. To use one of these commands, begin the line with a period ( . ) immediately followed by the name of the command you wish to execute. Additional arguments to the command are entered, spac
...own using the pager if it is enabled. The function name may be qualified with a schema and a database name, i.e., ⟨database⟩.⟨schema⟩.⟨function⟩ . Each part of the name is matched case-insensitively as a LIKE pattern , so wildcards can be used: .man... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
DuckDB 2.0 Documentation / man.mtool.work