Forum Discussion
Notebook execution failed at Notebook service with http status code - '200'
Hi Team, the issue got solved, it was issue related to quote
Hi ramankr48 ,
We really appreciate your efforts and for letting us know the update on the issue. Please accept your reply as Solution so as to help other community members who may come across this post in the future.
Please continue using fabric community forum for your further assistance.
Thank you
I am using the notebook, where I have written the merge query
Hello ramankr48 , Can you try dropping your table and rerun the full load if possible.
Hi nilendraFabric I have tried that 2-3 times but still facing this error
, adding my code snippet here, actually yesterday I have loaded some data and today again I tried to load some data with new student_id but some of the course_id is similar , in comaprison to already available data, and any way in merge query in the condition i am using both column with and condition, so i don't think there should be any issue, it is working as unique identifierfact_student_performance_table_path = f"abfss://{workspace}@onelake.dfs.fabric.microsoft.com/LH_Gold.Lakehouse/Tables/fact_student_performance" fact_deltastudentperf = DeltaTable.forPath(spark, fact_student_performance_table_path) fact_deltastudentperf.alias("target").merge( df_fact_student_performance.alias("source"), "target.Student_ID = source.Student_ID" and "target.Course_ID = source.Course_ID" ).whenMatchedUpdate(set = { "Enrollment_Date" : "source.Enrollment_Date", "Completion_Date" : "source.Completion_Date", "Status" : "source.Status", "Final_Grade" : "source.Final_Grade", "Attendance_Rate" : "source.Attendance_Rate", "Time_Spent_on_Course_hrs" : "source.Time_Spent_on_Course_hrs", "Assignments_Completed" : "source.Assignments_Completed", "Quizzes_Completed" : "source.Quizzes_Completed", "Forum_Posts" : "source.Forum_Posts", "Messages_Sent" : "source.Messages_Sent", "Quiz_Average_Score" : "source.Quiz_Average_Score", "Assignment_Scores" : "source.Assignment_Scores", "Assignment_Average_Score" : "source.Assignment_Average_Score", "Project_Score" : "source.Project_Score", "Extra_Credit" : "source.Extra_Credit", "Overall_Performance" : "source.Overall_Performance", "Feedback_Score" : "source.Feedback_Score", "Completion_Time_Days" : "source.Completion_Time_Days", "Performance_Score" : "source.Performance_Score", "Course_Completion_Rate" : "source.Course_Completion_Rate", "Processing_Date" : "source.Processing_Date" }).whenNotMatchedInsert(values = { "Student_ID" : "source.Student_ID", "Course_ID" : "source.Course_ID", "Enrollment_Date" : "source.Enrollment_Date", "Completion_Date" : "source.Completion_Date", "Status" : "source.Status", "Final_Grade" : "source.Final_Grade", "Attendance_Rate" : "source.Attendance_Rate", "Time_Spent_on_Course_hrs" : "source.Time_Spent_on_Course_hrs", "Assignments_Completed" : "source.Assignments_Completed", "Quizzes_Completed" : "source.Quizzes_Completed", "Forum_Posts" : "source.Forum_Posts", "Messages_Sent" : "source.Messages_Sent", "Quiz_Average_Score" : "source.Quiz_Average_Score", "Assignment_Scores" : "source.Assignment_Scores", "Assignment_Average_Score" : "source.Assignment_Average_Score", "Project_Score" : "source.Project_Score", "Extra_Credit" : "source.Extra_Credit", "Overall_Performance" : "source.Overall_Performance", "Feedback_Score" : "source.Feedback_Score", "Completion_Time_Days" : "source.Completion_Time_Days", "Performance_Score" : "source.Performance_Score", "Course_Completion_Rate" : "source.Course_Completion_Rate", "Processing_Date" : "source.Processing_Date" }).execute()