-
Pulling data to excel via dataiku API
Hi, I have an excel file that needs to be updated monthly with new data.. I'd like to know if its possible to pull data directly from dataiku dataset to an excel sheet. My goal is automating the excel data update without manually exporting the data each time from dataiku to excel. I would make this data pull scheduled…
-
Using recipes
Good day! I'm struggling with choosing the proper recipe or even the algorithm itself to solve my problem. Could you please give any advice? Look, I have a transitional dataset with names, conditions and values (on the top of the picture). It was made as a sum of values per each condition in each name from initial dataset…
-
Leading zeros truncated! Datatype changing
Hello Community, I'm facing an issue that, I've a column in a dataset for which data type is a string and the meaning type is text and when I shared this to another project data type hasn't changed but it's truncated the leading zeros! thus the meaning is returned as integer. How can I not lose leading zeros without using…
-
Troubleshooting Scenario Launch Issues with Refreshed Datasets
Hello community, I'm facing some challenges with a scenario involving 10 datasets. These datasets are refreshed every week after undergoing data cleaning and manipulations through recipes (reading, cleaning, and writing back to the same dataset). Once all the 10 datasets are refreshed, they are supposed to be joined…
-
Error loading excel, preview still works
I am receiving the following error when I look at my dataset in the flow: Failed to open Excel file, caused by: OfficeXmlFileException: The supplied data appears to be in the Office 2007+ XML. You are calling the part of POI that deals with OLE2 Office Documents. You need to call a different part of POI to process this…
-
Dataiku and Intel Core i7 Laptop: Optimal Performance and User Experiences
Hello Data Science Enthusiasts, As a data science enthusiast and proud owner of an Intel Core i7 laptop, I recently came across Dataiku.com, a powerful platform designed to facilitate data science and machine learning projects. I'm excited about exploring its features and functionalities, but I wanted to reach out to the…
-
Error: Unable to Connect to SAP BW Data Source in SAP Analytics Cloud
Hello I'm currently facing an issue while attempting to connect to our SAP BW data source within SAP Analytics Cloud. Despite following the usual steps for establishing the connection, I keep encountering an error message that reads: "Connection Failed: Unable to establish a connection to the SAP BW system. Please verify…
-
Handling Concurrent Access (read & write) Standalone Dataset for Parallel Scenarios
Hello everyone, I have a situation where I've created a standalone dataset to track the status of multiple scenarios. Each scenario reads the dataset, updates its corresponding row with the status 'Completed' and the 'Run date.' The challenge arises when these scenarios run in parallel and attempt to access the dataset…
-
Deleting Partitions w API
Im partitioning a table by date and using it as an archive. Ive written code to extract a list of partitions to remove (because they are old), but cant find the method that can take this list and remove the partitions from the existing table. Here are the current partitions in the data (each partition is like 22M rows and…
-
Unable to create DSS users using shell script
Hello All, I have tried creating DSS users by using python script but unable to do it. It throws below error. #!/bin/bash DATAIKU_URL="DataIKU URL" DATAIKU_API_KEY="XXX_API_KEY" ENDPOINT="/users" PAYLOAD='{ "id": "hamett0", "displayName": "Harish Kumar Mettu", "password": null, "sourceType": "LDAP", "groups":…