search

teaguesterling / duckdb-dataconnector-agent

DuckDB Data Connector Agent for Hasura GQL Engine. Shamelessly inspired be https://github.com/hasura/sqlite-dataconnector-agent.
0 stars 0 forks source link

Views Cannot be Properly Loaded #1

Closed teaguesterling closed 5 months ago

teaguesterling commented 5 months ago

The SQLITE_SCHEMA table does include views, but only with their defining DDL and not the underlying schema.

It would be particularly helpful to be able be able to use views (such as those created off of external data sources) as part of the GraphQL schema. This would require either "peeking" at the data or, preferably, replacing the use of the SQLITE_SCHEMA with the information_schema tables to get the previously identified schemas of views.

teaguesterling commented 5 months ago

Using the duckdb functions and information_schema tables addresses views, but does not (yet) identify foreign keys or primary keys. There is also still work to do on DuckDB "nested" types which are somewhat hard to get details on.