Unable to see all the lake database tables in synapse workspace

Question

Hello,

I am unable to see the Lake Database tables inside db blade on left side of synapse workspace, only few are visible but rest are not visible but I am able to see them through SSMS and also execute query on them.

In fact, these tables are not present in the Git Repository configured for synapse on Azure DevOps which is affecting my deployment.

Any help will be really appreciated!
Thank you.

Answer 1

It seems like you are facing two related issues in Azure Synapse Analytics:

1. Not all Lake Database tables are visible in the Synapse workspace: You mentioned that you are able to see and query the tables through SSMS (SQL Server Management Studio) but not in the Synapse workspace UI.
2. Missing tables in the Git repository: Some tables are not being tracked in your Git repository in Azure DevOps, which is affecting your deployment.

Here are some steps you can take to resolve these issues:

1. Visibility Issue in Synapse Workspace

• Check Synapse Studio Settings:
  • Go to your Synapse workspace and ensure the proper databases and linked services are selected and configured.
  • Sometimes the tables might not be visible in the default database context. Double-check the database dropdown to ensure you're connected to the correct database.
• Check Security Permissions:
  • Ensure that the user account you're using to access the Synapse workspace has the necessary permissions to view the Lake Database tables. Even though you can query through SSMS, the Synapse workspace UI might require explicit permissions.
  • Review the Access Control (IAM) settings to verify if you have full visibility for all tables in the Lake Database.
• Refresh Synapse Studio:
  • There may be a delay in syncing between the Lake Database and Synapse Studio. Try refreshing the blade by closing and reopening the Synapse Studio or clearing your browser cache.
• Check the Metadata Store:
  • Sometimes, the metadata in Synapse can become desynchronized. Check if the tables that are not visible have any issues with their metadata. You may need to refresh the metadata in the Synapse Studio or restart the service.

2. Tables Missing in Git Repository (Azure DevOps)

• Check Synapse Git Integration Settings:
  • Verify that the correct Git repository is linked to the Synapse workspace and that your workspace is fully synchronized with the Git repository.
  • If tables are created or modified outside of Synapse Studio (e.g., via SSMS or scripts), they might not be automatically tracked in the Git repository.
• Manual Check for Missing Items:
  • Go through the “Publish” process in Synapse Studio. If tables were created or altered outside Synapse Studio, manually reimport them into your Synapse project and commit the changes to Git.
  • Ensure that any unsaved changes are pushed to your Git repository.
• Check DevOps Pipeline:
  • Review the deployment pipeline configured in Azure DevOps to ensure that all tables and artifacts are part of the deployment process. You might need to modify the pipeline to include the missing tables if they aren't tracked automatically.

By checking these areas, you should be able to resolve both the visibility issue and the Git repository synchronization problem. Let me know if you need more detailed steps on any of these suggestions!