# Dremio, minio, sql server

**URL:** <https://community.dremio.com/t/dremio-minio-sql-server/9008>\
**Category:** Uncategorized\
**Created:** [April 5, 2022, 1:35am UTC](https://community.dremio.com/t/dremio-minio-sql-server/9008 "2022-04-05T01:35:21Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![tk.l](https://avatars.discourse-cdn.com/v4/letter/t/71e660/32.png) [@tk.l](https://community.dremio.com/u/tk.l)\
**Post date:** [April 5, 2022, 1:35am UTC](https://community.dremio.com/t/dremio-minio-sql-server/9008/1 "2022-04-05T01:35:21Z")

</div>

Hi, i tried to setup minio as data lake, and imported data from my sql server into minio using method from here [How to Build a Modern Data Lake with MinIO | by Tejas Marvadi | CodeX | Medium](https://medium.com/codex/how-to-build-a-modern-data-lake-with-minio-db0455eec053).

I managed to connect to minio in dremio using method suggested from here [Amazon S3 - Dremio](https://docs.dremio.com/software/data-sources/s3/#configuring-s3-for-minio)  
but i cannot query the data.

Failed at the step to setup dataset. “format unknown”.

May i know how to solve this problem? Or minio is not the data lake to use?

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [April 6, 2022, 11:11pm UTC](https://community.dremio.com/t/dremio-minio-sql-server/9008/2 "2022-04-06T23:11:05Z")

</div>

@tk.l Your error seems to say “format nknown”, what is the format of the files? Is it JSON or PARQUET etc?