[In preview] Load a subset of data - currently you can either point to a source file or a source folder
This feedback item is currently in preview here:
https://docs.microsoft.com/sql/t-sql/statements/copy-into-transact-sql?view=azure-sqldw-latest
A few ways this can be done: defining a regular expression or wild card support

2 comments
-
Anonymous commented
Any progress on this question?
-
Ali Nabbi commented
Let's say we have following files in Azure blob storage with same file format but different number/type of data in their columns:
fileA_1.csv
fileA_2.csv
fileB_1.csv
fileB_2.csvIf PolyBase supports defining data source to blob storage with defined file title format (for instance: WHERE file.name = 'fileA_*.csv'), we will be able to transfer various files from same location to desired external tables.