How to include nested folders in S3 advanced connector
Hello. I am trying to set up the connector that would fetch the data daily from S3 bucket. I am working on an advanced s3 connector as it seems to have a more intuitive way to grab the data.
My S3 schema looks like this: `s3://adtech-third-party-data/AmazonA9/2021/09/`
In DOMO settings credentials, I put adtech-third-party-data/
as the name of the bucket.
In the Details section for * FILE NAME I have AmazonA9/2021/09/
It worked, however, it didn't fetch all the files.
Below is the s3 bucket for folder adtech-third-party-data/AmazonA9/2021/09/
:
And this is what I have in DOMO:
It skipped a couple of days, for some reason.
What is the right * FILE NAME path I should use in order to fetch all the data?
Answers
-
Have you confirmed that the file names are included in your dataset or not? What specifically does your date field represent?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
I know this is old... However, if anyone is having this issue, you just need to select "Append" on the Scheduling section. That will pull all the files within the path/folder.
0 -
@GrantSmith I'm having a similar problem with the S3 AssumeRole Advanced connector. I'm trying to read all of the .json files within a subdirectory in an S3 bucket. I'm able to successfully connect, but I get this error when the job runs:
Domo is ready but did not find files that match '/logs/entity=BuffersAndBarriers/*'
That's the S3 path I'm trying to read inside of the bucket, and I put that value into the File Name field in the connector. Any ideas on how to get this working?
Here's a screen grab of the files in the subdirectory in question:
UPDATE: Removing the leading slash and wildcard on logs/entity=BuffersAndBarriers/ gets rid of the file not found error, but no data is loaded.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive