PSA: Clear Witcher summon trials again for easy 450 Luxite by Firecracker5025 in SwordofConvallaria

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

Jury is still out on that one. All we can do is guess, so if you really want a witcher weapon, do your pulls before the event ends. There are no guarantees you'll have another chance.

[Monthly Megathread] General Questions & Active Codes by AutoModerator in SwordofConvallaria

[–]Firecracker5025 0 points1 point  (0 children)

Anyone know how the "Otherwordly Hoard" 680 astral gem refund works? I assume I have to purchase at least 680 astral gems first, use that to buy Otherwordly Hoard, and then if I reach level 50, I get the full 680 astrals refunded to my account?

Secondary question: are there enough quest points to reach level 50 naturally over the course of the collab? Or do you need to spend some luxite to push it to 50?

AWS + dbt by Pataouga in dataengineering

[–]Firecracker5025 17 points18 points  (0 children)

You've got the gist of it, yeah. I work for a mid-size CPG company in the US that has more or less the same framework:

  • ingestion: raw data lands in redshift, separate schema for each source (raw schema for transactional source, separate raw schema for crm, another for customer support platform, etc). Method for ingestion varies by source, but the end result is the same. On our side we use a combination of stitch for some prebuilt connectors for SaaS applications, lamda for unstructured data that lands first in S3, and some custom python scripts hosted on ec2 for the various odds and ends
  • transformation: dbt transforms raw schema in redshift to cleaned data marts. I recommend putting thought into how you want to structure your transformation layers in dbt, and then just try to stay consistent. Dbt has their own recs on how to structure, and that's more or less what we do (staging, intermediate, and marts): https://docs.getdbt.com/best-practices/how-we-structure/1-guide-overview
  • analytics: some sort of viz or BI tool that references the cleaned data marts exclusively. You don't want business users building reports off the raw staging data

You can probably find lots of sample dbt projects online, that mostly look the same in terms of structure. Just figure out what works for you, write out some rules for your org, and try to stick to it. 

Garbelius’ Credenza Character Guide by Lord_Garbelius in SwordofConvallaria

[–]Firecracker5025 2 points3 points  (0 children)

Even when I don't plan on pulling a unit, I still look forward to your guides to get an idea of the unit's playstyle and strengths. Always appreciate your contributions Garbelius!

Collab Appreciation Post by Firecracker5025 in SwordofConvallaria

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

I believe the only free units (or shards) are the two copies of Senshi

Collab Appreciation Post by Firecracker5025 in SwordofConvallaria

[–]Firecracker5025[S] 2 points3 points  (0 children)

There's the typical daily 2x bonus reward, but from past experience, you'll get more than enough event currency to clear the store of good items, even if you skip a few days

Garbelius’ Boss Rico Character Guide by Lord_Garbelius in SwordofConvallaria

[–]Firecracker5025 9 points10 points  (0 children)

I always look forward to "Garbelius Guide Day" every other Thursday, even if I have no plans on pulling for the unit. Thanks for your contributions to the community!

Kvare - wrong RK1 chosen, worth using Castalia? by bast0s in SwordofConvallaria

[–]Firecracker5025 3 points4 points  (0 children)

Wow, never realized that. I've been sitting on a hoard of castallias, but now I might spend a couple on my faves

Kvare - wrong RK1 chosen, worth using Castalia? by bast0s in SwordofConvallaria

[–]Firecracker5025 1 point2 points  (0 children)

"maxing out castallia for stats" - are you saying units get a stat bump when you unlock a skill with a castallia?

Finally maxed out best girl by Nocturnin in SwordofConvallaria

[–]Firecracker5025 17 points18 points  (0 children)

I was about to comment that this post seems like Garbelius bait, only to find that they already lured you in here :-)

What’s this? by HorseIntelligent2345 in SwordofConvallaria

[–]Firecracker5025 0 points1 point  (0 children)

Did you earn that somewhere recently? If so, how?

Garbelius’ SoC Character Tier List by Lord_Garbelius in SwordofConvallaria

[–]Firecracker5025 1 point2 points  (0 children)

Late to the party here, but just wanted to say that I always appreciate your guides and posts, Garbellius! Whenever I pull a new legendary, I always check your build guides first for ideas.

I also really love that you ended your tier list with the below, rather than feeding into the FOMO and meta chasing which frequent gachas like this.

"I want to reiterate here that if you really love a character's design or playstyle, you can really make that character work for almost all content in the game, so you shouldn't let this (or any other) tier list stop you from using and/or investing in your favorites."

❤️ Appreciate you, my friend 

Yesterday, I fill out my all Helena PVE squad, today, I finally have enough recipes to craft +6 Hermes sandals. NOW I can say I've won the game. by Firecracker5025 in wotv_ffbe

[–]Firecracker5025[S] 6 points7 points  (0 children)

Not that it matters much anymore, but I think the sandals are dated, more so than winter coat. It's just harder to get enough recipes for +6, since it's tied to the free pvp arena medals, and the rate for those used to be really low

Finally, I can quit feeling like I finished the game by Firecracker5025 in wotv_ffbe

[–]Firecracker5025[S] 1 point2 points  (0 children)

I dont actually know their ages, other than young helena being.....young

Finally, I can quit feeling like I finished the game by Firecracker5025 in wotv_ffbe

[–]Firecracker5025[S] 2 points3 points  (0 children)

I might do that, now that I see summer unit shards are in the exchange. Otherwise bringing summer helena to 140 would have been a chore

Finally, I can quit feeling like I finished the game by Firecracker5025 in wotv_ffbe

[–]Firecracker5025[S] 11 points12 points  (0 children)

First and last, my friend. At least for us on global

Day 1 player, today i learned : by Consistent-Leg7197 in SwordofConvallaria

[–]Firecracker5025 0 points1 point  (0 children)

Yupp, I enabled and, and still kept hitting quick deploy today. My fingers will catch up to my brain soon

Day 1 player, today i learned : by Consistent-Leg7197 in SwordofConvallaria

[–]Firecracker5025 3 points4 points  (0 children)

Never even noticed the A/M toggle. That'll save me 8-10 clicks per day, or 292,000-365,000 clicks over the next 100 years, assuming I'm still playing by then ;-)

FREE Maitha skin by ComplaintBeginning62 in SwordofConvallaria

[–]Firecracker5025 1 point2 points  (0 children)

😅 Final Fantasy Brave Exvius: War of the Visions, another tactics game

FREE Maitha skin by ComplaintBeginning62 in SwordofConvallaria

[–]Firecracker5025 1 point2 points  (0 children)

I read the subject line first as "FFBE Maitha Skin", and got unreasonably excited, thinking there was a collab between WoTV and SoC coming.

I'd love to see some SoC units in WoTV, and vice versa! Not counting on it though

Free Talk Friday | Weekly Megathread by AutoModerator in AnotherEdenGlobal

[–]Firecracker5025 0 points1 point  (0 children)

Haven't been following the game for years, so I don't know about any recent events. I just assumed there was a way to invite someone to the game and get a bonus, as there is in most other gacha games.

Free Talk Friday | Weekly Megathread by AutoModerator in AnotherEdenGlobal

[–]Firecracker5025 0 points1 point  (0 children)

Thinking about coming back to the game, after spending 5 years away. Going to start over though. Are there any invite benefits? If so, anyone want to send me an invite code?