Dataiku DSS icon

Dataiku DSS

Use the Dataiku DSS API

Actions364

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 Dataset resource and the Get Data operation, it enables streaming the content of a dataset from a specified project in Dataiku DSS.

Common scenarios where this node is beneficial include:

  • Extracting dataset contents for further processing or analysis within an n8n workflow.
  • Automating data retrieval from Dataiku DSS projects without manual intervention.
  • Integrating Dataiku datasets into broader ETL or data orchestration pipelines.

Practical example:

  • A user wants to fetch the latest data from a specific dataset in a Dataiku project and then use that data downstream in n8n for reporting or transformation.

Properties

Name Meaning
Project Key The unique identifier of the Dataiku DSS project containing the dataset.
Dataset Name The name of the dataset within the specified project to retrieve data from.
Query Parameters Optional key-value pairs to filter or modify the data retrieval request (e.g., limit, filter).

Note: The "Query Parameters" property supports many optional parameters such as limit (max number of results), filter, partition, page, etc., which can be used to customize the data retrieval.

Output

The output of the Get Data operation on the Dataset resource is JSON data representing the streamed content of the requested dataset. The structure corresponds directly to the dataset's rows and columns as returned by the Dataiku DSS API.

If the dataset contains binary data, the node would handle it accordingly, but for this operation, the primary output is JSON-formatted dataset content.

Dependencies

  • Requires an active connection to a Dataiku DSS instance.
  • Requires valid API credentials (an API key) for authentication with the Dataiku DSS API.
  • The node expects the Dataiku DSS server URL and user API key to be configured in the credentials.

Troubleshooting

  • Missing Credentials Error: If the API credentials are not set or invalid, the node will throw an error indicating missing Dataiku DSS API credentials. Ensure credentials are properly configured.
  • Required Parameter Missing: The node validates required parameters like Project Key and Dataset Name. Omitting these will cause errors. Always provide these mandatory inputs.
  • API Request Failures: Network issues, incorrect URLs, or permission problems on the Dataiku DSS side may cause API call failures. Check connectivity and permissions.
  • Parsing Errors: If the response from the API is not valid JSON or unexpected, parsing might fail. This could indicate API changes or unexpected data formats.

Links and References


This summary focuses on the Dataset resource's Get Data operation, describing its purpose, input properties, output format, dependencies, and common troubleshooting tips based on static code analysis of the provided source.

Discussion