Could use more info around this:

"CREATE EXTERNAL TABLE prices(   Id int,  product VARCHAR(64),  price int) WITH (   LOCATION = '/',   DATA_SOURCE =...

There is a step missing here.  Although you note that two batch files are created by the migrate data step, you only say to run the import batch file.  This...