Re: Databricks connecting SQL Azure DW - Confused ...

dilkushpatel · ‎04-17-2024

thanks for taking time and wiriting detailed text.

So i'm not writing exlicit copy into, I'm just trying to read from table in SQL DW, syntax looks like this

df = spark.read \

.format("sqldw") \

.option("host", "<server name>.sql.azuresynapse.net") \

.option("port", "1433") \

.option("user", "<user name>") \

.option("password", "<password>") \

.option("database", "<DB Name>") \

.option("dbtable", "<schema>.<table>") \

.option("tempDir", "abfss://<storage container>@<storage account>.dfs.core.windows.net/temp-data") \

.option("forwardSparkAzureStorageCredentials", "true") \

.load()

Before this i have blocked where i assign storage app id and scret for access from DW and Databricks

with this error I get when I do df.show() is

com.microsoft.sqlserver.jdbc.SQLServerException: User does not have permission to perform this action. [ErrorCode = 15247] [SQLState = S0001]

I have given Schema level read

DB level create

ADMINISTRATE BULK LOAD

INSERT AT DB level