In Category on 07 Jul 2025
Join the CKAN Workshop at csv,conf,v9 – Bologna, September 9, 2025
Join the CKAN core team for a hands-on, community-powered workshop at one of the world’s most inspiring open data conferences.
GB
for Great Britain, DE
for Germany and so on). If there is another dataset also broken down by country code, we can easily combine the two and create a dataset that shows country-level patterns across the two data sources. The result will update itself automatically when one of the source resources changes.
In summary, the new DataStore helps ensure your data can be used easily in as many ways and by as many people as possible - including you.
datastore_search_sql
endpoint. This allows arbitrary SQL queries on the Datastore. Results are still returned as JSON, which you can easily use in your application. We tried to make the wrapper around the database as thin as possible; as a result, the SQL endpoint gives you full control over your query. You can filter and aggregate data from a resource, or combine it with other resources using joins, as in the example above. Joining and SQL search are the most powerful features of the Datastore for developers who want to work with the data, and we hope people will come up with many uses for them.
datastore_search
endpoint. It allows exact matching of certain fields via filters
, or searching via the query
parameter. The query
parameter allows you to use PostgreSQL's full text search, which lets you search across all fields of a resource and returns a ranking of the results. To use full PostgreSQL text search, set the plain parameter
to False
. This enables queries as described in the PostgreSQL docs. Again, we tried to make the wrapper as thin as we could to give you as much control as possible.
Interested? Check out the documentation on how to get started. And why not use the DataStore API and data from the DataHub at your next hack day? The DataHub is a public CKAN instance - create a group there for your event and upload data in advance.
As usual, please write to the dev list with any questions, and we'll be happy to help.
Join the CKAN core team for a hands-on, community-powered workshop at one of the world’s most inspiring open data conferences.
Explore how the Transport Data Commons, powered by CKAN, is transforming transport data from siloed PDFs into a global, interoperable, and reusable knowledge base—especially for low-emission mobility in the Global South.