Prepare Modeling Data from Approved SQL
Move a documented transformation query into a reusable DataRobot workspace state.
Trigger
Webhook received
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Action
Create Data Engine Workspace State
Create a Data Engine workspace state by executing a SQL query against DataRobot datasets. Use when you need to transform, join, or prepare data before modeling. The workspace state captures the query definition and can be used to generate new datasets or feed into projects.
Why this helps
Data preparation queries get delayed when they require a manual handoff into the modeling platform.
- Reduce preparation handoffs
- Keep query intent attached to the result
- Speed up downstream modeling
Setup
Build it in a few focused steps.
- 1Connect 1Password and DataRobot once in Notis.
- 2Create an automation for approved data preparation requests.
- 3Tell Notis to create the workspace state using the supplied SQL query and dataset references.
- 4Choose notis_webhook and connect the request sender.
- 5Choose a report channel and test with one non production query.
Questions about this workflow
What must the request provide?
Include the SQL query and the DataRobot dataset references needed to execute it.
Does this create a final dataset?
It creates the workspace state; use a separate dataset action when materialization is required.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link 1password to Datarobot. A trigger fires from one place; an action lands in another.
1password triggers
Datarobot actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Add Users to Group
Tool to add one or more users to a DataRobot user group by groupId. Use when you have a valid groupId and want to add existing usernames. Limit 100 users per request.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Add User to Organization
Tool to add a user to an existing organization. Use when you have an organizationId and wish to add or create a user within it.
Analyze Dataset Definition
Tool to analyze a dataset definition by ID. Use when you need to trigger an analysis job that retrieves dataset metadata, schema, and statistics.
Archive Model Package
Tool to archive a DataRobot model package. Use when you need to archive a model package that is no longer actively used.
Build Java Scoring Code Package
Initiates an asynchronous build of a Java JAR package containing DataRobot Scoring Code for a deployment. The JAR can be executed locally for predictions or used as a library in Java applications. Use after confirming the deployment is active and supports scoring code. Poll the returned statusId or location URL to track build progress.
Cancel Notebook Job
Tool to cancel a running or pending notebook job execution. Use when you need to stop a notebook job that is currently executing or queued. The cancellation is immediate and cannot be undone.
Cancel Project Job
Tool to cancel a pending job for a project. Use when you need to stop a queued or running job after confirming its ID.
Check Project Status
Tool to check the status of a DataRobot project. Use after creating or loading a project to monitor its stage and Autopilot completion.
Connect any two apps with Notis in the middle.
1password 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.