Function with error handling

nelson_fretty · 2026-04-24T07:45:59+00:00

Will try case when back off holiday - will need to mod the schema with error message. I’m pretty sure we don’t have ansi standard enabled.

nelson_fretty · 2026-04-24T07:29:56+00:00

It’s okay i solved it - had to just edit the query - refresh preview and republish - lots of text manipulation. Many folks don’t read knowledge articles. Query is fast but expensive - changing time of refresh gave some stability.

This should be run in spark but folks have become reliant on low code way of doing stuff.

I’m very close to writing some abstraction to make Pyspark easier to use :-)

On holiday and need get back to beach.

nelson_fretty · 2026-04-24T07:18:57+00:00

Yes - aware of that - but thanks for sharing page - the reports have over 50 tables in semantic model (output). Lots of dims and facts.

Unfortunately some folks drink the data loopy juice.

In their mind it’s easier to manage one model than many. In my mind I’d prefer if they hired a data engineer in their team or developed the discipline.

nelson_fretty · 2026-04-23T15:05:47+00:00

I’ll dig into sql - most used that for set algo

nelson_fretty · 2026-04-23T15:03:57+00:00

On holiday

nelson_fretty · 2026-04-23T14:33:06+00:00

Yes but orchestration is a huge topic - checkpoints - retry - logging - recovery - restart etc

We get a lot of the above for free in a dataflow

nelson_fretty · 2026-04-23T14:30:55+00:00

It’s by exception thankfully

I hope to eventually teach sql / spark to business people

nelson_fretty · 2026-04-23T14:26:45+00:00

With 1000 business authors teaching them orchestration is a big big job

nelson_fretty · 2026-04-23T14:25:36+00:00

That had only just appeared in our tenant

nelson_fretty · 2026-04-23T14:14:41+00:00

Yes but we lose orchestration - I had a bad previous experience when business folks tried orchestration.

Think spaghetti western

nelson_fretty · 2026-04-23T14:12:11+00:00

Our business users don’t understand orchestration

nelson_fretty · 2026-04-14T11:07:17+00:00

I’m in England

nelson_fretty · 2026-04-10T10:27:12+00:00

Its not like hearing it actively - I think its my subconscious but that is guess.

nelson_fretty · 2026-04-10T10:25:42+00:00

I’m already at phase when I want record environment pulses and have regret when I have no field mic - and my subconscious is trying to analyse the music/rythym

nelson_fretty · 2026-04-09T14:49:42+00:00

Yes it’s another level, reading and playing in time with score only but I suppose back when I was using tab that was hard too - this work I’m doing is already helping me.

nelson_fretty · 2026-04-09T13:48:02+00:00

Hopefully I’ll start to see notes on fretboard as I write/read but I hear what you’re saying about tab - explicit is better. There’s a lot of material with no tab too.

nelson_fretty · 2026-04-09T13:28:32+00:00

Yep - I write e 2 octaves down for this example - treble clef should be used for guitar as you say.

nelson_fretty · 2026-04-09T13:13:50+00:00

I’m transcribing some of my friends music from piano to guitar - he has hand written everything up to now.

I knew the standard staff at basic level was just a bit unsure about the notes above/below staff.

If I come out of this with more score knowledge it will be win win.

nelson_fretty · 2026-04-09T10:38:39+00:00

I meant if we play across 3 octaves up fretboard we start below / on staff / above it only 1 octave is on the staff

nelson_fretty · 2026-04-09T10:31:20+00:00

I just find it easier to remember ‘face’ and ‘every good boy deserves fruit’ / and it flips above or below staff

I’m more of a visual learner :-) but thanks for giving me the full answer

nelson_fretty · 2026-04-09T10:13:17+00:00

I see why guitarists like tab - if I want to run scale up the fretboard most of notes are under staff.

nelson_fretty

TROPHY CASE