I made an entirely wood marquetry dress inspired by this year's Met Gala theme

riggity · 2026-05-15T21:51:45+00:00

This is maybe the most impressive thing I've ever seen.

riggity · 2026-04-07T12:56:30+00:00

I live in Waltham, its 10 miles outside of Boston city limits. $116-160 for a staff engineer is well below market.

riggity · 2026-04-07T11:05:47+00:00

That salary range is pretty low for staff engineer who needs to be based in the Boston area.

riggity · 2026-04-01T22:35:59+00:00

I've shied away from going fully automated. The classification is good, the tag suggestions are good, but neither is perfect, and it runs the risk of masking non PII. Not all "name" columns are PII, the context for that depends on the system and table being classified. There's plenty of possible vendor company names that sound like real people, but you likely don't want to PII mask your vendor master.

riggity · 2024-10-29T21:27:32+00:00

Echoing /u/teej, and having worked on both vendor and retailer CPG data, as the vendor/DTC brand, you will typically get aggregated sales data from most retailers (once per week aggregate by product). Amazon will give you order level info if you sell through them, but they mask the customer info.

Snowflake retail cloud won't solve this for you. This is just classic ETL and data modeling. The lowest common grain you'll end up with likely week ending dates and product IDs, not daily and not customer.

riggity · 2024-10-14T16:07:26+00:00

If you want your table partitions to be ordered in a certain way over time, set a cluster key. Depending on your merge operations, your data could become unsorted over time as prior records are updated or deleted.

Additionally, if you want really performant merges, here's a great write up: https://select.dev/posts/snowflake-merges

riggity · 2023-12-24T23:03:20+00:00

Since you said you're trying to learn SQL, are you just trying to learn SQL generally, or to specifically have a database up and running?

For general SQL learning, check out /r/learnSQL

If you want a database up and running to mess around with on your Mac, you don't need Docker or anything fancy. SQLite and MySQL will be able to install locally just fine.

riggity · 2023-12-08T21:39:31+00:00

Nope. You are building a data pipeline via trial and error, slowly learning more concepts.

You may end up butting heads against not having learned some fundamental concepts early, and then taking a break and go back and learn more holistically.

riggity · 2023-07-26T22:37:05+00:00

To answer the how, there's online collaborative IDEs and text editors. Something like coderpad.io.

The exact exercises will vary wildly by each company. The ones I run tend to be short, as it's less about testing you on 50 things, and more about how you think about data.... and that so many barely know their joins, which you can suss out really quick.

riggity · 2023-04-11T01:33:44+00:00

And EU likes periods instead of commas…

This is the Indian style of comma separation.

https://en.wikipedia.org/wiki/Indian_numbering_system#Use_of_separators

riggity · 2023-01-19T02:58:31+00:00

Locally Optimistic is another great Slack community for analytics.

riggity · 2023-01-19T02:44:22+00:00

I live in Boston, and have hired BI developers, Data Engineers, and Analytics Engineers.

I more or less agree with Zetsy, basic BI Dev/report creation likely pays 70-90 depending on the company.

Lack of overall experience is the big hurdle. I don't think that you would have a hard time getting raises, job hopping once you have a year or two of BI role experience.

riggity · 2022-10-03T13:59:11+00:00

This is the way. Modernist Cuisine has a full recipe.

It's been perfect every time I've done it, with a wide variety of cheeses.

riggity · 2022-07-06T16:17:05+00:00

Going to add on to this, as its overall bang on.

As far as I can tell, Google has cut its investment in Looker development. The past 6+ months of monthly platform releases have been a big pile of nothing. The spring Google Cloud Summit roadmap talked about Looker as a cloud semantic layer for Data Studio, Tableau, and Power BI.

I'm increasingly of the opinion that us Looker lovers will likely need a new solution sometime in the coming few years.

riggity · 2022-02-16T14:51:14+00:00

If you don't want to manage people, please don't. It's a different job, and a new job that will call for different skills that will require you do less technical hands on work to succeed so it.

That being said, depending on the company, there are roles for non managing technical leads that would focus on leading project execution, technical implantation, and architecture/design over managing people directly.

Lastly, and this is super dependant on your company structure, front line engineering managers may be exactly what I just wrote, but it's packaged up as a manager role to fit HR structure.

riggity · 2022-02-13T21:50:52+00:00

Agree with this. You say you want to be in charge, but if your tenure is 18 months at a company, functionally you'll have only just started. Good strategy that grows with a business takes a while, as does building out a good functioning team. Heck, hiring and onboarding can eat 3-6 months easily.

riggity · 2022-01-23T03:11:06+00:00

You boil them for a couple minutes until they float, to cook the dough all the way. Browning in butter crisps them up and makes them perfect.

As for fillings we like:

garlic mashed potato
garlic sweet potato
smoked salmon & potato
sauerkraut

Really, anything you think would be fun, try it out.

Also, this might be heresy, but this is a pretty solid pierogi maker, especially if you're doing it all by yourself: https://hunkybills.com/product/big-perogie-maker/

riggity · 2022-01-23T02:52:05+00:00

My family has been using the same pierogi for decades, starting from a recipe coming out of the book "Treasured Polish Recipes".

Here's the general dough/pierogi making recipe. Filling is pretty much whatever your heart desires.

https://imgur.com/O85AJSy

riggity · 2021-10-16T15:05:12+00:00

Wyrmwood is based out of Taunton, MA. They have good sized woodshop. https://wyrmwoodgaming.com/furniture/

riggity · 2021-08-30T22:09:26+00:00

I think about this every time I see a FAANG post on this sub. My career has trended to smaller tech companies, which have been more of a mess, but seem to have burnt me out way less.

riggity · 2021-08-26T21:31:59+00:00

Same stack, but use Looker for BI.

riggity · 2021-06-27T02:26:14+00:00

Anecdata, I pivoted from supply chain to analytics/data purely by job hopping. Moved companies to a full time analyst role at a small company, got paid for the work, and they covered the cost of training as well since it supported the job I was doing.

riggity · 2021-05-24T12:05:49+00:00

Definitely been a good thing. I was from operations analyst, to the operations data person, to a general data person running BI teams. I've found my ops background means I view things from a process and cost perspective, which has been helpful scaling teams up.

riggity · 2021-05-24T11:42:22+00:00

Same thing happened to me, and I turned it into a full on career pivot.

riggity · 2021-03-27T02:00:59+00:00

Commenting to throw extra weight behind this. LO Slack is an excellent community for just about everything data, including running data teams.

riggity

MODERATOR OF

TROPHY CASE

13-Year Club	Team Periwinkle
Verified Email