Hi,
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.
Thanks.
@Asharma2040 Have you promoted the folder to a PDS? Does the icon for foldername represent a folder or a purple grid?
https://docs.dremio.com/rest-api/catalog/post-catalog-id/
https://docs.dremio.com/data-sources/entity-promotion/
https://docs.dremio.com/data-sources/s3/
https://docs.dremio.com/sql-reference/sql-commands/datasets/#refreshing-physical-dataset-metadata