Using SqlFile

Similarly, you can run entire SQL files via the Liquibase SqlFile command. This is useful if you want to preload some data you obtained via mysqldump or if the changes you want to make are fairly large.

We find that it looks for the file in the same directory where your changelog.groovy file exists. So by default, grails-app/conf/migrations/ . You can also alter this path so that all your sql files live inside a folder and call via path: ‘sql/books.sql’.