-
Read excel attachment file from Outlook
I am new to Dataiku. Can we read an excel sheet from outlook email. I need to access the excel report that comes in an outlook email box and load the data into a datawarehouse.
-
Change user within a Sync Recipe
I am working on a project in which I am accessing Oracle database with my read permission and generate the desired output in my DSS project. I would like to Sync my final data back to another staging table in an Oracle schema, but my user does not have the write permission to Exadata, so I would to change the credentials…
-
Dynamic Rename of Headers
Hello All, First Post here, and very new to Dataiku. I am attempting to consume data from an API call to QuickBase, and I am looking for a solution that accepts a dynamic number of columns, and that replaces any special characters IE ( | , # so that I can output a file to BigQuery without issue. The team that owns the data…
-
RAG is working, but how to directly query an FAISS knowledge bank?
Hi All, We're currently running version 12.3.2 and have had some good success setting up an LLM flow using the public preview recipes. I've got a corpus of text going through the embeddings recipe and generating an FAISS knowledge bank. I've been able to use retrieval augmented generation against the knowledge bank using a…
-
Model training failed with an error
I have 6 inputs to my model where 5 inputs are dummy encoded and 1 input is vectorized thru CountVectorization. I have selected RandomForest, LogisticRegression, SVM & Neural network in the "design" section of the lab. When I click on "Train" am getting the below error and model training fails. Error:-…
-
regression Dataiku V9/V12 _ recipe join
Hello I'm experiencing a regression on Dataiku between V9.0.1 and V12.1.0 Indeed, we were on the V9.0.1. I used a Join recipe with a Date join key named "D_ARRETE" parsed correctly on Dataiku, I applied D_ARRETE=D_ARRETE in the Join part in the recipe. This recipe join worked well and returned good results with no missing…
-
Possible to use LLM Mesh connection profiles in (python) APIs?
I'm playing around with the new LLM Mesh connection profiles functionality. A lot of LLM use cases we have require the data product to be deployed as an API, so in those cases it's not an option to use LLM recipes. It would however be really beneficial to use the LLM connection profiles in those APIs to make…
-
Change source dataset in flow project.
When migrating several projects from an Oracle datawarehouse to Postgrel, we have to import the projects from one instance to another, and therefore organize the remapping to make it as easy as possible. First we dl zipped our project from DSS Oracle compatible instance and import then on our DSS Postgrel compatible…
-
Commas in Number format combined with Rounding in the Prepare Reciepe
I have a column of USD figures and I have used the Prepare recipe to do the following 2 functions: 1. Convert Number format from Raw to English 2. Round the values to 0 decimal places The column is detected as a Double - Integer. before trying to do these 2 functions. It seems I cannot do these 2 functions together as…
-
Analysis of automatically splitted/partitioned dataset
Hello, I have a database of customers (number of transactions for each day) and I want to make an analysis of each customer independently. I want to automatically split data by customer and then make charts/statistics of each sub-data and finally have them all in the same dashboard (the charts and statistics of all…