Results of 1 - 6 of about 6 for namespace (0.003 sec.)
- Iceberg Options 12576
- This page lists the options of the iceberg extension: the parameters accepted by the Iceberg functions , the options of the ATTACH and CREATE SECRET statements used to connect to a catalog , and the global settings. ATTACH Options To make a
...ion name; ENDPOINT is accepted as a deprecated alias (do not supply both). DEFAULT_SCHEMA VARCHAR NULL The default schema (namespace) to use for the attached catalog. ACCESS_DELEGATION_MODE VARCHAR vended_credentials Access delegation mode. Allowed values...are vended_credentials and none . SUPPORT_NESTED_NAMESPACES BOOLEAN false Set to true for catalogs that support nested namespaces. STAGE_CREATE_TABLES BOOLEAN true Controls whether...HAR, VARCHAR) NULL Extra headers (key-value) sent along with the requests to the REST Catalog. DEFAULT_TABLE_LOCATION_FROM_NAMESPACE BOOLEAN false If enabled, a CREATE TABLE without an explicit WITH ('location' = …) clause derives the table location as ⟨n... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_options.html
- Lance Extension 9870
- The lance extension adds support for reading and writing Lance tables. Lance is a modern lakehouse format optimized for ML/AI workloads, with native cloud storage support. Installing and Loading You can install the lance extension from Duck
...TO 's3://⟨bucket/path/to/out.lance⟩' (FORMAT lance, MODE 'overwrite'); Create a Lance Dataset via CREATE TABLE (Directory Namespace) When you ATTACH a directory as a Lance namespace, you can create new datasets using CREATE TABLE (schema-only) or CREATE...TABLE AS SELECT (CTAS). The dataset is written to ⟨namespace_root⟩/⟨table_name.lance⟩ . ATTACH '⟨path/to/dir⟩' AS lance_ns (TYPE lance); -- Schema-only (creates an empty dataset) CREA... - https://man.mtool.work/duckdb/2.0/core_extensions/lance.html
- Catalogs 9468
- 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
...ent worked, list 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 th...attachment worked, 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 syn...tax; CREATE 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 loc... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/catalogs.html
- Unity Catalog Extension 8243
- 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
...uckDB also needs a secret for that storage, e.g., an S3 secret or an Azure secret . Note Only Databricks reports a default namespace. When you attach a Unity Catalog OSS catalog, always set DEFAULT_SCHEMA : without it, queries against the catalog fail, ev...AR detected Schema that unqualified table names resolve to. Without it, DuckDB asks the server for the workspace's default namespace. READ_ONLY BOOLEAN false Attach the catalog in read-only mode. USE_IRC_SCAN_PLAN BOOLEAN false Plan scans on the server (D... - https://man.mtool.work/duckdb/2.0/core_extensions/unity_catalog.html
- Pragmas 7311
- The PRAGMA statement is a SQL extension adopted by DuckDB from SQLite. PRAGMA statements can be issued in a similar manner to regular SQL statements. PRAGMA commands may alter the internal state of the database engine, and can influence the
...ython: Scan All Dataframes Prior to version 1.1.0, DuckDB's replacement scan mechanism in Python scanned the global Python namespace. To revert to this old behavior, use the following setting: SET python_scan_all_frames = true; Information on DuckDB Versi... - https://man.mtool.work/duckdb/2.0/configuration/pragmas.html
- Iceberg Functions 7311
- The iceberg extension provides the following functions: Function Description iceberg_scan(source) Reads an Iceberg table from a path. iceberg_metadata(source) Returns the manifest entries of an Iceberg table. iceberg_snapshots(source) Retur
....mode'] ); Schema Properties Functions Iceberg catalogs allow arbitrary key-value properties to be attached at the schema (namespace) level. These properties are typically used to record ownership, descriptions, default storage locations, or any other met... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_functions.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work