Prepare data for modeling with a saved query state
Create a reusable workspace state from a SQL transformation that joins or prepares catalog datasets for modeling.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
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 preparation steps can be hard to reproduce when query logic stays in one-off notes and manual runs.
- Capture a supplied transformation query as a workspace state.
- Support joins and preparation before modeling.
- Keep the resulting workspace reference easy to find.
Setup
Build it in a few focused steps.
- 1Connect AnyDB and DataRobot once in the Notis portal, and confirm the referenced datasets are available in DataRobot.
- 2Create an automation in Automations, New Automation, and name the data preparation workflow.
- 3Tell Notis to execute the supplied SQL query against the DataRobot datasets and report the workspace state reference.
- 4Pick a recurring schedule and choose where run reports go.
- 5Test with one real query and confirm the workspace state is created.
Questions about this workflow
Can this query AnyDB directly?
The action executes SQL against DataRobot datasets. AnyDB data must already be available as a DataRobot dataset for this action.
Does this train a model?
No. It creates a workspace state for transforming, joining, or preparing data before modeling.
Where does the SQL come from?
The query and referenced DataRobot datasets must be supplied in the automation context. The action does not invent missing query logic.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link AnyDB to Datarobot. A trigger fires from one place; an action lands in another.
AnyDB 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.
AnyDB 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.