File Pattern Matching in DataPrep Amazon S3

File Pattern Matching in DataPrep Amazon S3

I'm trying to automate the refresh of a simple CSV file in a folder in a bucket on S3. .
I'm using the advanced selection because 


I have 2 different files I need to import:
Stores_20240208.csv
People_20240208.csv

I can connect to the bucket Using the Bucket name - e.g. my-bucket
I can connect to the specific folder using the folder name WITH a hanging slash - e.g. my-folder/

In the "File pattern" field, according to the example (e.g. Filename_*.zip), I should be able to enter either of the following:

Stores_*.csv
or
People_*.csv

and with "Fetch new files based on modified time", I should be able to retrieve the most recent file. I do not. I get no file.

I get an error:
No file found for the given regex pattern. Please check whether the pattern specified is correct.

I'm following the instructions given. Why is my pattern incorrect?

HOWEVER

I can retrieve a non-specific file when I use the file pattern ".*" - > .*


Regardless of whether I've selected "Fetch new files based on modified time", it will always return the oldest file in the folder.

What am I doing wrong? 


    • Sticky Posts

    • Zoho CRM connector's export functionality enables end-to-end CRM data pipeline

      We're thrilled to announce an update to our Zoho CRM connector that will enable you to create data pipelines to Zoho CRM. The public beta of "export to Zoho CRM" is now available, and can be enabled for users requesting it via email. Using the feature,
    • Zoho DataPrep is now launched!

      We are excited to announce the launch of Zoho DataPrep – An advanced self-service data preparation and data pipeline service.  Introducing Zoho DataPrep Zoho DataPrep helps organizations prepare data by automatically identifying errors, discovering data