Wildcard on S3 Queries

Hello i have a bucket with multiple json files like “user_001.json, user_002.json, etc” with the same fields inside like “Name” when i work on a query i point to a specific file, there’s some way to create a query which looks in all the files in the bucket?

you can try this https://www.dremio.com/tutorials/elasticsearch-sql-query-multiple-indexes/
I’m not sure if it works only for elastic or also for files.
please try

1 Like

You can create a folder in the bucket, put all files into the folder and then promote the folder. The dataset will contain all the files.
Let me know if that’s expected.

1 Like