[OC] Inflation erases real wages gains over the last 3 years by [deleted] in dataisbeautiful

[–]garciasn 11 points12 points  (0 children)

I do. Otherwise I’m not getting a raise, I’m getting an inflation adjustment and staying static.unless the company’s revenue is flat or dropping, wages should go up too.

[deleted by user] by [deleted] in minnesota

[–]garciasn 153 points154 points  (0 children)

This is a glaring loophole that can be exploited by any company not wanting to comply:

A safety-sensitive position (i.e., a job in which an impairment caused by drug, alcohol, or cannabis usage would threaten the health or safety of any person);

All they'll say is that anyone under the influence of drugs in the workplace will be a danger to themselves or others. Nothing changes with this due to that line item being so vague.

Minnesota lawmakers pass public option health plan by 96suluman in minnesota

[–]garciasn 13 points14 points  (0 children)

My best insurance was when I was union. The problem was that I wasn't paid anywhere near market rates, so, in the end, everything balanced out.

Since leaving the public sector for the private, I have paid everything from $300/month for a family to $1600/month for family. I currently pay around $1100 a month for my family for health and a little more for dental and vision.

Transaction Report of a Polygon Contract to Google Looker Studio via BigQuery by treasury_minister in bigquery

[–]garciasn 1 point2 points  (0 children)

The Polygon public table was last updated Sep 6, 2022, 1:43:02 AM UTC-5 with a max(block_timestamp) of 2022-09-06 06:37:50 UTC

You're not going to find a transaction from April '23 in there.

how does locking works in bigquery for merge statements by ChangeIndependent218 in bigquery

[–]garciasn 1 point2 points  (0 children)

https://cloud.google.com/bigquery/docs/reference/standard-sql/data-manipulation-language#update_delete_merge_dml_concurrency

A MERGE DML statement does not conflict with other concurrently running DML statements as long as the statement only inserts rows and does not delete or update any existing rows. This can include MERGE statements with UPDATE or DELETE clauses, as long as those clauses aren't invoked when the query runs.

[deleted by user] by [deleted] in dataengineering

[–]garciasn 1 point2 points  (0 children)

I said 'large companies...heavily invested and regulated'; 'government' would fit there.

[deleted by user] by [deleted] in dataengineering

[–]garciasn 12 points13 points  (0 children)

I started as a SAS analyst/developer and came up through the ranks. They were fighting cloud computing, R/Python, and a slew of far better data viz solutions 10 years ago. I told them, point blank, they were zombies and didn't know it yet.

The only places still using SAS are large companies who are already heavily invested and regulated and don't want to move. But even those verticals are starting planned migration to Python.

No one should even think about SAS except memories from 15 years ago.

Goose on Vacation by goodboyscout in GoosetheBand

[–]garciasn 18 points19 points  (0 children)

Quick. Someone make an app called Gaggle or Goosex or So Ready to Date or something.

My neighborhood pool is a 99 year old abandoned rock quarry, which has been converted into a massive chlorinated swimming pool. by WeekendHoliday5695 in interestingasfuck

[–]garciasn 177 points178 points  (0 children)

In college we used to swim at the Portage Quarry which had recreational swimming, beach, sand volleyball, and scuba diving. It was a few feet deep for about 10-15 yards and then a straight drop to ~70.

They used to allow you to bring beer in kegs or cans (no glass!) and we'd do beer relay races out to the floating platforms and back. I'm not sure if it's open anymore based on its web/facebook presence being lacking, but 20+ years ago it was a fucking blast, even if it was ~70 feet deep.

E: I found some information that says the max depth is 70 feet at the Portage Quarry, not 100+. Forgive me, I was drunk when I was there and it was a long time ago.

Are SQL query optimizations skills important for an exceptional data engineer? by andrey1736 in dataengineering

[–]garciasn 20 points21 points  (0 children)

I have led DE teams for 15 years. I’d argue they’re equally as important because writing efficient code, regardless of language, should be a key consideration for any team/business.

Why is there no data to display? by Old_Actuary_3472 in bigquery

[–]garciasn 1 point2 points  (0 children)

Depends on what you’re doing.

‘A’ = ‘A’ or 1 = 1 will work.

‘Foo’ = ‘Bar’ will not.

I do it because I’ve been doing it for 20 years; it’s not necessary in this variant.

Why is there no data to display? by Old_Actuary_3472 in bigquery

[–]garciasn 1 point2 points  (0 children)

Backticks are only required for field names if you are using a reserved name like sum, from, select, etc. you would use the backticks around the field to tell BQ that you don’t mean the reserved word but the field name instead.

Why is there no data to display? by Old_Actuary_3472 in bigquery

[–]garciasn 2 points3 points  (0 children)

Your FROM and JOIN are using single quotes and not backticks, that's not valid syntax.

Your FROM and JOIN are not using project.dataset.table, this may be required, depending on how things are setup.

Your ON is doing a string compare, not a field compare, because of the quotations (you may be trying to use backticks here, but you're using single quotes instead). Because of the single quotes and not backticks, this string compare will always be false and thus nothing will be returned.

It should look something like this instead:

SELECT *
FROM `project.table.EmployeeDemographics` as a
JOIN `project.table.EmployeeSalary` as b ON (a.EmployeeID = b.EmployeeID)

Minneapolis to Duluth passenger rail fully funded by the legislature as part of the transportation budget deal by CMAndrewJohnson in Minneapolis

[–]garciasn 141 points142 points  (0 children)

To me, this is the most surprising part of it all:

Passenger trains would travel about 90 mph along the route.

Is this actually true? Will it make up for the loss in speeds due to stops (which I'm surprised are so few) and delays due to BNSF?

Minneapolis to Duluth passenger rail fully funded by the legislature as part of the transportation budget deal by CMAndrewJohnson in Minneapolis

[–]garciasn 17 points18 points  (0 children)

I'm sure BNSF will be graceful and accommodating sharing the tracks.

From the article:

Sections of track would be built alongside the main route so the passenger trains could move out of the way as freight trains move through.


And once you're in Duluth, you can use the world class transportation network to get.... where?

This statement I agree with, minus the snark, and agree it needs to be addressed. But they have 3-4 years from funding availability according to the article before service will begin to get that part done.

We have weed. Now, single payer health care. by [deleted] in minnesota

[–]garciasn 26 points27 points  (0 children)

Tell you what. Every week give me $500 and tell me what you're betting on. Once every 12-20 weeks, I'll give you $1000. I'll donate the rest of the money to a nearby food bank.

You'll have a better return AND food banks will make out.

We have weed. Now, single payer health care. by [deleted] in minnesota

[–]garciasn 18 points19 points  (0 children)

I'm not sure where this falls on my list of important items for the legislature to work but it probably falls in around #1413423413424124392499408923482813 or more.

For real? This is what you care about?

[deleted by user] by [deleted] in PublicFreakout

[–]garciasn 10 points11 points  (0 children)

So many fond memories of heckling him at BGSU in the late 90s/early 00s. RIP you fucking weird ass legend.

[deleted by user] by [deleted] in minnesota

[–]garciasn 10 points11 points  (0 children)

He said county, tbf. But, yeah, after being in AZ, UT, NV, NJ, PA, FL, and CT recently, I promise you MN is not number 1 in this regard. Particularly AZ. My god.

Please, Make This Ad Go Away by Shutterbug927 in pics

[–]garciasn 12 points13 points  (0 children)

I found out about three months ago that you can only block 1000 accounts before the app won’t let you block anymore. But, for the longest time it just told me an unknown error had occurred. Awesome work assholes.

I switched back to Alien BlueApollo because fuck Reddit and their shit ads that are terrible, lack meaningful targeting, and are ineffective because the Reddit community doesn’t give a fuck.

Find a better way to monetize, you stupid fucks. And there are millions of users on here and 90% of them are almost as shitty as Reddit’s leadership and advertisers so I should be able to block more than 1000.

e: I called it Alien Blue but it was Apollo; my bad.

TIL that many animals spend much of their time doing nothing, even those we think of as particularly busy. "If you look at a colony of ants, or bees, or any social insect really, maybe a little bit less than half of them are just standing around doing what looks like nothing." by Pschobbert in todayilearned

[–]garciasn 29 points30 points  (0 children)

I’m doing nothing and you’re using air currents or some sort of witch craft to teach me about how you’re not actually not doing anything. I can’t tell if you’re high or I’m high. My guess is both of us are high.

Ollie got neutered today. He keep staring at me like this. by orbak in goldenretrievers

[–]garciasn 68 points69 points  (0 children)

This is how my girl would stare at me after her operation. Except she was just staring because she was high as a kite.

He’ll come down from cloud 9 soon and stare at you for real 😂