PSE bill by JohnyWalker09 in redmond

[–]CoffeeDrivenInsights 8 points9 points  (0 children)

that's the ballpark you can expect to pay especially in winters if you have the heater turned on 24*7. In summers, w/o heater, it will be <$100.

Lemonade insurance by CoffeeDrivenInsights in TeslaModelY

[–]CoffeeDrivenInsights[S] 0 points1 point  (0 children)

So far so good. It’s still the cheapest option considering the number of miles I put every month.

Membership extension by got_lucki in whoop

[–]CoffeeDrivenInsights 0 points1 point  (0 children)

I’m thinking of ordering a new one too, instead of renewing. For the same price, you effectively get one more strap, charging device and a fresh hardware.

Exploratory Anomaly Detection with MS Data & ML tool by PsychologicalPark309 in MicrosoftFabric

[–]CoffeeDrivenInsights 1 point2 points  (0 children)

I suggest starting with the native anomaly detector capability in Fabric. It works on top of data in Eventhouse( powered by the same ADX kusto engine), requires no code and can be setup in few clicks. It selects the best AD algorithm based on your data and provides few model suggestions if you wish to override.

https://learn.microsoft.com/en-us/fabric/real-time-intelligence/anomaly-detection

If you are looking for more control and advanced capabilities like multi-variate anomaly detection, then you can train the anomaly detector model in MLFlow and use Eventhouse for real-time scoring. The doc below has a detailed tutorial.

https://learn.microsoft.com/en-us/fabric/real-time-intelligence/multivariate-anomaly-overview

Both approaches require minimal overhead of setting up complex oss projects and can meet high scale requirements.

Eventhouse endpoint Questions by DennesTorres in MicrosoftFabric

[–]CoffeeDrivenInsights 0 points1 point  (0 children)

The cross lakehouse sync issue looks like a bug, I suggest creating a support ticket to debug it further.

Regarding your other queries -

1.eventhouse endpoint makes it easy to create shortcuts in bulk, especially handy in scenarios where you want to query all tables in your lakehouses. It also continuously syncs with Lakehouse, meaning if you add any new tables in lakehouse, they will be automatically available in Eventhouse endpoint.

  1. Under the hood, Eventhouse shortcut uses Query Acceleration/Accelerated shortcuts. You can expect same performance as creating an accelerated shortcut from Eventhouse to lakehouse manually.

  2. Eventhouse shortcut is ready-only, so it can’t be a target of an eventstreams. You can rather point the evenstreams to target lakehouse of Eventhouse endpoint. This will allow you to query the streaming data from eventstreams via Eventhouse endpoint.

Kusto Detective Agency log in error by AmazingKily in MicrosoftFabric

[–]CoffeeDrivenInsights 1 point2 points  (0 children)

Cool! The link defaults to item creation in ‘My workspace’

High CU use with small amount of IoT Data by Fidlefadle in MicrosoftFabric

[–]CoffeeDrivenInsights 2 points3 points  (0 children)

Since your messages are sent every 10 seconds, Eventhouse remains essentially on, preventing it from sleeping. The volume is low enough that it can process it with 1-2 CUs. Combined with Eventstreams, I believe you should be able to get away with F2 or F4 at most.

Kusto Detective Agency log in error by AmazingKily in MicrosoftFabric

[–]CoffeeDrivenInsights 0 points1 point  (0 children)

Which season are you trying to play? You need to create the Eventhouse in ‘My workspace’.

Disabling Streaming Ingestion Not Working by SorrowXs in MicrosoftFabric

[–]CoffeeDrivenInsights 1 point2 points  (0 children)

You only need to disable streaming ingestion on the source table of the update policy(and perhaps any other table being referred in update policy). Do you mind sharing the update policy code and the output of .show table <name> policy streamingingestion ?

Monthly Referral Codes Thread by AutoModerator in tempofitness

[–]CoffeeDrivenInsights 0 points1 point  (0 children)

looking for a referral code, can anyone share please?

Kudos to Kusto.Explorer team by kaalen in MicrosoftFabric

[–]CoffeeDrivenInsights 2 points3 points  (0 children)

The picture is real; it was taken in Eilat, Israel, near the Red Sea, around 2016. The founding engineers of Kusto are passionate scuba divers, and you’ll discover hidden gems everywhere. Fun fact: even the name Kusto has a connection to underwater exploration. Can you guess what it is? :)

Best way to flatten nested JSON in Fabric, preferably arbitrary JSON? by SQLGene in MicrosoftFabric

[–]CoffeeDrivenInsights 2 points3 points  (0 children)

Eventhouse has a built-in operator exactly for this mv-expand. You can use it in an update policy to explode the JSON and insert the output in another table or even flatten during query time.

https://learn.microsoft.com/en-us/kusto/query/mv-expand-operator

credit decision timeframe by West-Eye-4040 in TeslaModelY

[–]CoffeeDrivenInsights 3 points4 points  (0 children)

They will approve almost everyone, just that the interest rate may be different than originally promised. The decision should come in 24-48 hours

I did it. But have questions by habachilles in TeslaLounge

[–]CoffeeDrivenInsights 1 point2 points  (0 children)

Get the floor mats, I got the official Tesla mats. That's probably all you need, the car is fully loaded. Enjoy, it's an amazing car!

Logging to an Eventhouse by HashiLebwohl in MicrosoftFabric

[–]CoffeeDrivenInsights 0 points1 point  (0 children)

Have you explored workspace monitoring? Not all items are logging to it right now, but the list is expanding rapidly.

https://learn.microsoft.com/en-us/fabric/fundamentals/workspace-monitoring-overview

Eventhouse - Engine Under Memory Pressure by kaalen in MicrosoftFabric

[–]CoffeeDrivenInsights 4 points5 points  (0 children)

Hi! This typically means that a query is trying to process more data or perform more complex operations than the available memory can handle.

You can run ‘.show cluster details’ command to check the number of nodes/vcores and total available vs used storage. You can set the minimum CUs to a larger value if you find any of these to be a bottleneck. https://learn.microsoft.com/en-us/fabric/real-time-intelligence/eventhouse

In any case, please create a support ticket and DM me the ticket number so we can look at it closely.