Relevant data partners now appear at the top of some search results as featured results, making it easier to find high-quality, reliable datasets in search. Featured results are disabled for private installs.

If you’re interested in learning more about how we help teams find the right data vendors for their projects, drop us a line at concierge@data.world.

Look for this new feature in upcoming data.world releases!

Here's a sneak peek of what to expect:

You'll soon see a new banner above your search results highlighting the number of matched column results for your query. You can navigate to your column results either by clicking the banner or using the result type dropdown below the search bar.

Column search surfaces tables within datasets or projects that contain matched columns, and individual column records defined in your metadata catalog. This feature will be available for data.world enterprise and community users.

We recently added search as a feature of our public API.

These new endpoints support searching for datasets, projects, insights, queries, tables, collections, files, glossary terms, and analysis resources.

We offer two options:

• Simple Search: Simple text search with filtering support by owner and resource type
• Advanced Search: Supports complex searches including date ranges, tags, and custom resource types

We've added a full suite of metadata management endpoints to our public API!

If you need to build custom workflows, integrate with existing tool chains, or require additional flexibility in managing your catalog, head over to our API docs. We've added endpoints to manage glossary terms, analysis resources, data sources, tables, columns, and relationships.

Coming soon: Collection management APIs

Search is the primary way users look for data and analysis in data.world. Now it's even easier with simpler "status:" advanced search keyword, status tooltip hints that appear when you hover over a colored status indicator, full-text search on metadata tags, and the new Collections filter.

Here is a roundup of some of the key features we released in 2020, including search improvements, 'Collection' management UX enhancements, query log reporting, and more.

Windowed aggregations partition the results from a SQL query into groups in order to perform calculations across adjacent rows of the query result. You can read more about windowed aggregations and see examples of their usage on data.world in our SQL documentation.

Here is a list of all the new windowed functions with links to their reference pages:

• CUME_DIST
• DENSE_RANK
• FIRST_VALUE
• LAST_VALUE
• LEAD
• LAG
• NTH_VALUE
• NTILE
• PERCENT_RANK
• RANK
• ROW_NUMBER

Did you know a resource on data.world, like a table, business term, or dashboard, can belong to multiple collections?

We've now made it easy to pick which collections a resource belongs to: simply click "Edit" on the resource page, then pick & choose which collections the resource should appear in and save those changes.

For example, if you had a business term in a "Sales" collection, you can now easily add that same business term to your "Finance" and "Customer Service" collections with only a few clicks. 

Likewise, if you wanted to move a resource from one collection to another, you can click "Edit" on the resource page, select the new collection, de-select the existing collection, and save that change. 

Customers who use Open collections can create a resource in a private collection, and only when it's ready for global consumption, add it to the Open collection.

We've also recently added the ability to create collections in the UI - read more about that here.

Stay tuned for editing collections in the API, and allow collections to be edited in bulk!

Jump back to what you were working on most recently with these enhancements to our navigation and search experience. The recently viewed menu previously surfaced the datasets, projects, and profiles that you last visited. This menu now includes all of the pages where you do work in the application including queries, glossary terms, workspace tables, analysis pages, and more.

Supported pages in the recently viewed menu:

• User and organization profiles
• Datasets
• Projects
• Insights
• Dataset and project tables
• Dataset and project files
• Queries
• Glossary terms
• Analysis resources
• Metadata tables
• Collections

First of all, this update includes a couple fixes:

• Visits - New Users By Month was based off of pageviews, which can be affected by ad blockers or restrictive browser settings. It has been switched to use a more robust source of events. This may slightly increase this metric going forward.
• Visits - Unique Visitors to Date was based off of pageviews, which can be affected by ad blockers or restrictive browser settings. It has been switched to use a more robust source of events. This may slightly increase this metric going forward.

Next, we've added an additional table/report:

• Users love leveraging our built-in query workbench and federated query capabilities, however often it could be challenging for administrators to easily troubleshoot when queries go wrong or audit what queries are being executed.
• The new Events - Queries report in your ddw-metrics dataset now provides quick access to audit level details on what queries are being run, by whom, including what the query text is, for fast troubleshooting and effective auditing.
• This report is currently only available for multi-tenant enterprise customers -- it will be rolled out to single-tenant customers in the next few business days.