---
title: "Discussion on \"Why MongoDB BI Connector (mongosqld) Gets Stuck on Schema Generation — And How to Fix It\" | Hashnode"
description: "Discussion on \"Why MongoDB BI Connector (mongosqld) Gets Stuck on Schema Generation — And How to Fix It\". TL;DR: If mongosqld hangs on schema sampling with large collections, the root cause is usually $sample triggering disk I/O due to oversized indexes not fitting in RAM. The fix is generating a static .drdl schema file and pointing mongosqld to it."
url: "https://hashnode.com/posts/why-mongodb-bi-connector-mongosqld-gets-stuck-on-schema-generation-and-how-to-fix-it/6a1427e27d85e6a1afc30354"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Why MongoDB BI Connector (mongosqld) Gets Stuck on Schema Generation — And How to Fix It](https://configcraft.hashnode.dev/why-mongodb-bi-connector-mongosqld-gets-stuck-on-schema-generation-and-how-to-fix-it?utm_source=hashnode&utm_medium=feed)

TL;DR: If mongosqld hangs on schema sampling with large collections, the root cause is usually $sample triggering disk I/O due to oversized indexes not fitting in RAM. The fix is generating a static .drdl schema file and pointing mongosqld to it.

May 25 · 5 min read · configcraft.hashnode.dev  
Read the article

-   [#mongodb](https://hashnode.com/tag/mongodb)
-   [#powerbi](https://hashnode.com/tag/powerbi)
-   [#mongosqld](https://hashnode.com/tag/mongosqld)
-   [#issues](https://hashnode.com/tag/issues)

## Written by

[Sushant Pupneja](https://hashnode.com/@sushantpupneja)

@sushantpupneja · Doha, Qatar

  
[View profile](https://hashnode.com/@sushantpupneja)

Passionate about simplifying complex machine learning and AI concepts to make them accessible and actionable for all learners.

## Responses

Markdown supported · ⌘↵ to post

No responses yet.