OCDS Kingfisher Views¶
OCDS Kingfisher Views is used to create SQL tables that summarize the OCDS data in collections from OCDS Kingfisher Process.
(If you are viewing this on GitHub, open the full documentation for additional details.)
What’s a “view”?¶
“Views” in Kingfisher Views’ name and in its commands’ names refers to SQL schemas. To avoid confusion with a SQL view, we use “schemas” instead of “views” in this documentation. A SQL schema is like a set of SQL tables in a common namespace. It is not like a set of constraints, like XML schema or JSON Schema.
How it works¶
Kingfisher Views runs SQL statements to create schemas, containing tables and views, which summarize the OCDS data in specified collections from Kingfisher Process.
The schemas are created in the database used by Kingfisher Process, and the schemas’ names start with
view. (The default
public schema contains the tables created by Kingfisher Process.)
Create a schema¶
Once Kingfisher Views is installed, use the add-view command to create schemas that summarize one or more collections of your choice. (This command might take a long time to run. You might want to run it in a terminal multiplexer like
Once it’s done, you can query the tables it created.
Query its tables¶
As documented in the add-view command, the schema you created has a name starting with
view_data_the_name. To learn more about each table in the schema, refer to the Database tables reference.
To query a table in the schema you created, prefix the table name by the schema name and a period. For example:
SELECT * FROM view_data_collection_123.release_summary;
Instead of typing the schema name every time, you can set PostgreSQL’s search_path to a comma-separated list of schemas in which to search for tables. For example, if you want to query both a Kingfisher Views schema and Kingfisher Process’ tables, run this statement first:
SET search_path = view_data_collection_123, public;
You can then run statements like:
SELECT * FROM release_summary; SELECT * FROM collection;
Delete the schema¶
List all schemas¶
To get a list of schemas created by yourself or others, use the list-views command. It reports:
- The name of each schema
- The IDs of the collections that it summarizes
- The note provided by the user who created it
That’s it! Feel free to browse the documentation below.
- Get started
- Command-line tools
- Database tables reference
- Reading logs
- Sharing access