Invalid object name ‘dataverse_.dbo.opportunity_partitioned’

In this blog post, we will discuss a common issue encountered when trying to access partitioned tables in Azure Synapse Workspace, specifically those created by ingesting tables from Power Platform through Azure Synapse Link for Dataverse. While the snapshot folder and .csv files are typically generated, users face difficulties in accessing these partitioned tables. The problem is characterized by an error message that reads: “Invalid object name ‘dataverse_********.dbo.opportunity_partitioned’.”

Resolution:

1. Check if Workspace System Assigned Managed identity has Storage Blob Data Contributor access on the Storage Account.
2. Create a server-scoped credential on the master database for the storage account and container
3. Partition table should work after creating server-scoped credentials

USE MASTER
CREATE CREDENTIAL [https://storageaccount.dfs.core.windows.net/container]
WITH IDENTITY=’Managed Identity’

Reference: https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-storage-files-storage-access-control?tabs=shared-access-signature#server-scoped-credential