topic Re: Unable to write the data into KQL database from Notebook in Data Engineering

Unable to write the data into KQL database from Notebook

sertajmujawar — Thu, 06 Mar 2025 09:31:42 GMT

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()

Re: Unable to write the data into KQL database from Notebook

v-veshwara-msft — Thu, 06 Mar 2025 17:12:35 GMT

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.

Re: Unable to write the data into KQL database from Notebook

v-veshwara-msft — Wed, 12 Mar 2025 05:26:00 GMT

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.

Re: Unable to write the data into KQL database from Notebook

sertajmujawar — Wed, 12 Mar 2025 11:32:24 GMT

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

Re: Unable to write the data into KQL database from Notebook

v-veshwara-msft — Wed, 12 Mar 2025 11:41:55 GMT

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.

Re: Unable to write the data into KQL database from Notebook

v-veshwara-msft — Sun, 16 Mar 2025 07:29:37 GMT

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.

Re: Unable to write the data into KQL database from Notebook

sertajmujawar — Fri, 21 Mar 2025 04:23:18 GMT

Yes, it is working now. Thank you.