Not a question but an answer as I couln't find any relevant posts. I solved this problem using a SQLExecutor2 in a Python recipe: from dataiku import SQLExecutor2 executor = SQLExecutor2(connection="connection name") sql_str = """Execute sp_name 'param1','param2', 'param3'""" output_df = executor.query_to_df(sql_str,…
Hi Having connection to Oracle database I need to run Dataiku pipeline periodically assuming that during the update new data from database will be uploaded (based on query that will be simply rerun) and result send from further manipulations. I want to use build in Connection option Operating system used: Windows
Hello, We would like to implement a DSS API with a python function which reads some data files stored in a distant server (not the DSS API Node). This data file name will be an input parameter of the API. The server, where the data file is stored, is known. The data files are maintained by business users, this is why we…
Hi everyone, I'm working on a Dataiku Application Designer project where I need a dropdown to let users select between two dataset options: dataset1 and dataset2. I tried adding the following JSON in the Edit Parameters section: [ { "name": "dataset", "type": "SELECT", "mandatory": true, "canSelectForeign": false,…
Hello, I tried to use Dataiku Python API to create recipes given both .json and .shaker files. I load the .json fle and use it in recipe_proto argument of create_recipe function (https://doc.dataiku.com/dss/latest/python-api/projects.html). Similarly, I load the .shaker file and use it in creation_settings argument of…
How can I configure an output tool similar to Alteryx where my data exports as an excel file to a windows PC network drive folder location? Right now, I'm only seeing ouput to SharePoint or folders within Dataiku as options.
Hi, I am supposed to get the GDP per capita. I have a column GDP and a column population. How I can divide GDP by population ?
Right now I use Reporter + Teams Workflows to send scenario finish reporter to teams chat. I see in scenario step, we can send message to mail including a dataset as HTML variables to email. It can also keep the color rule on the Dataiku table. I'm wondering if this is possible via Reporter? My problem is I can't send to…
Hi! I'm currently testing out the possibilities for leveraging Spark in our ETL pipelines. My usecase is that I have 90% of cases where I start with just raw text files in Azure Blob Storage (usually CSV's or TXT's). How can I plug in Spark to read and process those files? If I select the Spark engine or run a custom Spark…
I have a date column; some of the fields are empty in this column. Is there a way to "count" if there is a value in the field for that row and place into a new column? Something like below: Operating system used: Windows 11
Create an account to contribute great content, engage with others, and show your appreciation.
