amanda fioritto
afioritto.bsky.social
amanda fioritto
@afioritto.bsky.social
data @ hex | midwest hobbit | i talk about my dog too much
I wish there was a way for the dbt Cloud Explore DAG to filter to content that exists *between* two nodes. Anyone know of a fun work-around for this with other tools?

#dataBS
January 15, 2025 at 5:51 PM
a poem by poetry:

poetry run dbt compile
command not found: dbt

poetry show | grep dbt
dbt 1.0.0.38.22

pip freeze | grep dbt
dbt==1.0.0.38.22

which dbt
dbt not found

(look, no one said it was a happy poem)
#dataBS
December 12, 2024 at 2:50 PM
It's fun to work on challenging problems.
It's *more* fun to work on them as a team.
It's the *most* fun when you have a smart teammate who finally cracks the code.

Data is a team sport!
#dataBS
Super #SQL brainteaser for your Tuesday that kept a few folks on our team thinking pretty hard until someone made an elegant solution.

The desired behavior per unit:
* First event qualifies
* Subsequent events qualify only if it's been more than 90 days since the last

Sample dates below #dataBS
December 10, 2024 at 8:19 PM
dbt job: "Can't parse a JSON blob, I'm out."

me: *looks for a needle in the 100M-row haystack*

me: "Aha! This looks fine? Guess I'll paste it in a text editor to double check."

text editor: "Uh, boss"

me: "Is that...is that a tiny red 'BS'?"

BS broke my data. I can't make this shit up.
#dataBS
December 5, 2024 at 3:17 PM
Life is messy. So is analytics engineering. Sometimes your warehouse looks like the "clothes pile" your partner has been slowly building in the corner of your closet.

The good news is that you CAN make your warehouse a wareHOME. And that I wrote you a how-to guide.

tinyurl.com/5h35ktj2 #dataBS
How we renovated our data warehouse without interruption | Hex
Blue-green deployment is a strategy for updating dbt projects that allows for iterative development without interrupting production.
hex.tech
December 4, 2024 at 9:23 PM
10x analytics engineering tip for the week of Thanksgiving: If you're stuck on a problem, let its solution bake in the recesses of your mind while you bake an actual pie. Whether the solution comes to you matters not, because it's a holiday week. And you end up with pie. #dataBS
November 27, 2024 at 7:32 PM
I am convinced that the YML-based semantic layer was as much invented by a data professional as the stiletto heel was invented by a woman

(the stiletto heel was invented by a man)

#dataBS
November 25, 2024 at 9:35 PM
Reposted by amanda fioritto
Do I know anyone in #dataBS who has built out a fairly full-scale metrics layer in MetricFlow (dbt) or Cube? Looking for someone who'd connect for ~30 with someone on my team starting the process for us at Hex!
November 19, 2024 at 10:11 PM
is this where data twitter went?
November 19, 2024 at 11:06 PM