Results of 1 - 10 of about 290 for table (0.002 sec.)
- Table Functions 7924
- The table function API can be used to define a table function that can then be called from within DuckDB in the FROM clause of a query. API Reference Overview duckdb_table_function duckdb_create_table_function (); void duckdb_destroy_table_
...function ( duckdb_table_function * table_function ); void duckdb_table_function_set_name ( duckdb_table_function table_function , const char * nam...e ); void duckdb_table_function_add_parameter ( duckdb_table_function table_function , duckdb_logical_type type ); void duckdb_table_function_add..._named_parameter ( duckdb_table_function table_function , const char * name , duckdb_logical_type type ); void duckdb_table_function_set_extra_info ( duck... - https://man.mtool.work/duckdb/2.0/clients/c/table_functions.html
- ALTER TABLE Statement 7819
- The ALTER TABLE statement changes the schema of an existing table in the catalog. Examples CREATE TABLE integers (i INTEGER, j INTEGER); Add a new column with name k to the table integers , it will be filled with the default value NULL : AL
...TER TABLE integers ADD COLUMN k INTEGER; Add a new column with name l to the table integers, it will be filled with the default valu...e 10: ALTER TABLE integers ADD COLUMN l INTEGER DEFAULT 10; Drop the column k from the table integers: ALTER TABLE integers DROP k; Change t...he type of the column i to the type VARCHAR using a standard cast: ALTER TABLE integers ALTER i TYPE VARCHAR; Change the type of the column i to the type VARCHAR , using the specified expression to con... - https://man.mtool.work/duckdb/2.0/sql/statements/alter_table.html
- Delta Extension 7637
- 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
...on repository. If you would like to install and load it manually, run: INSTALL AND LOAD delta; Usage To scan a local Delta table, run: SELECT * FROM delta_scan('file:///⟨path⟩'); Attaching Tables A Delta table can also be attached as a database. The d...atabase holds exactly one table, with the same name as the database, so my_table and my_table.my_table refer to the same table: ATTACH 'file:///⟨path⟩' AS...my_table (TYPE delta); SELECT * FROM my_table; Reading from an S3 Bucket To scan a Delta table in an S3 bucket , run: SELECT * FROM... - https://man.mtool.work/duckdb/2.0/core_extensions/delta.html
- Iceberg Functions 7599
- 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
...ns the snapshots of an Iceberg table. iceberg_column_stats(source) Returns per-data-file, per-column statistics of an Iceberg table. iceberg_partition_stats(so...urce) Returns per-partition-field statistics of an Iceberg table. iceberg_load_table_response(table) Returns the raw LoadTable response of the REST Catalog. iceberg_files(source) Returns...the data and delete files of an Iceberg table snapshot. iceberg_manifests(source) Returns the manifest files of an Iceberg table snapshot. iceberg_history(source) Retur... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_functions.html
- CREATE TABLE Statement 7494
- The CREATE TABLE statement creates a table in the catalog. Examples Create a table with two integer columns ( i and j ): CREATE TABLE t1 (i INTEGER, j INTEGER); Create a table with a primary key: CREATE TABLE t1 (id INTEGER PRIMARY KEY, j V
...ARCHAR); Create a table with a composite primary key: CREATE TABLE t1 (id INTEGER, j VARCHAR, PRIMARY KEY (id, j)); Create a table with various di...fferent types, constraints and default values: CREATE TABLE t1 ( i INTEGER NOT NULL DEFAULT 0, decimalnr DOUBLE CHECK (decimalnr < 10), date DATE UNIQUE, time TIMESTAMP ); Create tab...le with CREATE TABLE ... AS SELECT (CTAS): CREATE TABLE t1 AS SELECT 42 AS i, 84 AS j; Create a table from a CSV file (automatically detecting... - https://man.mtool.work/duckdb/2.0/sql/statements/create_table.html
- Unity Catalog Extension 7331
- 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
...s. For Unity Catalog OSS, see the OSS Unity Catalog documentation . AWS_REGION is the region of the storage that holds the tables. It is required. To read and write the table files, DuckDB also needs a secret for that storage, e.g., an S3 secret or an...y Catalog OSS catalog, always set DEFAULT_SCHEMA : without it, queries against the catalog fail, even with fully qualified table names. Attach Options When attaching a Unity Catalog catalog, you can pass the following options to ATTACH : Option Type D...cret to use. Without it, the unnamed unity_catalog secret is used. DEFAULT_SCHEMA VARCHAR 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... - https://man.mtool.work/duckdb/2.0/core_extensions/unity_catalog.html
- Writing to Iceberg 7188
- The DuckDB iceberg extension supports writing to Iceberg tables when an Iceberg catalog is attached. Writing to a table read directly from storage with iceberg_scan is not supported: the catalog is required to commit the new table metadata.
...iceberg extension supports the following operations when used with a REST Catalog attached: CREATE/DROP SCHEMA CREATE/DROP TABLE INSERT INTO UPDATE DELETE MERGE INTO ALTER TABLE SELECT Since these operations are supported, the following will also work...erg_datalake TO duckdb_db; This functionality enables deep copies between Iceberg and DuckDB storage. Creating Schemas and Tables Iceberg namespaces are exposed as schemas, which can be created and dropped with CREATE SCHEMA and DROP SCHEMA : CREATE S...CHEMA iceberg_catalog.sales; USE iceberg_catalog.sales; Tables are created with the standard CREATE TABLE syntax. Iceberg table properties can be supplied with the WITH clause: CREATE... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/writing_to_iceberg.htm...
- Information Schema 6901
- The views in the information_schema are SQL-standard views that describe the catalog entries of the database. These views can be filtered to obtain information about a specific column or table. DuckDB's implementation is based on PostgreSQL
...'s information schema . Tables character_sets : Character Sets Column Description Type Example character_set_catalog Currently not implemented – always...chema.columns . It lists the columns present in the database and has the following layout: Column Description Type Example table_catalog Name of the database containing the table (always the current database). VARCHAR 'my_db' table_schema Name of the...schema containing the table. VARCHAR 'main' table_name Name of the table. VARCHAR 'widgets' column_name Name of the column. VARCHAR 'price' ordinal_po... - https://man.mtool.work/duckdb/2.0/sql/meta/information_schema.html
- DuckLake 6834
- DuckLake 1.1 was released together with DuckDB 2.0. Read the announcement blog post . The ducklake extension adds support for attaching to databases stored in the DuckLake format . The complete documentation of this extension is available a
...y, run: LOAD ducklake; Usage ATTACH 'ducklake:metadata.ducklake' AS my_ducklake (DATA_PATH 'data_files'); USE my_ducklake; Tables In DuckDB, the ducklake extension stores the catalog tables for a DuckLake named my_ducklake in the __ducklake_metadata_⟨...e catalog . Parameter name Parameter type Named parameter Description catalog VARCHAR no The information is encoded into a table with the following schema: Column name Column type snapshot_id BIGINT snapshot_time TIMESTAMP WITH TIME ZONE schema_versio...n BIGINT changes MAP(VARCHAR, VARCHAR[]) author VARCHAR commit_message VARCHAR commit_extra_info VARCHAR ducklake_table_info The ducklake_table_info function returns information on the tables stored in the DuckLake catalog named catalog . Par... - https://man.mtool.work/duckdb/2.0/core_extensions/ducklake.html
- FROM and JOIN Clauses 6815
- The FROM clause specifies the source of the data on which the remainder of the query should operate. Logically, the FROM clause is where the query starts execution. The FROM clause can contain a single table, a combination of multiple table
...tional FROM -first syntax which enables you to also query without a SELECT statement. Examples Select all columns from the table called tbl : SELECT * FROM tbl; Select all columns from the table using the FROM -first syntax: FROM tbl SELECT *; Select...all columns using the FROM -first syntax and omitting the SELECT clause: FROM tbl; Select all columns from the table called tbl through an alias tn : SELECT tn.* FROM tbl tn; Use a prefix alias: SELECT tn.* FROM tn: tbl; Select all columns...from the table tbl in the schema schema_name : SELECT * FROM schema_name.tbl; Select the column i from the table function range , where t... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/from.html
DuckDB 2.0 Documentation / man.mtool.work