Jacob Matson

oh that makes so much sense. Fixed possession lengths etc all come out of that approach. I'll continue to work on this sub stuff then but any other gamesim changes...

Is it possible to solve this simply - i.e. an additional field vs. a complex algorithm? "First name initial" or similar?

It sounds like there is a "hybrid" solution necessary here - so the issue is defining the scope. If we can identify what the "out of scope" names are, we...

https://github.com/baldwicc/dbt-sqlserver/pull/7 fixes the failing tests. @baldwicc, please approve the PR and then this can come through. Please update the changelog.md as well.

Thanks @mjbloch! I can see this currently reproducing on here too. https://mdsinabox.com/ncaaf/conferences/ Looks like 0 values aren't rendering right too.

Seems like this might be something to pick up in tsql-utils, as we need a shim to handle this use case. The CTE patterns ascribed by the dbt folks do...

@ibayer imo the advantage of meltano is the ecosystem of connectors - ironically the csv extractor is not required to use with dbt-duckdb. Think about the MDS in a box...

I think the key bit from a DX perspective is that SQL should be transparently passed to components. It should be consistent for me to reason about when passing SQL...

Would it be helpful to add code snippets of how I am using the `` component today to accomplish this over on https://twitter.evidence.app/tests/ ?

Alright, consider a dataset with two columns, x & value, called “my_data”, and ordered by x. We first need to calculate some metrics on it. ### Average ```sql from ${my_data}...