Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Issue with Dataiku Visual Recipe Failing to Save Data to SQL Database
Added on March 19, 2025 6:42AM
Likes: 0
Replies: 7
KYOUNGJIN
Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 5 ✭✭✭
Hello,
I am currently using an Other SQL Database connection in Dataiku and utilizing Visual Recipes to save data to a table.
In some cases, such as when uploading files or handling simple datasets, the table is successfully created and saved. However, there are instances where the process fails.
I would like to understand the reasons behind these failures. I have also attached the error messages that appear when the process does not work.
Could you please provide insight into why this might be happening? Any guidance would be greatly appreciated.
Thank you.
Operating system used: Linux
Answers
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,334 NeuronWhat is exactly your database technology and version?
-
KYOUNGJIN Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 5 ✭✭✭
Hi Turribeach,
I'm using SingleStoreDB (version 8.5.22), which needs to be configured using the "Other SQL Database" option under Dataiku's SQL Database connections.
Thank you!
-
로그 보시면 dataiku 에서 드랍하려고 하는데
드랍이 실패합니다.
해당 db 커넥션에 설정한 계정의 권한을 확인해주세요
-
KYOUNGJIN Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 5 ✭✭✭
Hi Yonghyun,
Thank you for reviewing the logs and looking into this issue.
I'd like to briefly explain the accounts I'm currently using for Dataiku and the DB connection:
- The Dataiku user account I'm using is a Designer account with administrator privileges.
- For the DB connection, I'm using the root account.
Additionally, since both the successful and failed flows in the previously uploaded images are using the same DB connection, I assumed the issue wasn't related to account permissions.
Is there perhaps any permission or setting that I might have overlooked?
Thank you!
-
해당 작업은 전부다 sync를 하는 작업업으로 보여집니다.
신규 dataset에 대해 sync를 한번 진행 했을 경우 만들어지는지한번 sync가 완료된 후 다시 해당 sync레시피를 동작했을때 에러가 나는 것인지 궁금합니다.
-
KYOUNGJIN Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 5 ✭✭✭
This error occurs only during the initial run on a dataset.
In other successful cases, re-running the flow works without issues.
I've also tested other visual recipes, but the same error still occurs.
For your reference, I've attached an image showing this issue.
-
에러화면을 보고싶습니다
job 에서 에러난모든 화면을 캡쳐 할수 있을까요?
예시)
