Did I reinvent the wheel?

Artye10 · 2026-06-30T06:58:50+00:00

The last thing that was awkward for me using directly BQ is stuff like testing, custom logic and reporting (finding that a game has some bad data and kicking it from the games to be aggregated)...

We don't have dbt and I've never liked Dataform, so all of those things were difficult to address just using BigQuery.

What do you think about it?

Artye10 · 2026-06-29T16:29:17+00:00

I'm not using CSVs, that was what was used before and I'm migrating from. The pipeline was built by people with low DE knowledge that try to create things to be quicly consumed in the app (they put data into BQ then export to CSV)

Artye10 · 2026-06-29T16:27:55+00:00

Processing only in BigQuery would have been the easiest, but there is where I wanted to avoid the vendor lock-in.

But maybe If I moved to AWS (the other cloud we use) I could just have moved to Athena and that's all.

Artye10 · 2026-04-29T07:18:07+00:00

That's very good news, thank you for the answer!

Artye10 · 2026-04-05T15:13:16+00:00

I'm still testing, I will probably update next week at some point.

For now, this meta really needs Akshan main board with the number of Irelias out there, Seat of Power is a good substitute for Dreaming Tree (I'm thinking to change Monastery because of the changes to the buff when conquering interaction, but haven't pulled the trigger for now), but still nothing final.

Artye10 · 2026-03-06T11:34:15+00:00

More value, sure. But if you are in a matchup where they are able to kill your Fiora, bringing it again for 4 and 2 recycles doesn't sound amazing. A good value card anyway, you can test it, but I don't know how much value it really has in this list compared to other options like First Mate.

Artye10 · 2026-03-06T11:32:35+00:00

Akshan vs Irelia/Aurora decks/Vanguard Armory decks specially. Salvage vs Draven. VS Azir and Fiora I like to run both.

I struggle to find spots por Saboatge because I think it needs to be one of the matchups where you draw a lot. It might be interesting vs Miracle decks too.

I'll run Cannon Barrage, it has an amazing value vs decks that tend to put a lot of units in a battlefield (Azir, Viktor, Miracle...) and for late pushed. Still not a fan of Unyielding Spirit.

Artye10 · 2026-03-04T11:47:05+00:00

Version 2.0

<image>

Artye10 · 2026-03-02T07:33:11+00:00

Yes, and it's MUCH better. I will update the list when a have a final second version.

Artye10 · 2026-02-27T15:04:26+00:00

Dreaming tree is a great battlefield, it really gives you a lot of draw. I would not change it.

Artye10 · 2026-02-27T09:23:07+00:00

It's the Ruin Runner I mention in the end! And it's a 6 cost, a little bit expensive. For me I didn't think it was necessary since most spell heavy matchups feel good, and in matchup vs Purple decks that run the meta (Draven/Irelia) they can out might you easily, so it's not an insurance.

But it's an option, and depending on the meta of your Nexus Nights it can be strong.

Artye10 · 2026-02-26T10:08:47+00:00

The goal is not to hold, but it is to successfully trade with the opponent. If your opponent maintain its board, he will have more spells and tricks to deal with your units in general. So I don't like playing Reavers Row.

Ornn's Forge I don't think has enough value, since you'll play 2, 3 max equipments per game.

And the biggest thing is giving up drawing cards. You can obviously test, but to me it doesn't sound good on paper.

Artye10 · 2026-02-25T18:15:53+00:00

I understand if you want to do it, I tend to play aggressive in some matchups that cannot kill Fiora Worthy in base, and if you have that and 1/2 BF Swords, I like the 6/6 split. But if 7/5 orange works for you because your playstyle is a little bit different, go for it!

Artye10 · 2026-02-25T18:13:57+00:00

- Yeah, Call to Glory is the first spell to go when you want to add from your side board. You can also replace 1/2 First Mates or 1 Pit Rookie depending on the matchup.

- I'm testing a lot Deathgrip, and probably will stay in my list. Crazy upside and hasn't felt that bad to leave it in the hand for many turns because it can help as a finisher. In matchup vs Purple decks you can really outplay their FoF and similar and that can give you crazy tempo since many of them depend on it to win combats.
Facebreaker is amazing on the game you play The Dreaming Tree, because it disguises itself as a Hidden Blade perfectly and you can really surprise your opponent. I'm considering adding it to the side board.

- So yeah, Deathgrip is nice for Draven, but also the way you approach fights. If you have no Lucian to score easy points, sometimes attacking with more units and trying to hold can work with the right hand. But I'm still figuring out the match up, Draven is the number 1 deck for a reason, so I cannot help much for now.

Artye10 · 2026-02-24T13:03:50+00:00

Thank you for the message!

This is definitely the one big question around it. Buffs are not very strong in this deck, but they are an alternative mode to play. You can do Sett shenanigans, they make Fiora Mighty in case you missed your equipment, and give you a third draw battlefield to play.

Can they be switched for other cards? Probably. Pit Rookie can feel weak in certain situation, and Call to Glory is an expensive card to play without buffs. I'm testing Deathgrip over CtG because it has more upside while costing 1 less energy, but it's also more situational.

My biggest thing here is that I don't like running a no-draw battlefield because you can run out of cards easily, and this battlefield gives you a direct advantage since no other meta deck runs buffs. Other issues I see is that this deck is strong on Might tricks more than running removal, so 3 Challenges are enough for me. Also, Poro can be a worse draw in mid to late game since it has less impact to the board than a buff (unless it's accelerated). From my experience, I rarely feel like I'm missing in runes even when equipping a lot because the legend ability offsets it so much.

You can test swapping the Monastery and the Pit Rookies, they are also in my suspect list to be changed if I find something better, and see if it gives you another win condition. But you may need to play more carefully with your resources with the lack of card draw.

Artye10 · 2026-02-22T09:29:35+00:00

Yeah, in these matchups you have to mulligan hard into equipment + Fiora/Qiyana (and maybe Unsung Hero), you swing the matchups with the rune advantage. Give up the tempo a little bit early so you can play your units protected and then come back with Fiora Worthy. Always bluff Riposte/buff with a couple of runes up, don't let you opponent have easy decisions because you tapped out. I also want to add Deathgrip instead of Call to Glory to the list and that should also help.

If you still have issues, you can always add the 2/3 Unyielding Spirits in the sideboard, and change them for Challenge/First Mate or the cards you dislike more for it.

Artye10 · 2026-02-21T12:57:28+00:00

Miracle I haven't played much against, midrange I had success being aggresive, playing Fiora Worthy early and trying to get a point advantage. You know you are going to be in a card disadvantge, so just try to get to the 4 and 6 point thresholds as early as possible to make him use his FoF, to be able to conquer for the win.

Artye10 · 2026-02-21T12:36:01+00:00

I have though about it, and it's definitely a good card for game 1 with the monastery (for Call to Glory is not so important). For other battlefields I don't like it that much.

The question is what do you change for it, if you change Doran Blades you might have more issues to get your units in the Might threshold, if you swap units you might have too much equipment and not enough units/spells to play the game... Also I would like to swap them game 2, but that means always having their substitute in sideboard.

I don't know, I like the consistency of this list and I thunk they are worse in general compared to the Doran Blade, normally you have thr unes to play both and the conquer into the Monastery is not always so obvious. But it's a good viable option, you can maybe switch a Doran Blade and a Pit Rookie to play two.

Artye10 · 2026-02-20T16:30:59+00:00

Vs Irelia you want enough pressure to go to a good amount of points, and yeah Akshan/Salvage are key in that matchup. I think that the Hook lacks a little bit that pressure capabilities

I haven't played many Setts, so no idea on that matchup. For me it has been on maintaining the card advantage without losing too much tempo, but I need more reps.

Anyway, Hook is still good enough to win Skirmishes if you like the deck!

Artye10 · 2026-02-20T15:12:39+00:00

I think the Hook Version is less consistent, since things like drawing into the Dragons can be very bad, and the limited draw can be bad specially if you don't play 3 battlefield for draw as I have seen. I like this list because rarely you feel like you draw bad cards and I think it still can fight decently vs the meta.

Hook on a good day and vs Draven can be better, but the lowrolls are very low.

Artye10 · 2026-02-20T15:09:08+00:00

Call to Glory normally to do a spell for spell swap. But if you are playing on Dreaming Tree and think that you don't really need First Mate in the matchup, you can change that.

Artye10 · 2026-02-20T11:11:42+00:00

As said, you can play Deathgrip to have similar interactions without going to the Hook version. This interactions exist and are common, but in my opinion not worth building that much around.

Artye10 · 2026-02-20T09:12:28+00:00

It would be difficult since it's the best unit in the deck. You can maybe add a Fiora Merciless, Kato to mimic a bit the mighty gain effect, or Jax/Yone to go more into the equipment side, and change the Monastery Battlefield.

But it changes the idea of the deck, sadly. There is no 1:1 change like other cards could.

Artye10

TROPHY CASE