Dataiku DSS

Use the Dataiku DSS API

Actions364

Continuous Activity Actions
- Stop Continuous Activity
- Get Continuous Activities Status
- List Latests Continuous Activities
- Start Continuous Activity
Dataset Actions
- Get Last Metric Values
- Get Metadata
- Get Schema
- Get Single Metric History
- List Datasets
- List Partitions
- Compute Metrics
- Create Dataset
- Create Managed Dataset
- Delete Data
- Delete Dataset
- Execute Tables Import
- Get Column Lineage
- Get Data
- Get Data - Alternative Version
- Get Dataset Settings
- Get Full Info
- List Tables
- List Tables Schemas
- Prepare Tables Import
- Run Checks
- Set Metadata
- Set Schema
- Synchronize Hive Metastore
- Update Dataset Settings
- Update From Hive Metastore
API Service Actions
- Delete Package
- Download Package Archive
- Generate Package
- List API Services
- List Packages
- Publish Package
Bundles Automation-Side Actions
- Activate Bundle
- Create Project From Bundle
- Create Project From Bundle With Archive
- Import Bundle From Archive File
- List Imported Bundles
- Preload Bundle
- Upload Bundle
Bundles Design-Side Actions
- Create Bundle
- Delete Exported Bundle
- Download Bundle
- Get Bundle Details
- List Exported Bundles
- Publish Bundle
Connection Actions
- Create Connection
- Delete Connection
- Get Connection
- List Connections Names
- Update Connection
Dashboard Actions
- Create Dashboard
- Delete Dashboard
- Export Dashboard
- Get Dashboard
- List Dashboards
- Update Dashboard
Data Collection Actions
- Create Data Collection
- Create Data Collection Object
- Delete Data Collection
- Delete Dataset From Data Collection
- Get Data Collection Objects
- Get Data Collection Settings
- Update Data Collection Settings
Data Quality Actions
- Compute Rules on Specific Partition
- Create Data Quality Rules Configuration
- Delete Rule
- Get Data Quality Project Current Status
- Get Data Quality Project Timeline
- Get Data Quality Rules Configuration
- Get Dataset Current Status
- Get Dataset Current Status per Partition
- Get Last Outcome on Specific Partition
- Get Last Rule Results
- Get Rule History
- Update Rule Configuration
DSS Administration Actions
- Delete Tag
- Get Category
- Get Log
- Get Tag
- Save General Settings
- Append Entry to Audit Trail
- Create Category
- Create Tag
- Delete Category
- Save Variables
- Set Current License
- Update Category
- Update Tag
Job Actions
- Run Job
- Abort Job
- Get Job Logs
- Get Job Status
- List Latest Jobs
Library Actions
- Add Folder
- Delete File
- Download File
- List Files
- Move File or Folder
- Rename File or Folder
- Upload File
Dataset Statistic Actions
- Create Worksheet
- Delete Worksheet
- Get Worksheet
- List Worksheets
- Run Card
- Run Computation
- Update Worksheet
Discussion Actions
- Create Discussion
- Get Discussion
- List Discussions
- Reply Discussion
- Update Discussion
Flow Documentation Actions
- Download Flow Documentation
- Generate Flow Documentation From Custom Template
- Generate Flow Documentation From Default Template
- Generate Flow Documentation From File Template
Insight Actions
- Create Insight
- Delete Insight
- Get Insight
- List Insights
- Update Insight
Internal Metric Actions
- List Internal Metrics
LLM Mesh Actions
- List Available LLMs
- Perform Completions on a LLM
- Perform Embeddings on a LLM
Machine Learning - Lab Actions
- Delete Visual Analysis
- Deploy Trained Model to Flow
- Download Model Documentation of Trained Model
- Generate Model Documentation From Custom Template
- Start Training ML Task
- Update User Metadata for Trained Model
- Update Visual Analysis
- Adjust Forecasting Parameters and Algorithm
- Compute Partial Dependencies of Trained Model
- Compute Subpopulation Analysis of Trained Model
- Create ML Task
- Create Visual Analysis
- Create Visual Analysis and ML Task
- Generate Model Documentation From Default Template
- Generate Model Documentation From File Template
- Get ML Task Settings
- Get ML Task Status
- Get Model Snippet
- Get Partial Dependencies of Trained Model
- Get Scoring Jar of Trained Model
- Get Scoring PMML of Trained Model
- Get Subpopulation Analysis of Trained Model
- Get Trained Model Details
- Get Visual Analysis
- List ML Tasks of Project
- List ML Tasks of Visual Analyses
- List Visual Analyses
- Reguess ML Task
Machine Learning - Saved Model Actions
- Compute Partial Dependencies of Version
- Get Version Scoring PMML
- Get Version Snippet
- Import MLflow Version From File or Path
- List Saved Models
- List Versions
- Set Version Active
- Compute Subpopulation Analysis of Version
- Create Saved Model
- Delete Version
- Download Model Documentation of Version
- Evaluate MLflow Model Version
- Generate Model Documentation From Custom Template
- Generate Model Documentation From Default Template
- Generate Model Documentation From File Template
- Get MLflow Model Version Metadata
- Get Partial Dependencies of Version
- Get Saved Model
- Get Subpopulation Analysis of Version
- Get Version Details
- Get Version Scoring Jar
- Set Version User Meta
- Update Saved Model
Long Task Actions
- Abort Task
- Get Running Task State
- List Tasks in Progress
Machine Learning - Experiment Tracking Actions
- Clean Project
- Create Virtual Dataset
- Garbage Collect
- List Models for a Run
- Set Inference Information
Macro Actions
- Abort Macro
- Get Macro
- Get Run Macro Results
- Get Run Macro State
- List Macros
- Run Macro
Plugin Actions
- Download Plugin
- Fetch From Git Remote
- Get File Detail From Plugin
- Get Git Remote Info
- Get Plugin Settings
- Install Plugin From Git
- Install Plugin From Store
- List Files in Plugin
- List Git Branches
- List Plugin Usages
- Move File or Folder in Plugin
- Add Folder to Plugin
- Create Development Plugin
- Create Plugin Code Env
- Delete File From Plugin
- Delete Git Remote Info
- Delete Plugin
- Download File From Plugin
- Move Plugin to Dev Environment
- Pull From Git Remote
- Push to Git Remote
- Rename File or Folder in Plugin
- Reset to Local Head State
- Reset to Remote Head State
- Set Git Remote Info
- Set Plugin Settings
- Update Plugin Code Env
- Update Plugin From Git
- Update Plugin From Store
- Update Plugin From Zip Archive
- Upload File to Plugin
- Upload Plugin
Project Deployer Actions
- Get Deployment Settings
- Get Deployment Status
- Create Deployment
- Create Infra
- Create Project
- Delete Bundle
- Delete Deployment
- Delete Infra
- Delete Project
- Get Deployment
- Get Deployment Governance Status
- Get Infra
- Get Infra Settings
- Get Project
- Get Project Settings
- Save Deployment Settings
- Save Infra Settings
- Save Project Settings
- Update Deployment
- Upload Bundle
SQL Query Actions
- Start Query
- Stream Query
- Verify Query
Wiki Actions
- Update Article
- Create Article
- Get Article
- Get Wiki
- Update Wiki
Managed Folder Actions
- Create Managed Folders
- Delete File From Managed Folder
- Delete Managed Folder
- Download File From Managed Folder
- Get Managed Folder Settings
- List Files in Managed Folder
- List Managed Folder
- Update Managed Folder Settings
- Upload File in Managed Folder
Meaning Actions
- Create Meaning
- Get Meaning
- Update Meaning
Model Comparison Actions
- Create Model Comparison
- Delete Model Comparison
- Get Model Comparison
- List Model Comparisons
- Update Model Comparison
Notebook Actions
- Clear Jupyter Notebook Outputs
- Create Jupyter Notebook
- Delete Jupyter Notebook
- Get Jupyter Notebook
- List Jupyter Notebook Names
- List Jupyter Notebook Sessions
- Stop Jupyter Notebook Session
- Update Jupyter Notebook
Project Actions
- Create Project
- Delete Project
- Duplicate Project
- Export Project
- Get Project Metadata
- Get Project Permissions
- Get Project Tags
- Get Project Variables
- List Projects
- Push to Git Remote
- Update Project Metadata
- Update Project Permissions
- Update Project Tags
- Update Project Variables
Project Folder Actions
- Create Sub Project Folder
- Delete Project Folder
- Get Project Folder
- Get Project Folder Settings
- Move Project
- Move Project Folder
- Update Project Folder Settings
Recipe Actions
- Create Recipe
- Delete Recipe
- Get Recipe Metadata
- Get Recipe Settings
- List Recipes
- Set Recipe Metadata
- Update Recipe Settings
Scenario Actions
- Abort Scenario
- Create Scenario
- Delete Scenario
- Get Details for Run
- Get Last Runs
- Get Run From Trigger Run
- Get Run of a Trigger
- Get Scenario
- Get Scenario Logs
- Get Scenario Payload
- Get Scenario Status
- List Scenarios
- Run Scenario
- Update Basic Scenario Settings
- Update Scenario Payload
- Update Scenario Settings
Security Actions
- Create Code Env
- Create Group
- Create User
- Delete Code Env
- Delete Group
- Delete User
- Get Code Env
- Get Group
- Get User
- Get User Last Activity
- List Users
- Provision Users
- Resync Multiple Users
- Resync User
- Update Code Env
- Update Code Env Packages
- Update Group
- Update Jupyter Integration
- Update User
Streaming Endpoint Actions
- Create Managed Streaming Endpoint
- Create Streaming Endpoint
- Delete Streaming Endpoint
- Get Streaming Endpoint Schema
- Get Streaming Endpoint Settings
- List Streaming Endpoints
- Set Streaming Endpoint Schema
- Update Streaming Endpoint Settings
Webapp Actions
- Get Webapp
- Get Webapp Backend State
- List Webapps
- Restart Webapp Backend
- Stop Webapp Backend
- Trust Webapp
- Update Webapp
Workspace Actions
- Create Workspace
- Create Workspace Object
- Delete Workspace
- Delete Workspace Object
- Get Workspace Objects
- Get Workspace Settings
- Update Workspace Settings

Overview

This node integrates with the Dataiku DSS API, allowing users to perform a wide range of operations on various Dataiku DSS resources. Specifically for the SQL Query resource and the Start Query operation, the node starts the execution of a SQL query within Dataiku DSS.

Typical use cases include automating the execution of SQL queries in Dataiku projects, integrating query execution into data workflows, or triggering complex data transformations that rely on SQL scripts managed in Dataiku DSS.

For example, you might use this node to start a SQL query that extracts data from a database, which then feeds into subsequent processing steps in your n8n workflow.

Properties

Name	Meaning
Request Body	JSON object containing the request payload for starting the SQL query.

The Request Body property is a JSON input where you specify the details of the SQL query execution request according to the Dataiku DSS API requirements.

Output

The node outputs the response from the Dataiku DSS API after starting the SQL query. The output is provided as JSON data representing the result or status of the query start request.

If the API returns binary data (not typical for starting a query), it would be handled accordingly, but for the "Start Query" operation, the output is JSON.

Dependencies

Requires an active connection to a Dataiku DSS instance.
Requires valid API credentials (an API key) for authenticating with the Dataiku DSS API.
The node uses HTTP requests to communicate with the Dataiku DSS REST API endpoints.
No additional external services are required beyond the Dataiku DSS API.

Troubleshooting

Missing Credentials Error: If the node throws an error about missing credentials, ensure you have configured the Dataiku DSS API credentials correctly in n8n.
Required Parameters Missing: The node validates required parameters such as project key and other identifiers depending on the resource and operation. Make sure all required fields are filled.
API Errors: Errors returned by the Dataiku DSS API will be surfaced by the node. Check the error message for details and verify that the API endpoint URL and parameters are correct.
Invalid JSON in Request Body: Ensure the JSON provided in the Request Body property is well-formed and matches the expected schema for the SQL query start request.

Links and References

This summary focuses on the SQL Query resource and the Start Query operation as requested, based on static analysis of the provided source code and property definitions.

Dataiku DSSInstall