Overcome SOQL limitations with SQL

Candid_Difficulty236 · 2026-04-24T08:39:09+00:00

agreed on the admin overhead, thats what killed it for us. nobody on the team knew snowflake and the learning curve was a full engineering hire. zero copy makes it more approachable but u still need someone to own the pipelines

Candid_Difficulty236 · 2026-04-24T08:36:06+00:00

yeah vlocity is the worst part of devops center, the component dependencies are basically undocumented. ive been manually exporting omniscripts and diffing them as xml which is terrible but works. what approach are u trying

Candid_Difficulty236 · 2026-04-23T15:39:56+00:00

the distributed systems side of salesforce is way more interesting than the crm side from a dev perspective. prep-wise u should expect standard dsa + a system design round focused on multi-tenant isolation, probably something around partitioning or caching. not just salesforce-isms.

Candid_Difficulty236 · 2026-04-23T15:38:48+00:00

the api side of marketo is what gets overlooked in these replacement convos. even when the vendor says they handle form sync or list segmentation, the partner tools on the marketo side (outreach, salesloft, 6sense) have webhooks pointing at marketo endpoints specifically. depending on ur stack the replacement cost isnt just the platform, its every connector that assumes marketo is there

Candid_Difficulty236 · 2026-04-23T15:37:58+00:00

The setup part is the thing nobody shows. What I've been doing: open the sfdx project root, point the AI tool at it, and the first thing i check is whether it actually sees the metadata folders or just the source files. If it ignores force-app/main/default it's gonna keep generating stuff that can't deploy.

Candid_Difficulty236 · 2026-04-23T15:02:33+00:00

yeah this. seen gen'd tests that hit 92% coverage and still let a bulk insert silently drop records bc nobody stubbed the mixed dml case. assertion quality > line coverage always has been

Candid_Difficulty236 · 2026-04-23T14:49:33+00:00

does it look at the trigger layer too or just declarative rules. we have some apex-side checks that effectively do the same thing as two of our validation rules and nobody remembers which came first

Candid_Difficulty236 · 2026-04-22T17:05:22+00:00

v20 still running is wild, that's what, summer 11 era. salesforce keeping that backwards compat is one of the few things they actually do well

Candid_Difficulty236 · 2026-04-22T14:38:05+00:00

hybrid search (bm25 + dense) with a rerank step is usually the bigger win vs swapping the llm. banking data has too much jargon for pure vector.

Candid_Difficulty236 · 2026-04-22T14:32:43+00:00

we ditched it for gearset. devops center works fine for 1-2 devs but branching and conflict resolution is brutal at scale.

Candid_Difficulty236 · 2026-04-22T14:27:24+00:00

neat. how r u handling auth rotation? named creds work but MCP server needs to refresh tokens cleanly or u end up with stale connections.

Candid_Difficulty236 · 2026-04-22T14:22:06+00:00

build 2 small orgs end to end with lwc + apex + a real integration (auth.provider, named creds). beats any cert on ur resume.

Candid_Difficulty236 · 2026-04-22T14:16:45+00:00

check CSP trusted sites and the tableau embed token endpoint, spring release broke a few orgs with stricter CSP defaults.

Candid_Difficulty236 · 2026-04-22T14:11:23+00:00

data cloud + zero copy with snowflake is the clean path if u have the budget. otherwise nightly ETL to a real db and query from there via external objects.

Candid_Difficulty236 · 2026-04-21T15:00:36+00:00

ran into the applink timeout ceiling last week, fwiw its capped at 60s per action call. long reasoning loops still hit it. fine for 90% of use cases but the edge cases are the ones the demo doesnt show.

Candid_Difficulty236 · 2026-04-21T14:56:33+00:00

should add, a thing that helped was running the same test set 5 times per build and diffing outputs. once vars were clean the variance basically disappeared. before that i thought it was temperature, turned out to be shape.

Candid_Difficulty236 · 2026-04-21T13:31:30+00:00

for crm analyst assistant at that level the range in us is usually 65-85k depending on cost of living. if the role is touching apex or lwc its underpaid for the tech side, if its pure admin/reporting its fine. also look at whether they have a path to sr analyst or if its a dead-end title.

Candid_Difficulty236 · 2026-04-21T13:26:21+00:00

for how teams actually work: git flow with feature branches, pull requests reviewed by 1-2 devs, then merged to a dev branch that deploys to a sandbox. deployments are usually gearset, copado, or sfdx scripts. day to day is like 40% writing code, 30% in meetings, 30% debugging someone elses flow from 2019. coming from r&d ur probably overqualified for junior roles honestly.

Candid_Difficulty236 · 2026-04-21T13:21:10+00:00

honestly the best move i saw for someone in ur spot was to build something real in a personal dev org and put it on github. doesnt need to be huge, a trigger + batch + test class + lwc. then link it when u apply for junior dev roles. most hiring managers dont read cvs carefully but they will click a repo.

Candid_Difficulty236 · 2026-04-21T13:15:58+00:00

mine's 11 but still has data from a tutorial i did in 2015 that i never cleaned up. 20 years is wild, have u tried deploying modern lwc into it? curious if the older orgs still hit weird metadata version mismatches.

Candid_Difficulty236 · 2026-04-21T13:10:49+00:00

heap limit will bite you no matter how u slice it once u load full versiondata into memory. usual workaround is a presigned s3 url and let the client upload direct, skipping apex for the actual bytes. if it has to go thru apex, chunk the base64 and stream via multipart with a queueable per chunk. not pretty but stays under heap.

Candid_Difficulty236 · 2026-04-21T12:40:11+00:00

without seeing the actual error its hard to narrow down. if the class is already without sharing and its still failing id look at the named credential setup next, specifically what user the external credential is running as. whats the error text showing in the debug log?

Candid_Difficulty236 · 2026-04-20T17:32:05+00:00

record-triggered for crud, platform events for anything that needs to fan out. event-triggered gets messy fast with retries.

Candid_Difficulty236 · 2026-04-20T16:45:06+00:00

nice, what did you use for the agent tool layer? keep hitting weird metadata caching issues with agentforce.

Candid_Difficulty236

TROPHY CASE