How to migrate in Cairn

I created an Cairn Site and bootstrap-dashboards successfully.

In my case, I created a table student_school, have a relationship with user by school_id. I want create dataset of course_enrollments with user_school_id, how can I do that?

Without knowing student_school schema, its difficult to answer but let’s suppose we have user_id and school_id in student_school and want to create dataset by using course_enrollments and student_school, sql will look like:

SELECT ce.course_id, ce.user_id, ss.school_id as user_school_id 
from course_enrollments as ce 
JOIN student_school as ss on ss.user_id = ce.user_id

and click on Save Dataset