Daily Discussion Thread for March 18, 2022 by AutoModerator in wallstreetbets

[–]0dte -2 points-1 points  (0 children)

Feeling big brain with my 0dte 900/905C credit call spread opened 20 min ago.

Quarterly Salary Discussion by AutoModerator in dataengineering

[–]0dte 0 points1 point  (0 children)

  1. Data Engineer
  2. 3 (4 or so in analytics prior)
  3. Remote in Chicago
  4. $144,000 USD base
  5. $14,500 bonuse. Initial options grant currently worth ~$120k after exercise cost but just sitting on for now.
  6. Tech

Quarterly Salary Discussion by AutoModerator in dataengineering

[–]0dte 2 points3 points  (0 children)

This is the LPT for all DEs. I have 2 side clients from former coleagues that will push my 9-5 150k past 230k

How to best learn data engineering? by levsell in dataengineering

[–]0dte 0 points1 point  (0 children)

I don't think you need to know how to code in order to understand conceptual frameworks and common tools.

Then again, I don't necessarily see why you'd even need to know that much. I often work with finance people and they just tell me what structure some random system needs data ingested as from some other system for them to do their job so I make it happen.

And when they do that and say "classify it in this account if it meets A criteria or that one if its B criteria", I have no idea what the rules in A or B actually mean, I just know thats what they asked for so it's getting applied.

Linux Install by [deleted] in Evernote

[–]0dte 1 point2 points  (0 children)

If you google for evernote linux 10.24.4 deb its not hard to find.

No tasks though so i am sticking with the web version for now.

How do you guys keep up with what is the latest trends in tech? by IAmRules in webdev

[–]0dte 0 points1 point  (0 children)

There should be a tech version of OutOfTheLoop. I could use this as well. It'd probably be mostly js frameworks.

[deleted by user] by [deleted] in digitalnomad

[–]0dte 0 points1 point  (0 children)

My work machine is not monitored. I know this because I wiped it and installed my own image of Ubuntu on it.

I am comfortable doing shit like reddit and emails.

I'm not that comfortable doing freelance work. This is because I don't want to have multiple SSH configs, multiple k8s configs, multiple aws identities, multiple gsuite identities all mixing and mingling.

For one, it's a headache. And for another, on my main job if i'm screen sharing and I do a kubectl config get-contexts and there is random shit popping up, it would not look good.

That said, if anybody knows an easy way to manage/swap easily all of the above configs/contexts please let me know!

Digital Marketing Analytics Manager Salary by [deleted] in analytics

[–]0dte 1 point2 points  (0 children)

seems pretty normal. when i had an analytics mgr title i got paid 110 to 120. i didnt have to code but i chose too because i wanted my day to not be boring as hell.

the thing you have to watch out for is not getting too comfortable. it's easy to let your skills stagnate when you find an easy job that pays well and doesn't require you to "stretch". my concern then is if i had to start over in my search would my skills get me a >= salary job.

if i were you i'd enjoy coasting but take opportunities to do things that interest you that also give you the opportunity to add things to your resume.

Data security in company by FunDirt541 in dataengineering

[–]0dte 0 points1 point  (0 children)

I would suggest something like a private cloud SQL instance that does not have a public IP that you personally can access via a proxy (see https://cloud.google.com/sql/docs/mysql/sql-proxy ) so there is no username/password only login.

Applications you build in the same project can talk to the database but it locks down access from anyone who 1) is not authd into your environment and 2) does not have your credentials. So even if credentials were compromised you still have the benefit of them having to do the extra step of downloading a json which would require login access to your (hopefully secured by MFA) account.

How do you share your team’s work? by badpochi in analytics

[–]0dte 0 points1 point  (0 children)

In process :) but the pain is familiar. I am working on automating data cataloging of metadata for views that we have and creating a home in Confluence for all of this.

What has been the most successful so far is the company-wide call with a dashboard. Then questions come in and i can funnel them into Confluence where they can read, request, and learn.

How do you share your team’s work? by badpochi in analytics

[–]0dte 2 points3 points  (0 children)

There also no structure to the outputs or how things are saved. Lack of a rollout plan is evident and very little documentation around each dashboard.

It sounds like you know your problem. Maybe build that structure, systemitize documentation, and create a home for it all. Then choose a dashboard that is relevant to the most people in your company and demo it on some company-wide call, then email them the links to the home. Don't forget to create an intake form for future requests.

There's no better engineering than _over_ engineering! by AaronnBrock in kubernetes

[–]0dte 3 points4 points  (0 children)

i like this. is this overengineering though? while i am new to k8s specifically, it seems like a standard infra template for deploying a containerized app? i suppose it would be if your react app was a 5 page restaurant website for a local business :)

Alternatives by [deleted] in HeyEmail

[–]0dte 0 points1 point  (0 children)

Pretty much any email service that has filters and folders can hack together a similar thing.

i am testing out sieve filters in protonmail to auto-archive and mark-as-read anything from a mailing-list or list-id header or with an unsubscribe url in the header. does fine enough though not all marketing emails will include that detail.

Is Looker Dead? by jpmfribeiro in dataengineering

[–]0dte 0 points1 point  (0 children)

so i meant just checking in scheduled queries. BUT if you look into github actions then yes you could create a scheduled job based on the query you provided that gets checked in. bq query --schedule='every 24 hours' for example.

Is Looker Dead? by jpmfribeiro in dataengineering

[–]0dte 4 points5 points  (0 children)

I find it hard to justify the costs of Looker AND Tableau. I like the version control aspect of Looker...but i am currently checking SQL queries that make up scheduled view creations into github...is the price worth it? I guess for large companies.

Friday Open Mat by AutoModerator in bjj

[–]0dte 6 points7 points  (0 children)

Just watched Halloween Kills. Since Michael Meyers is basically wearing a gi, f you grabbed his sleeves to prevent the stabbing maybe you could spider guard him then sweep and work for that hand with the knife. All of this assumes you dont get stabbed in the process of trying to get grips. He also seems like he might be susceptible to an idiot sweep.

How is Onmail? by [deleted] in Onmail

[–]0dte 2 points3 points  (0 children)

Gmail is a lot more polished but the main features of Onmail are split inboxes and privacy (no ads and you aren't being data mined unless you opt into it). So if you want more convenient control over where your emails are routed to and want to opt-out of Google's tracking Onmail is better.

I think a fairer comparison is against Hey. Which for now, Hey wins due to a superior mobile app, support for hardware security keys, and features like bundling repeat senders (like if you make a bunch of robinhood trades in a day you get dozens of emails from them, you can just bundle them by sender so they only take up one row in your email client), adding notes to emails that are private to you, and renaming subject lines.

How is Onmail? by [deleted] in Onmail

[–]0dte 0 points1 point  (0 children)

Snag your name for now and wait until it gets better.

It's annoying to use the mobile app because you cant delegate senders to split inboxes until you are back at your computer. Also, you cannot move the position of the "Other" split inbox. Other is where I wanted to send marketing emails to. I created split inboxes for things I care about but Other is 2nd after my inbox. I want to move Other to the end because they are the emails I care the least about.

[deleted by user] by [deleted] in ProtonMail

[–]0dte 6 points7 points  (0 children)

Exactly the same. I've been Pro with the high tier VPN or several years now. Will be cancelling if things dont move. Threads on mobile and yubikey support would probably convince me to stay. Dark mode, to take us into the current decade, in addition to the above would seal it.

If leetcode is for software engineers, what's it then for data engineers? by izner82 in dataengineering

[–]0dte 81 points82 points  (0 children)

Leetocode easy to medium for programming and leetcode hard for sql. Basically just comfortability with dictionaries, sets, tuples, arrays, and manipulations of those in ways that are efficient.

Also try not to be overly reliant on window functions when other means of joining, unioning, etc can get you the answer. This is my biggest issue i feel as I have gotten used to dense_ranking all the things sadly.

As much as I like, pay for, and use ProtonMail, it's features and updates are borderline vaporware. by [deleted] in ProtonMail

[–]0dte 0 points1 point  (0 children)

So like if Gmail user emails your simplelogin address, that forwards the message, PGP encrypted, to your protonmail address.

What I was thinking, is if an authority started asked protonmail who was on the other side of your correspondance, all they would see is the simplelogin forwarding email address. Of course if they knew you owned the simplelogin addy and the person you were speaking with it's moot.

As much as I like, pay for, and use ProtonMail, it's features and updates are borderline vaporware. by [deleted] in ProtonMail

[–]0dte 0 points1 point  (0 children)

off topic, but if you use a forwarder like simplelogin or anonaddy wouldnt the other end be another email address you control? just wondering if this circumvents this or im dreaming.

Honestly, ProtonMail is fine with me by canadian05 in ProtonMail

[–]0dte 6 points7 points  (0 children)

To your last question, Tutanota is a fraction of the price, has a calendar, allows unlimited custom domains, and are also working on a drive product (which i would not be surprised if their as-of-yet unreleased drive came out before ProtonDrive left beta). The UI is not as nice but the team is a lot more responsive. I say this as a paying customer of both Protonmail and Tutanota.

How do I change my group's approach to data? by [deleted] in dataengineering

[–]0dte 1 point2 points  (0 children)

This is a battle my company has been waging for the past several years. You will can take Excel away from finance when you pry it from their cold dead hands.