{"id":1557,"date":"2026-01-09T09:59:32","date_gmt":"2026-01-09T07:59:32","guid":{"rendered":"https:\/\/www.flip-design.de\/?p=1557"},"modified":"2026-01-09T09:59:32","modified_gmt":"2026-01-09T07:59:32","slug":"how-can-i-add-a-new-column-to-my-fabric-evenstream-so-that-the-values-can-also-be-stored-in-my-eventhouse-kql","status":"publish","type":"post","link":"https:\/\/www.flip-design.de\/?p=1557","title":{"rendered":"How can I add a new column to my Fabric Evenstream so that the values \u200b\u200bcan also be stored in my Eventhouse (KQL)?"},"content":{"rendered":"\n

Recently, I encountered the question of how to add a new attribute to my KQL table when the event stream provides new attributes. I searched in vain to see if I could edit this in the UI. Within Data Fabric or Integration Services, this is easily possible via field mapping. So there had to be another way!<\/p>\n\n\n\n

First, I edited my target table in my KQL database:<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

The values \u200b\u200bfor SimpleValue are already being transferred via my PowerShell script. I reused and extended the script from the following entry: https:\/\/www.flip-design.de\/?p=1495<\/a><\/p>\n\n\n\n

To check if data is being received, the following query can be used:<\/p>\n\n\n\n

evt\r\n| where isnotempty(SimpleValue)\r\n| take 100\r\n<\/code><\/pre>\n\n\n\n
However, in order for data to be written to this column, it needs to be mapped somehow. This can be achieved relatively easily by removing the target, then recreating it and selecting the existing, edited table.<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
From now on, the new information will also be stored in this column:<\/p>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Recently, I encountered the question of how to add a new attribute to my KQL table when the event stream provides new attributes. I searched in vain to see if I could edit this in the UI. Within Data Fabric … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/1557"}],"collection":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1557"}],"version-history":[{"count":1,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/1557\/revisions"}],"predecessor-version":[{"id":1561,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=\/wp\/v2\/posts\/1557\/revisions\/1561"}],"wp:attachment":[{"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1557"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1557"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flip-design.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1557"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}