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

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?

Zoho Desk Resources

Desk Community Learning Series
Digest
Functions
Meetups
Kbase
Resources
Glossary
Desk Marketplace
MVP Corner
Word of the Day

Topic Participants
Cameron Mitchell
Sreekrishna S

Sticky Posts
Announcement: Migrate your workspaces to Zoho DataPrep 2.0
Zoho DataPrep 2.0 was recently launched with exciting new updates to the platform. You can read more about the new updates in the previous announcement. To take full advantage of the new data pipeline features, migrate your existing workspaces from the
Announcing Zoho DataPrep 2.0: An AI-Powered Data Management Platform
Originally launched in 2021, Zoho DataPrep started as an efficient self-service data preparation solution. We are excited to launch our new version 2.0, with significant enhancements to our platform to help you manage your end-to-end data needs with the
Announcing DataPrep 2.0 Beta!
Being data-driven is an important end goal for all organizations, because when businesses can manage, analyze, and make actionable decisions based on data, they have a competitive advantage. With that said, how confident are you in making business decisions
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