Docs/issue 1661 add tip to source docs and update weaviate docs

[dat-a-man]

Description

#1661

This PR clarifies the behavior of the max_table_nesting parameter, ensuring users understand that it doesn’t automatically apply to individual resources. It provides guidance on how to correctly apply the parameter to achieve the desired effect.

[netlify[bot]]

✅ Deploy Preview for dlt-hub-docs ready!

Name	Link
🔨 Latest commit	2c0d6b565e8b80b887d170501a566ee75f858a6b
🔍 Latest deploy log	https://app.netlify.com/sites/dlt-hub-docs/deploys/66c873ed967fc400085fb1ac
😎 Deploy Preview	https://deploy-preview-1662--dlt-hub-docs.netlify.app
📱 Preview on mobile	Toggle QR Code... Use your smartphone camera to open QR code link.

---

To edit notification comments on pull requests, go to your Netlify site configuration.

[VioletM]

Also, please add the same info about adapter for qdrant https://deploy-preview-1662--dlt-hub-docs.netlify.app/docs/dlt-ecosystem/destinations/qdrant/#qdrant_adapter and lancedb https://deploy-preview-1662--dlt-hub-docs.netlify.app/docs/dlt-ecosystem/destinations/lancedb/#run-the-pipeline