I have add a s3 source (let’s say mys3_db) through Dremio UI (running on docker). I can list the bucket and see all the objects inside it from UI. I can even view the data once we navigate through the folder and click on the icon files-> tabular.
Now when I open query editor and write query such as “select * from mys3_db.foldername limit 10” it gives error “mys3_db.foldername table not found”
Am I missing a step here? Like creating external tables or similar to that? I am new to dremio so if you can please help me or point me to the right documentation.
@Asharma2040 Have you promoted the folder to a PDS? Does the icon for foldername represent a folder or a purple grid?