Actually U-SQL gives you the ability to map files to a virtual table (aka view :)). CREATE VIEW V AS EXTRACT <insert schema here> FROM "/a/b/{*}.csv" USING Ext

Actually U-SQL gives you the ability to map files to a virtual table (aka view :)). CREATE VIEW V AS EXTRACT <insert schema here> FROM "/a/b/{*}.csv" USING Extractors.Csv(); If the data is more complex, you can write your own Extractors that for example handle the divergence in columns. Although we are planning on some features here in the future.