How can we improve Microsoft Azure Synapse Analytics?

← Azure Synapse Analytics

[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

55 votes
Sign in
(thinking…)
Sign in with: Microsoft
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Shahzad Badar shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

2 comments

Sign in
(thinking…)
Sign in with: Microsoft
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Ali Nabbi commented  ·   ·  Flag as inappropriate

    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.csv

    If 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.

Azure Synapse Analytics: Loading

Categories

Feedback and Knowledge Base

(thinking…)
Hosted by UserVoice