Computerized tools to facilitate data project development via data access layering logic in a networked computing platform including collaborative datasets
Various embodiments relate generally to data science and data analysis, computer software and systems, network communications to interface among repositories of disparate datasets and computing machine-based entities that seek access to the datasets, and, more specifically, to a computing and data storage platform configured to provide one or more computerized tools that facilitate data projects by providing an interactive, project-centric workspace interface that may include, for example, a unified view in which to identify data sources, generate transformative datasets, and/or disseminate insights to collaborative computing devices and user accounts. For example, a method may include generating data configured to generate a data project user interface to receive a user input to implement a computerized tool to resolve a project objective including a query applied against a collaborative dataset, and forming data configured to display a user input to access hierarchical levels of data, for example, related to an insight.
1. A method comprising:
generating data configured to generate a data project user interface including user interface portions each configured to receive user input to implement functionality of a computerized tool, a first portion of the data project user interface including a project objective defining a resolution by application of one or more queries against one or more collaborative datasets;
generating data to display in a second portion of the data project user interface one or more descriptive insights at a hierarchical level of data, at least one of which is derived from executing a query against a collaborative atomized dataset comprising a triple, the triple being generated by converting ingested data into an atomized dataset comprising the triple;
generating data to display in a third portion of the data project user interface an activity feed including references to a plurality of collaborator accounts from which at least one of a query and a modified portion of the dataset collaborative atomized dataset originates; and
forming data configured to display a user input in the second portion and the third portion to access other hierarchical levels of data.
2. The method of claim 1 further comprising:
receiving data representing the user input to access the other hierarchical levels of data; and
generating data to form a workspace user interface including a first contextual user interface portion including a first subset of linked references to datasets as data sources and a second subset of linked references to data queries each including executable commands of a query language applied to the one or more collaborative datasets.
3. The method of claim 2 further comprising:
causing simultaneous display of the first subset of linked references to datasets and the second subset of linked references to data queries.
4. The method of claim 2 further comprising:
causing presentation of the first subset of linked references to datasets and the second subset of linked references to data queries in a monolithic user interface.
5. The method of claim 2 wherein generating data to form the workspace user interface further comprises:
generating data to form a workspace interface portion in which dataset-related information and query-related information may be presented responsive to selection of the first subset of linked references and the second subset of linked references, respectively.
6. The method of claim 5 further comprising:
detecting activation of a first user input to access the collaborative atomized dataset;
generating data to present the collaborative atomized dataset in a tabular format in the workspace interface portion; and
generating data to present dataset attributes in a second contextual user interface portion.
7. The method of claim 6 wherein generating dataset attributes comprises:
calculating a shape of a subset of values; and
displaying the shape of the subset of values in a graphical representation.
8. The method of claim 5 further comprising:
detecting activation of a second user input to form a query to be applied against the collaborative atomized dataset;
generating executable commands in a query language responsive to one or more user inputs associated with the second user input;
applying the executable commands to the collaborative atomized dataset; and
generating results of the query.
9. The method of claim 8 further comprising:
publishing the results as one of the descriptive insights linked to the query and the results of the query.
10. The method of claim 8 further comprising:
receiving data representing a request to access via an application programming interface (“API”) an external application to generate a descriptive insight.
11. The method of claim 8 further comprising:
receiving data representing a request to transmit the results via an API to an external application to generate a descriptive insight; and
receiving the descriptive insight from the external application.
12. The method of claim 8 further comprising:
receiving data representing a request to form a dataset based on the results; and
forming the dataset.
13. An apparatus comprising:
a memory including executable instructions; and
a processor, responsive to executing the instructions, is configured to:
generate data configured to generate a data project user interface including user interface portions each configured to receive user input to implement functionality of a computerized tool, a first portion of the data project user interface including a project objective defining a resolution by application of one or more queries against one or more collaborative datasets;
generate data to display in a second portion of the data project user interface one or more descriptive insights at a hierarchical level of data, at least one of which is derived from executing a query against a collaborative atomized dataset comprising a triple, the triple being generated by converting ingested data into an atomized dataset comprising the triple;
generate data to display in a third portion of the data project user interface an activity feed including references to a plurality of collaborator accounts from which at least one of a query and a modified portion of the dataset collaborative atomized dataset originates; and
form data configured to display a user input in the second portion and the third portion to access other hierarchical levels of data.
14. The apparatus of claim 13 wherein the processor is further configured to:
receive data representing the user input to access the other hierarchical levels of data; and
generate data to form a workspace user interface including a first contextual user interface portion including a first subset of linked references to datasets as data sources and a second subset of linked references to data queries each including executable commands of a query language applied to the one or more collaborative datasets.
15. The apparatus of claim 13 wherein the processor is further configured to:
cause simultaneous display of the first subset of linked references to datasets and the second subset of linked references to data queries.
16. The apparatus of claim 13 wherein the processor is further configured to:
cause presentation of the first subset of linked references to datasets and the second subset of linked references to data queries in a monolithic user interface.
17. The apparatus of claim 13 wherein a subset of the instructions to generate data to form the workspace user interface further causes the processor to:
generate data to form a workspace interface portion in which dataset-related information and query-related information may be presented responsive to selection of the first subset of linked references and the second subset of linked references, respectively.
18. The apparatus of claim 17 wherein the processor is further configured to:
detect activation of a first user input to access the collaborative atomized dataset;
generate data to present the collaborative atomized dataset in a tabular format in the workspace interface portion; and
generate data to present dataset attributes in a second contextual user interface portion.
19. The apparatus of claim 13 wherein the processor is further configured to:
receive data representing a request to access via an application programming interface (“API”) an external application to generate a descriptive insight.
20. The apparatus of claim 13 wherein the processor is further configured to:
publish results of a query as a descriptive insight linked to the query.