I have a post up on PolyBase without local tables:
With this combination of external data source, file format, and table, we can create our next table. This is a data set which lives in Spark and contains…well, the same data. What we join together isn’t that interesting, after all.
The end result is you get your data back as though these were all local, on-prem tables.