Does Synapse Dedicated SQL Pool support wildcards in the LOCATION of external tables?

Haoran Bai 80 Reputation points
2025-06-03T09:28:27.06+00:00

Does Synapse Dedicated SQL Pool support wildcards in the LOCATION of external tables like below:

CREATE EXTERNAL TABLE db_public.trip_data_green_csv
    (
        VendorID INT,
        lpep_pickup_datetime datetime2(7),
        lpep_dropoff_datetime datetime2(7),
        store_and_fwd_flag CHAR(1) COLLATE SQL_Latin1_General_CP1_CI_AS,
        RatecodeID INT,
        PULocationID INT,
        DOLocationID INT,
        passenger_count INT,
        trip_distance FLOAT,
        fare_amount FLOAT,
        extra FLOAT,
        mta_tax FLOAT,
        tip_amount FLOAT,
        tolls_amount FLOAT,
        ehail_fee INT,
        improvement_surcharge FLOAT,
        total_amount FLOAT,
        payment_type INT,
        trip_type INT,
        congestion_surcharge FLOAT
    )  
    WITH (
        LOCATION = 'nyc-taxi-data/raw/trip_data_green_parquet/year=2020/month=01/part-*.parquet',
        DATA_SOURCE = haobai_test_source, 
        FILE_FORMAT = ParquetFileFormat
    );
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,352 questions
0 comments No comments
{count} votes

Accepted answer
  1. Nandan Hegde 35,751 Reputation points MVP Volunteer Moderator
    2025-06-03T10:11:35.94+00:00

    Based on my understanding, unfortunately wild card paths are not supported in external table paths

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.