-
Dataiku (Snowflake) to SQL Server Table
We processed data in a SQL Server Table in Dataiku (which uses Snowflake as the backend) and when I go to send it back to SQL Server it insists on dropping the table (bad) and recreating it. So I wrote SQL to truncate the table and reload it from the modified data in the Snowflake Dataiku table, but it keeps failing…
-
Tell us about your favorite Dataiku easter eggs!
Spring has sprung! As we continue to celebrate our #DecadeofDataiku, we thought it would be fun to take a look back at the last 10 years and appreciate all your favorite easter eggs — the small surprises and hidden gems that make our product experience unique. Have you ever discovered one of our easter eggs while working…
-
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…
