Fabric Lakehouse SQL Analytics Endpoint - SQL Projects extract.

Hi Eswar-Sahukari​,

Thank you for reaching out to Microsoft Fabric Community.

Since extraction works for some endpoints but not others, compare whether they use legacy metadata or new metadata sync (preview). Because the new sync uses an external table-based architecture, which is a relevant difference to investigate but it is not a confirmed cause.

Retry the extraction using the same account, extraction settings and with the latest updated Visual Studio/SSDT. If tables are still missing, capture the extraction logs for a support investigation.

For deployment, maintain delta table creation scripts in spark notebooks separately from sql endpoint views, do not recreate the underlying tables through the endpoint.

For reference follow the below documentation:
SQL Analytics Endpoint Metadata Sync - Microsoft Fabric | Microsoft Learn

Thanks and regards,
Anjan Kumar Chippa