Results of 1 - 10 of about 31 for views (0.002 sec.)
- CREATE VIEW Statement 13540
- The CREATE VIEW statement defines a new view in the catalog. Examples Create a simple view: CREATE VIEW view1 AS SELECT * FROM tbl; Create a view or replace it if a view with that name already exists: CREATE OR REPLACE VIEW view1 AS SELECT
...sername FROM all_users WHERE access_level = 'standard'; The SQL query behind an existing view can be read using the duckdb_views() function like this: SELECT sql FROM duckdb_views() WHERE view_name = 'view1'; Syntax CREATE VIEW defines a view of a que...VIEW defines a view that does not leak information about the underlying tables through statistics or query plans. Regular views can expose data that the view query would filter out (for example via stats() ). Secure views return NULL for those intern...name is given then the view is created in the specified schema. Otherwise, it is created in the current schema. Temporary views exist in a special schema, so a schema name cannot be given when creating a temporary view. The name of the view must be d... - https://man.mtool.work/duckdb/2.0/sql/statements/create_view.html
- DuckDB_% Metadata Functions 12294
- DuckDB offers a collection of table functions that provide metadata about the current database. These functions reside in the main schema and their names are prefixed with duckdb_ . The resultset returned by a duckdb_ table function may be
...db_% functions, there is also an identically named view available, which also resides in the main schema. Typically, these views do a SELECT on the duckdb_ table function with the same name, while filtering out those objects that are marked as interna...n your duckdb_ table function call, you might still get a result, but from the identically named view. Example: The duckdb_views() table function returns all views, including those marked internal: SELECT * FROM duckdb_views(); The duckdb_views view r...eturns views that are not marked as internal: SELECT * FROM duckdb_views; duckdb_available_metrics New The duckdb_available_metrics() f... - https://man.mtool.work/duckdb/2.0/sql/meta/duckdb_table_functions.html
- Share a DuckDB Database That Only Stores Views 11421
- A DuckDB database file does not have to contain any data: it can store only view definitions that point at remote data such as Parquet files on object storage. The resulting file is only a few hundred kilobytes, yet it behaves like a shared
...TALL httpfs SQL command. This only needs to be run once. Building the Catalog Create a persistent database file and define views that reference the remote data. Use fully qualified locations (remote URLs or absolute paths) so that the views resolve re...gardless of the client's working directory: ATTACH 'catalog.duckdb' AS catalog; USE catalog; CREATE VIEW services AS SELECT * FROM read_parquet('s3://my-bucket/rail/services/*.parquet'); CREATE VIEW stations AS SELECT * FROM rea...example an s3:// bucket or an https:// endpoint. Querying the Catalog Consumers attach the catalog read-only and query the views as if they were local tables. Each query reads the current data from the referenced remote files: ATTACH 'https://example.... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/duckdb_views_only...
- Information Schema 10062
- 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
...available in DuckDB. VARCHAR NULL sql_path Applies to a feature not available in DuckDB. VARCHAR NULL tables : Tables and Views The view that describes the catalog information for tables and views is information_schema.tables . It lists the tables pr...d. VARCHAR NULL is_insertable_into YES if the table is insertable into, NO if not (Base tables are always insertable into, views not necessarily.) VARCHAR 'YES' is_typed YES if the table is a typed table, NO if not. VARCHAR 'NO' commit_action Not yet... - https://man.mtool.work/duckdb/2.0/sql/meta/information_schema.html
- DuckDB Environment 9075
- DuckDB provides a number of functions and PRAGMA options to retrieve information on the running DuckDB instance and its environment. Version The version() function returns the version number of DuckDB. SELECT version() AS version; version v
...y_files() : the temporary files DuckDB has written to disk, to offload data from memory duckdb_types() : data types duckdb_views() : views... - https://man.mtool.work/duckdb/2.0/guides/meta/duckdb_environment.html
- DROP Statement 8703
- The DROP statement removes a catalog entry added previously with the CREATE command. Examples Delete the table with the name tbl : DROP TABLE tbl; Drop the view with the name view1 ; do not throw an error if the view does not exist: DROP VI
...MA MACRO TABLE SCHEMA MACRO SCHEMA SCHEMA SCHEMA SEQUENCE SCHEMA TABLE SCHEMA TYPE SCHEMA VIEW Limitations Dependencies on Views Currently, dependencies are not tracked for views. For example, if a view is created that references a table and the table... - https://man.mtool.work/duckdb/2.0/sql/statements/drop.html
- ALTER VIEW Statement 8331
- The ALTER VIEW statement changes the schema of an existing view in the catalog. Examples Rename a view: ALTER VIEW view1 RENAME TO view2; ALTER VIEW changes the schema of an existing view. All the changes made by ALTER VIEW fully respect th
...y will not be visible to other transactions until committed, and can be fully reverted through a rollback. Note that other views that rely on the view are not automatically updated.... - https://man.mtool.work/duckdb/2.0/sql/statements/alter_view.html
- Tableau – A Data Visualization Tool 8088
- Tableau is a popular commercial data visualization tool. In addition to a large number of built-in connectors, it also provides generic database connectivity via ODBC and JDBC connectors. Tableau has two main versions: Desktop and Online (S
...en using a DuckDB database file the datasets do not actually need to be imported into DuckDB tables; it suffices to create views of the data. For example, this will create a view of the h2oai Parquet test file in the current DuckDB code base: CREATE V...ecting directly to the JDBC driver and using the Tableau-provided PostgreSQL dialect. Create a DuckDB file containing your views and/or data. Launch Tableau. Under Connect > To a Server > More…, click on "Other Databases (JDBC)". This brings up the co... - https://man.mtool.work/duckdb/2.0/guides/data_viewers/tableau.html
- Beekeeper Studio SQL Editor 7959
- Beekeeper Studio is a free, open-source SQL editor and database manager with a modern, easy-to-use interface. It is available for Windows, macOS, and Linux, and also offers a paid Ultimate tier with cloud sync and team-sharing features. Bee
...ally, name the connection and choose a color for the connection. Click Connect . Once connected, you can browse tables and views in the left-hand sidebar. Open a new SQL tab, write a query, and run it to see the results. Now you're ready to query Duck... - https://man.mtool.work/duckdb/2.0/guides/sql_editors/beekeeper_studio.html
- Iceberg Functions 7829
- 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
...alog. iceberg_view_metadata The iceberg_view_metadata(view) function is the counterpart of iceberg_load_table_response for views: it returns the raw LoadView response of an attached Iceberg REST Catalog with the columns metadata_location , metadata (...VARIANT ), config ( MAP ) and request_url . This is useful for inspecting views, including views defined in a SQL dialect DuckDB cannot parse. SELECT * FROM iceberg_view_metadata('my_datalake.default.my... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_functions.html
DuckDB 2.0 Documentation / man.mtool.work