Hi @Kaniz_Fatma
Double-check the credentials (username and password) youโre using. Ensure they are correct and have the necessary privileges.
Im able to run select using same user from SSMS
Confirm that the server name and port are accurate.
They are
You mentioned blocking where you assign storage app ID and secret for access from both DW and Databricks.
Sorry I mean code block.
Ensure that the storage app ID and secret are correctly configured and have the required permissions to access the storage container.
They are correct, I can list and read files from that location.
Verify that the storage container path (abfss://<storage container>@<storage account>.dfs.core.windows.net/temp-data) is accurate.
It is
Confirm that the firewall rules on the Azure Synapse side allow connections from the Databricks cluster
IP blocking is not configured, everyone from anywhere can connect to DW
Whitelist the Databricks clusterโs IP address if necessary.
IP blocking is not configured, everyone from anywhere can connect to DW
Temporarily grant the user more permissions (e.g., CONTROL on the entire data warehouse) to see if the issue persists.
Will try this and update
If it works with additional permissions, gradually reduce them to the minimum required.
As such other than control rest permissions look fine
Consider using the COPY INTO command (which is the recommended method) for loading data into Azure Synapse.
Im not loading anything into Synapse DW. Reading from DW
If you decide to switch, ensure that your Databricks Runtime version supports COPY INTO.
Databricks runtime version is 13.1 if I remember correctly