Here is a roundup of some of the key features we released last month, December 2020 -- collection crowdsourced suggestions, new metadata and search API endpoints, and a recap on search improvements.

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

Here's a sneak peek of what to expect:

We are updating the way we present contributors and visibility for datasets and projects. Currently, we have a top level Access tab that controls individual access, and a Visibility section in the Settings tab that controls whether the dataset/project is open, private, or discoverable to the community. To minimize confusion and complexity, we are combining and redesigning these settings into a single pane of glass to simplify understanding and control of “who can see this resource."

This is how the experience will look from a data consumer's perspective:

This is now the experience will look from an admin's perspective:

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

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

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

For customers leveraging data artifact lineage, it was a little counterintuitive that the high-level business lineage diagram would show up below your dataset relationships but above all your other relationships. So, we've moved it to just above the Technical details section.

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.