Prepare data for modeling from project work
Turn a project data preparation request into a DataRobot workspace state using the SQL and dataset context you provide.
Trigger
Webhook received
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Action
Create Data Engine Workspace State
Run a SQL query to create a workspace state for transforming, joining, or preparing data.
Why this helps
Data transformations can become a bottleneck when query intent and project requirements are separated.
- Capture a SQL-based transformation as a workspace state.
- Support joins and preparation against DataRobot datasets.
- Keep the request's project context with its run report.
Setup
Build it in a few focused steps.
- 1Connect Agiled and DataRobot once in the Notis portal.
- 2Create an automation in Automations, New Automation, or tell Notis the outcome in plain language.
- 3Ask Notis to execute the supplied SQL against the specified DataRobot datasets and create a workspace state.
- 4Choose the webhook trigger and where run reports should go.
- 5Test with a valid query and dataset references.
Questions about this workflow
Will Notis write the SQL for me?
The action executes a SQL query. Provide the query or explicit transformation requirements and validate the result.
What does the workspace state do?
It captures the query definition and can be used to generate datasets or feed projects.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Agiled to Datarobot. A trigger fires from one place; an action lands in another.
Agiled triggers
Datarobot actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Add Users to Group
Add one or more existing users to a user group.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Add User to Organization
Add a user to an existing organization.
Analyze Dataset Definition
Start an analysis job to retrieve a dataset’s metadata, schema and statistics.
Archive Model Package
Archive a model package that is no longer in active use.
Build Java Scoring Code Package
Start an asynchronous build of a Java JAR scoring package for a deployment.
Cancel Notebook Job
Immediately cancel a running or queued notebook job; this cannot be undone.
Cancel Project Job
Cancel a pending project job.
Check Project Status
Check a project’s status and progress.
Connect any two apps with Notis in the middle.
Agiled and Datarobot, or any other combination from 1,000+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7-day trial of any paid plan, with 20$ of usage included.
No card. Works with personal or business Datarobot.