Precog (formerly SlamData) recently joined the Alteryx Technology Partner Program and we are excited to share the benefits that this partnership stands to provide you, our partners in the “thrill of solving.” To deliver this information, we’ve asked Jeff Carr, CEO and Co-Founder of Precog, to pen a guest blogpost on our newly formed partnership. Please see below.
Precog + Alteryx…in Jeff’s Words
Precog + Alteryx is a solution that:
- simplifies and speeds up workflows that deal with large, complex and nested data
- prevents data silos
- automatically keeps workflows up to date with the latest data
- empowers Alteryx Designer users to easily fulfil their own data requests from APIs, S3, Azure Blob Storage, Data lakes, Operational databases, MongoDB and more
- connects with your workflows via a simple tool available on the Alteryx Gallery
Precog empowers Alteryx Designer users to build workflows that work with large, complex and nested data (such as JSON) within minutes. Modern data sources like Web APIs, IoT, Marketing, NoSQL and SaaS, provide large amounts of JSON data. Precog allows data requests from these sources to be fulfilled quickly in a self-service manner. Simply connect to a data source, explore the data, and pick the exact data you need. Precog automatically transforms the selected data into the table you want and makes it available in Alteryx Designer at hyper-speed. The latest data direct from your data source is just a workflow run away. This makes it easy to keep your workflows up-to-date.
Precog is simple to learn and use and there are no limits on data size or complexity. Precog works well with JSON objects, line delimited JSON, JSON arrays and CSV, and moreover, it makes it easy to work with directories of millions of such files at once. Users can easily curate the exact tables they need and incorporate these into existing Alteryx Designer workflows to cleanse, blend and augment with other data. For example, you can rapidly clean and join data from API endpoints, MongoDB collections and relational databases.
Precog can crunch massively complex data sets in record time and improve the performance of Designer by 50X or more in many cases.
Get started!
Start with your free version Precog Explorer and then upgrade to Precog Desktop or the scalable Precog Pro which connect to Alteryx Designer directly, providing access to live data from the sources listed above. Precog Pro and Precog Desktop connect to Alteryx Designer via the Precog macro which is available in the Alteryx Gallery and at https://precog.com/alteryx. Precog Pro is scalable, allowing your team to work with terabytes of data at once.
Once installed, the following is an example of how to use Precog with Alteryx Designer:
Adding your data source
Browsing your data and picking what you’re interested in
Clicking “Results”
In the “Reusable access link” section clicking “Generate link” then clicking “Copy link”
Clicking “In/Out” from the tool palette and dragging “REFORM” onto your workflow
Pasting the access link you copied into the “REFORM access link” field
Running your workflow
To produce the same results as above without Precog, the workflow becomes complex and takes many hours to run. With Precog Desktop, it runs in less than thirty seconds. The data used in this example is available here.
Below is an example of using the same dataset with the “Tabulate JSON” macro from the Alteryx Gallery. The workflow runs for 5 minutes before running out of memory on a machine with 32GB of RAM. Just one example of how adding Precog adds value and speed to your workflows.
Summary
Using Precog with Alteryx Designer provides access new data sources and makes it fast and easy to work with large complex data sources like API’s, JSON data stored in S3, or data from popular NoSQL databases such as MongoDB or DynamoDB. Precog provides results much faster and makes adding data and adjusting to changes simple and fast. Alteryx Designer is the most popular data prep tool available today and Precog makes it even better.
Contact us directly to learn more at contact@precog.com or request your 14 day trial license here.