Shape deal data for analysis in a DataRobot workspace
Provide the approved SQL query and dataset context, then have Notis create a workspace state for the next analysis step.
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
Preparing joins and transformations manually can break the flow between pipeline review and model work.
- Capture a SQL transformation as a workspace state.
- Join or prepare datasets for downstream work.
- Keep the preparation request tied to its deal context.
Setup
Build it in a few focused steps.
- 1Connect Affinity and DataRobot once in the Notis portal.
- 2Create an automation and describe the workspace state to create from the supplied SQL query.
- 3Choose notis_webhook as the trigger and include a valid query and dataset references.
- 4Choose where run reports should go.
- 5Test with one reviewed query against known datasets.
Questions about this workflow
Will Notis write the SQL for me?
The request should supply the SQL query and dataset context. The action executes a SQL query against DataRobot datasets.
Does this create a new dataset?
The action captures the query definition in a workspace state. It can be used to generate datasets or feed into projects.
What should I include in the test?
Use a query reviewed for your intended datasets and include references that are valid in your DataRobot environment.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Affinity to Datarobot. A trigger fires from one place; an action lands in another.
Affinity 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.
Affinity 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.