Additional date functions added to dwSQL: added ability to parse out dates to year (example), month, day, hour, second, quarter, decade, or century.
-
New data inspections:
We now warn when a column is a constant value.
Warning for default date values.
New geo inspections to warn on odd lat/long values and zipcode formations (4 digit zips for example).
Improved warnings for data set limits on total numbers of files
When doing SPARQL queries, IRI links are now active and point to entity browser pages.
New open source JQL command line tool: internally, data.world uses Mixpanel for web analytics and wanted to be able to query that data outside of the Mixpanel web interface. Using the Mixpanel APIs, we built a command line tool so that our team could create and execute queries directly from their computers using JQL instead. While completely separate from the data.world platform, we hope this helps others to use MixPanel more effectively and efficiently!