Can I use wild card(*) in middle of File Path

박상준 0 Reputation points
2024-04-12T02:54:02.6333333+00:00

Can I use wild card(*) in middle of File Path

50m ago

Can I use wild card(*) in middle of File Path when I load files ADLS to Notebook?

 

I got file path like bellow

 

Ex)

20240411/1700/aaaa/a.parquet

2040411/1730/aaaa/b.parquet

20240411/1800/aaaa/c.parquet

........

 

In this file path, Can I use bellow file path to load all 1700/aaaa and 1730/aaaa parquet files?

 

20240411/17*/aaaa/*.parquet

 

Thanks.

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,348 questions
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.
4,395 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. KarishmaTiwari-MSFT 18,527 Reputation points Microsoft Employee
    2024-04-12T07:19:07.9533333+00:00

    @박상준 Thanks for posting your query on Microsoft Q&A.
    Please share a piece of code for me to know how you are trying to access it.
    Which APIs are you using? Are you using Synapse? Please elaborate on your scenario a bit more so that I can help you better.

    https://learn.microsoft.com/en-us/answers/questions/1531221/reading-multiple-parquet-files-in-synapse-via-wild

    0 comments