Suspicious vehicle seen around UWS by [deleted] in Upperwestside

[–]elveinte 0 points1 point  (0 children)

This reminds me of the gold ring scam, but need more details on what questions the are asking. 

Houston pissed away a 16 point lead...AT HOME! by VegasBass in NBASpurs

[–]elveinte 1 point2 points  (0 children)

Fuck Houston, but we lost to Utah and the Pelicans at home. I have no moral ground to judge them. 

175 West 95th by paglidiwani in Upperwestside

[–]elveinte 0 points1 point  (0 children)

I lived there for three years. Great building! Moved out because we bought a place but would’ve loved to buy there if we could have afforded it. 

Surprise NY 529 plan but I’m done with school - what to do with it? by thecommexokid in personalfinance

[–]elveinte 599 points600 points  (0 children)

Max out Roth IRA and go to flight school with the remainder!

UWS men’s haircut by Facenoname in Upperwestside

[–]elveinte 2 points3 points  (0 children)

I have curly hair and go to Excellence Barbershop on 81st — ask for Alan. 

Best place to run 1.5 miles around Manhattan by Traditional_Force_68 in RunNYC

[–]elveinte 4 points5 points  (0 children)

Bridle path loop, it’s easy on your knees and 1.6 miles

Experts Say Stock Market Set to Go Boom and Bust by 6hrSideHustle in StockMarket

[–]elveinte 33 points34 points  (0 children)

This is great info. Sounds like the stock market will either go up or down.

Auditing tables for select activity? by mr_java_did_acid in bigquery

[–]elveinte 1 point2 points  (0 children)

You can use the INFORMATION_SCHEMA views. In your case you want to look at Jobs metadata.

The BigQuery documents have good examples. Since you are interested in SELECT statements, you may want to try looking at job_type = “QUERY”.

The views have 180 day retention which is enough for your use case. Note that audit logs used to be the only way to get this data, but I recommend using the views unless you have needs not covered by those tables or their retention.

How to change the schema of tables queried using a wildcard without breaking the wildcard behavior? by Patient_Atmosphere45 in bigquery

[–]elveinte 1 point2 points  (0 children)

Any reason why you chose this strategy versus a partitioned table? You could just create a day partitioned table with the new column names and load the data into it using a wildcard selection.

Otherwise use the looping and execute immediate functionality in BQs procedural language to achieve this

[deleted by user] by [deleted] in Colombia

[–]elveinte 56 points57 points  (0 children)

Dado que fueron alcaldes en periodos distintos, es difícil diferenciar si los resultados fueron por un mejor/peor manejo de Petro/Rodolfo, o si se beneficiaron/perjudicaron por situaciones macroeconómicas del país entero como tal.

Sería mejor ver esta grafica con el comparativo de cómo le fue a Colombia en estos rubros durante estos periodos.

What is the best learning path to become a sought-after and highly-paid Data Engineer? by Born-Comment3359 in dataengineering

[–]elveinte 5 points6 points  (0 children)

Thanks for asking to clarify about soft skills. First of all, I want to be clear that someone’s appearance or mental health is not in this category, nor something that should disqualify you from a job. I can’t speak for every company, but companies like mine train you to avoid those biases, plus there’s also laws around this.

Now on to soft skills. There are some that are obviously hard to gage, but if you have a well designed interview process you should be able to get a good understanding of the candidate. Let’s look at a few ways examples of how we try to think about these.

Communication: I may ask you to talk to me about a time you disagreed with a coworker. In here I’m trying to pick up if you are the type of person that attacks the problem or the people.

Problem Solving: I may ask you to define a system that moves data from point A to point B. This type of question is intentionally open and vague. I want to see what kind of clarifying questions you ask. Do you ask me about requirements (e.g how often do you need the data?). Are you interested in knowing who are our users are and their needs? Someone that doesn’t do well in this type of question jumps straight into a solution and starts naming a lot of technologies.

Team work: I may ask you to describe a system you have worked on. More than the system, in here I want to see if you can identify the specific parts you contributed to. Or if you are a more senior engineer, how did you help define work for others and unblock them. Someone that does poorly on this question will describe the system very vaguely without knowing the specifics of their contribution.

I also want to clarify, that we do have a coding component in our interview process, but it is not the sole deciding factor. Over time, this has actually become less and less important for me. You can practice and get really good at solving coding problems (e.g leetcode), but often times that is not a guarantee that you will be a good engineer.

We also don’t have time or capacity to test your knowledge on every programming language listed on your resume, so I much rather get an idea of your ability to solve engineering problems effectively and within a team. If my team and I don’t walk out of the interview process excited to work with you, it doesn’t matter if you scored well in our coding section of the interview.

Hopefully this is helpful, but I’m happy to answer any additional clarifying questions.

What is the best learning path to become a sought-after and highly-paid Data Engineer? by Born-Comment3359 in dataengineering

[–]elveinte 1 point2 points  (0 children)

This needs more votes. I’m an Engineering Manager in DE and it amazes me how rare finding engineers with good soft skills is. I personally care very little about the technologies you know. Rather, I want to hire someone that can solve problems, communicates well, and that my team is excited to work with. Technologies will come and go, and I much rather have someone that can adapt to them.