Results of 1 - 10 of about 129 for Tables (0.001 sec.)
- List Tables 11598
- The SHOW TABLES command can be used to obtain a list of all tables within the selected schema. CREATE TABLE tbl (i INTEGER); SHOW TABLES; name tbl SHOW or SHOW ALL TABLES can be used to obtain a list of all tables within all attached databa
...ses and schemas. CREATE TABLE tbl (i INTEGER); CREATE SCHEMA s1; CREATE TABLE s1.tbl (v VARCHAR); SHOW ALL TABLES; database schema name column_names column_types temporary memory main tbl [i] [INTEGER]...false memory s1 tbl [v] [VARCHAR] false SHOW TABLES FROM db can be used to list all tables in a given database or schema. ATTACH 'db.duckdb'; CREATE TABLE db.main_tbl (u VARC...HAR); CREATE SCHEMA db.s1; CREATE TABLE db.s1.schema_tbl (v VARCHAR); SHOW TABLES FROM db; name main_tbl schema_tbl Or a specific schema. SHOW TABLES FROM db.s1; name schema_tbl To view the schema of an i... - https://man.mtool.work/duckdb/2.0/guides/meta/list_tables.html
- Catalogs 11391
- 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
...the generic way of attaching an Iceberg REST Catalog. For instructions specific to a catalog implementation, see Amazon S3 Tables , AWS Glue , Cloudflare R2 Data Catalog , Apache Polaris , Lakekeeper , SeaweedFS and Google Cloud BigLake . Attaching an...berg_secret, -- pass a specific secret name to prevent ambiguity URI '⟨https://rest_endpoint.com⟩' ); To see the available tables run SHOW ALL TABLES; A REST Catalog with OAuth2 authorization can also be attached with just an ATTACH statement. For the...complete list of ATTACH and CREATE SECRET options, see the Iceberg Options page. Amazon S3 Tables The iceberg extension supports reading Iceberg tables stored in Amazon S3 Tables . You can let DuckDB detect your AWS cred... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/catalogs.html
- Iceberg Extension 10112
- 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
...alog and is read-only. Catalog-managed tables are accessed by attaching an Iceberg REST catalog. This unlocks the full feature set, including writing. This page covers...uckDB releases. To make sure that you have the latest version, update your extensions : UPDATE EXTENSIONS; Reading Iceberg Tables Individual Iceberg tables can be read directly from storage with the iceberg_scan function, without attaching to a catalog.... To test the examples, download the iceberg_data.zip file and unzip it. Querying Individual Tables Use the iceberg_scan function to read an Iceberg table from a path: SELECT count(*) FROM iceberg_scan('data/iceberg/lineit... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/overview.html
- Unity Catalog Extension 9503
- 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...mode. USE_IRC_SCAN_PLAN 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 m...rows, use INSERT INTO : INSERT INTO my_catalog.my_schema.my_table VALUES (1, 'hello'); INSERT INTO my_catalog.my_schema.my_table SELECT * FROM other_table; Data Types Unity Catalog column types map to DuckDB types as follows. Since v1.5.6, DuckDB reads... - https://man.mtool.work/duckdb/2.0/core_extensions/unity_catalog.html
- Writing to Iceberg 8796
- 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.
...ns 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: COPY FROM DATABASE duckdb_db TO iceberg_datalake...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 SC...HEMA 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 T... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/writing_to_iceberg.htm...
- Join Operations 8735
- How to Force a Join Order DuckDB has a cost-based query optimizer, which uses statistics in the base tables (stored in a DuckDB database or Parquet files) to estimate the cardinality of operations. Turn off the Join Order Optimizer To turn
...ion has been executed, turn back the optimizers with the following command: SET disabled_optimizers = ''; Create Temporary Tables To force a particular join order, you can break up the query into multiple queries, with each creating a temporary table:...TABLE t2 AS SELECT * FROM t1 ...; -- compute the final result using t2 SELECT * FROM t1 ... To clean up, drop the interim tables: DROP TABLE IF EXISTS t1; DROP TABLE IF EXISTS t2; Configuring the Join Order Optimizer DuckDB's join order optimizer comp...utes the optimal join order exactly using a dynamic programming algorithm. As the number of tables in a join grows, exact enumeration becomes expensive, so for large joins the optimizer switches to an approximate (greedy)... - https://man.mtool.work/duckdb/2.0/guides/performance/join_operations.html
- Calculating a Database Checksum 8333
- To calculate a database checksum, use a commutative operation such as bit_xor on all columns, all rows, and all tables. First, create a table macro that performs this for each table: CREATE OR REPLACE MACRO table_checksum(table_name) AS TABLE S
...t_xor(md5_number(COLUMNS(*)::VARCHAR)) FROM query_table(table_name) ) ON columns(*) ); You need to call this macro for all tables. In the CLI, you can do so by dynamically generating a SQL file: .mode list .headers off .once checksum_all_tables.sql SEL...m UHUGEINT);') UNION ALL SELECT printf('INSERT INTO table_checksums FROM table_checksum(''%s'');', table_name) FROM duckdb_tables() WHERE NOT internal; .mode duckbox Read the SQL file back and calculate the checksum for the database: .read checksum_all..._tables.sql SELECT bit_xor(checksum) AS database_checksum FROM table_checksums;... - https://man.mtool.work/duckdb/2.0/guides/snippets/database_checksum.html
- Troubleshooting Quack 8333
- DuckDB 2.0 ships a polished version of Quack (first released in DuckDB 1.5.3) with substantial performance and stability improvements. If you experience any issues with Quack, try upgrading all your DuckDB clients to the latest version of t
...single definition that cannot be bound fails the entire attachment, even when you only intend to query unrelated, ordinary tables on the server. The attachment does not silently skip the problematic table. A common cause is an Iceberg catalog attached...on the server with the default TABLE_RESOLUTION 'lazy' . Lazily resolved tables are listed with a placeholder column of type UNKNOWN , which the client receives through duckdb_tables() and cannot bind:...mean the client must install the iceberg extension. It means the server has not yet resolved the table's schema. Resolving Tables Eagerly on the Server Attach the Iceberg catalog on the server with TABLE_RESOLUTION 'eager' so that schemas are resolved... - https://man.mtool.work/duckdb/2.0/quack/troubleshooting.html
- MySQL Extension 8126
- The mysql extension allows DuckDB to directly read and write data from/to a running MySQL instance. The data can be queried directly from the underlying MySQL database. Data can be loaded from MySQL tables into DuckDB tables, or vice versa.
...contains files containing certificate revocation lists ssl_key The path name of the client private key file Reading MySQL Tables The tables in the MySQL database can be read as if they were normal DuckDB tables, but the underlying data is read directl...y from MySQL at query time. SHOW ALL TABLES; name signed_integers SELECT * FROM signed_integers; t s m i b -128 -32768 -8388608 -2147483648 -9223372036854775808 127 3...ULL NULL It might be desirable to create a copy of the MySQL databases in DuckDB to prevent the system from re-reading the tables from MySQL continuously, particularly for large tables. Data can be copied over from MySQL to DuckDB using standard SQL, f... - https://man.mtool.work/duckdb/2.0/core_extensions/mysql.html
- SQLite Extension 8029
- The SQLite extension allows DuckDB to directly read and write data from a SQLite database file. The data can be queried directly from the underlying SQLite tables. Data can be loaded from SQLite tables into DuckDB tables, or vice versa. Ins
...nd write operations. For example, to attach to the sakila.db file , run: ATTACH 'sakila.db' (TYPE sqlite); USE sakila; The tables in the file can be read as if they were normal DuckDB tables, but the underlying data is read directly from the SQLite tab...les in the file at query time. SHOW TABLES; name actor address category city country customer customer_list film film_actor film_category film_list film_text invento...ry language payment rental sales_by_film_category sales_by_store staff staff_list store You can query the tables using SQL, e.g., using the example queries from sakila-examples.sql : SELECT cat.name AS category_name, sum(ifnull(pay.amo... - https://man.mtool.work/duckdb/2.0/core_extensions/sqlite.html
DuckDB 2.0 Documentation / man.mtool.work