Here is a roundup of some of the key features we released last month, January 2021 -- broader resource support for recently viewed resources and auto suggestions from the search bar, collection search filter/facet, collection management API, and enhanced SQL support for windowed aggregations.
We've been rolling out a series of features to make working with collections easier and more intuitive on data.world. In case you missed it, here a few recent collections related updates:
Most recently, we've released bulk editing collections, which allows you to quickly manage a large number of resources by adding and removing them from collections with just a few clicks.
Using business terms as our example, we'll start off by clicking the "triple dot" menu and selecting "Edit multiple Business terms":
Select all the resources you want to edit:
Chose "Add to existing" to add the resources to an additional collection:
Review your changes:
After confirming, you'll see a message like this:
data.world now sends 2 additional webhooks: Dataset Sync Failure and Dataset Sync Recovery Success.
When a dataset within your org fails to sync, data.world will immediately send a webhook message to the configured URL with details about the failure, including error code and error messages from the downstream source.
With those sync failure details, you could configure a ticket to be created in your ticketing system, trigger an alert for a dev-ops team, or simply just make the team aware of the issue.
Natively, data.world will format the webhook payload to post messages in Slack when it recognizes the configured webhook is Slack, which is shown in the demo video below.
syncTask.status.success is triggered only after the recovery from a failure.
Example payload, in JSON:
{
"datasetid": "sync-demo",
"event": {
"type": "SUCCESS",
"task": "state_table.csv",
"created": "2021-02-04T06:37:06.936Z"
},
"eventType": "syncTask.status.success",
"resourceUrl": "https://data.world/texas-whiskey/sync-demo/file/state_table.csv",
"resourceType": "URL",
"resourceOwner": "texas-whiskey"
} syncTask.status.failure is triggered on the first failure for that file. When it recovers, data.world will send one syncTask.status.success
Example payload, in JSON:
{
"datasetid": "sync-demo",
"event": {
"type": "FAILURE",
"task": "state_table.csv",
"created": "2021-02-04T06:35:17.945Z",
"error": "HTTP/1.1 404 Not Found"
},
"eventType": "syncTask.status.failure",
"resourceUrl": "https://data.world/texas-whiskey/sync-demo/file/state_table.csv",
"resourceType": "URL",
"resourceOwner": "texas-whiskey"
}We're proud to announce that a new relational database metadata collector is now available for enterprise customer use -- SAP SQL Anywhere (formerly known as Sybase SQL Anywhere), versions 16 & 17.
Have you ever need to create a 7-day trailing average in order to smooth out a graph? How about compare a value to the same value in the previous row?
Windowed aggregations are a powerful way to perform complex analysis, such as this, without leaving the comfort of the SQL. These functions operate on a defined group, or "window", of rows to return an aggregated value for each row. Window aggregations are supported for both uploaded tabular data, as well as live tables (where support exists in the connected database).
Note: this feature is currently in Beta. Please contact support with any issues.
Today we released a new filter group for the search page. Customers are using collections to group and organize the items within their catalog. Users can now filter their search results based on the catalog collection an item belongs to.
This feature is visible to enterprise customers.
Head over to our api documentation to learn more about the new API endpoints we've added in support of collection management.
You can now create and manage collections from the public API to help build automation pipelines and integrations around your enterprise data catalog.
Our interactive docs allow you to test requests right from the browser.
Find what you are looking for from anywhere in the application.
Look for new resource types added to the autosuggest feature of the main search bar! Queries and metadata resources, such as glossary terms and analysis records, have been added to the top level search bar. You can now search for these resources from any page with the search bar header. This feature previously supported dataset, project, and user search. This feature is live for community and enterprise users.
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:
