Sprinkle provides a consolidated view of your data from multiple data sources. Using explore you can write sophisticated SQL queries on the data that you have imported from multiple data sources thereby revealing insights from your business data.
The page lists all the data exploration that have been created by you and other team members.
My Explores tab
Lists all data exploration which are owned by you.
Shared with me tab
Lists all the data exploration (identified by the owner field).
To create explore click on “New”. Name and create explore. Now you can run your queries.
The page lists the result of the latest job-run of your explore report. The explore report can be scheduled thereby relieving you for running the same report again and again. The explore report run on the latest data from various imported data sources providing you the latest insights of your data. You can use explore report for your daily, weekly or monthly reports.
Email report to your team members. Email can be scheduled daily, weekly or monthly.
This page provides the ability to modify your existing explore reports by changing the SQL query, running report again or scheduling the explore report for auto-run.
Save and Run
After you are done editing your report click this button to get the latest results. A new job is launched and results are available in the Result view below.
Schedule explore report. The explore report will run every night at scheduled time of 00:30 AM. Users with Developer role can change the default schedule.
Save your changes
This lists your databases and tables within those databases. You can select a database and table and it will lists all the columns and there type information.
Type your SQL query here. After building your query click
SAVE AND RUN to see the results. Any error in the query can be seen in the Jobs tab. With the number provided for each line, identification of error comes handy.
For every run of your query a job is launched against your cluster. A job has a state of Queued, Running, Success, Failed and Cancelled. To see the Job result, click
Show. You can also see the results of the old job run.
The results of the jobs are displayed as a data table. You can download the results in a CSV file too.