Unable to write the data into KQL database from Notebook

[sertajmujawar]

Hi Team,

I am unable to write the data into my KQL database from python notebook. I am using Microsoft Fabric free trial account. I was able to read the data from KQL table but I am unable to write the data. I have pasted the screenshot of my code.  

# The Kusto cluster uri to write the data. The query Uri is of the form https://<>.kusto.data.microsoft.com

kustoUri = "https://ingest-trd-12jnamujc5c3ktnpvg.z5.kusto.fabric.microsoft.com"

# The database to write the data

database = "NGED"

# The table to write the data

table    = "temp"

# The access credentials for the write

accessToken = mssparkutils.credentials.getToken('kusto')

# Generate a range of 5 rows with Id's 5 to 9

data = spark.range(5,10)

# Write data to a Kusto table

data.write.\

format("com.microsoft.kusto.spark.synapse.datasource").\

option("kustoCluster",kustoUri).\

option("kustoDatabase",database).\

option("kustoTable", table).\

option("accessToken", accessToken ).\

option("tableCreateOptions", "CreateIfNotExist").mode("Append").save()

[sertajmujawar]

Yes, it is working now. Thank you.

[v-veshwara-msft]

Hi @sertajmujawar ,

Could you please mark the helpful reply as "Accept as Solution" to assist others facing similar issues? This helps the community quickly find the right answers.

We appreciate your cooperation and look forward to supporting you with any future queries in the Fabric Community Forum.

Best regards,
Vinay.

[sertajmujawar]

Thank you, I was able to write the data into KQL database, after correcting the URL

[v-veshwara-msft]

Glad to hear that it worked after correcting the URL. Could you also consider marking the reply as "Accept as Solution" to assist others facing similar issue.

Please continue using Fabric Community Forum for further queries.

Best Regards,
Vinay.

[v-veshwara-msft]

Hi @sertajmujawar ,

Just following up on your issue to see if you’ve found a solution. If so, please mark the helpful reply as the Accepted Solution to assist others with similar issues. If you still need help, feel free to reach out for further assistance.

Best regards,
Vinay.

[v-veshwara-msft · Accepted solution]

Hi @sertajmujawar ,

Thanks for posting in the Microsoft Fabric Community.

Please use the Query URI instead of the Ingestion URI and try again to write data to the KQL database.
You can find it in the Overview section under Database Details.

For reference, here is a similar discussion where this issue was resolved Solved: Writing to KQL db from notebook - Error - Microsoft Fabric Community

Hope this helps. Please reach out for further assistance.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and a kudos would be appreciated.

Best Regards,
Vinay.