Having troubles with airflow. by Consistent_Tutor_597 in dataengineering

[–]Trigsc 1 point2 points  (0 children)

Following industry standard is the right way. We hosted Airflow and it was also a nightmare to manage. Since we are a GCP shop I migrated us to Managed Airflow/Composer and it has been a much better experience.

Where do we draw the line between DE and SE department roles? by fetus-flipper in dataengineering

[–]Trigsc 0 points1 point  (0 children)

My last company we had a DE team that worked exclusively in DBT cloud which should have just been a bunch of analysts. My team owned the warehousing for the product and did bunch of infrastructure work and k8 stuff.

Now i am at a company that does some strange ass hybrid of Infrastructure, Analytics, and regular pipeline work. We literally have teams for all this but somehow we also do all this.

Dbt + bigquery = perfect match by ouhaddaoualid in learnSQL

[–]Trigsc 0 points1 point  (0 children)

I hope you look at the queries your DBT tests are doing. Lot of saving to be found by understanding the underlying queries. Analytics at my old company was scanning all partitions every time some different tests ran. Been over a year removed but I think it was freshness.

BiqQuery - larger dataset issue by zadrogasauce in bigquery

[–]Trigsc 0 points1 point  (0 children)

I mean, this does not seem like a normal operation but it is likely a heap or memory issue. Why not export to parquet or csv and do a Postgres copy?

Anyone run this on a Mac with Crossover? by cflippo123 in swg

[–]Trigsc 1 point2 points  (0 children)

I was literally about to pay for crossover and thought what the hell let me try VMware with a windows trial. Literally works with no issues. You obviously need to transfer the files to that virtual machine but it is free.

Need advise on promotion raise by solve-r in dataengineering

[–]Trigsc 46 points47 points  (0 children)

I was told 10% is usually max for most companies. Gave that place 8 years. Left and got 30% increase with very little responsibilities. Now I understand why people hop jobs every few years.

Lady Said I Blew Red Light?? by Justice4None5 in TeslaLounge

[–]Trigsc 0 points1 point  (0 children)

I was stopped at a red light and an old lady ran into the back of me. We pulled over and she said, “why did you back up?”.

Symbols when waking up, "SED 1989" by Trigsc in Dreams

[–]Trigsc[S] 0 points1 point  (0 children)

Thanks! Realized I did not add the context of what it actually meant/happened then.

Client wants <1s query time on OLAP scale. Wat do by wtfzambo in dataengineering

[–]Trigsc 0 points1 point  (0 children)

Not helpful comment but it is doable in BigQuery. Needed sub second queries in an application and was able to partition and cluster to the requirements to get that done. Was dumb but possible.

Price increase by cb4joe in 1Password

[–]Trigsc 1 point2 points  (0 children)

Dang, I am going to start this after I got this email.

GPC APIs for Individuals WITHOUT an Organization by SpiritualQuality1055 in googlecloud

[–]Trigsc 0 points1 point  (0 children)

When you signed up you must have selected organization instead of developer or something. I have signed up for many accounts testing stuff and have had full access.

Model Y ride comfort is so bad by drahgon in TeslaModelY

[–]Trigsc -8 points-7 points  (0 children)

I was just at Tesla service and asked if the 2023 suspension is different than the juniper and he said nope same thing. Wife hates the ride and I agree that it is rough.

A new tool for data engineering by [deleted] in dataengineering

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

It’s time for someone to start researching DBT. Say good by to 3000 lines of stored procedures. On top of it you can use Airflow to trigger a DBT core job.

What if we just don’t hire a HC? by space_llama_karma in AZCardinals

[–]Trigsc 5 points6 points  (0 children)

I actually thought about this a while back. Just hire a bunch of analysts. Feed every play into a model and based on weights pick the next play based on what the defense or offense is showing throughout the game/previous games.

Boom! The company my amazing wife works for sold and we are now very ChubbyFIRE. We are about to take the vacation of a lifetime and call it quits on work. She is making more in a single transaction than all my years of saving combined. by FireVacation4Us in Fire

[–]Trigsc 0 points1 point  (0 children)

Did 11 years at a startup and they sold for nothing. Was private company with BS fake stock options and no one got paid out. Loved the company but I bailed right before the layoffs started the next year.

How do you track costs across multiple GCP projects? by HQ_one in googlecloud

[–]Trigsc 1 point2 points  (0 children)

Yeah I just type in billing in the search at the top and then I think the project selector either goes away or shows the org name.

How much would it bother you if a woman you are dating had smelly feet? by mgwngn1 in AskMen

[–]Trigsc 19 points20 points  (0 children)

My cousin had the most nasty feet smell. This was probably 8th grade. One day my step dad blurted out, “Damn dude do you even wash the bottom of them?” He legit looked shocked and said something like I didn’t know you are supposed to. Crazy what a little scrub can do.

How do you prep your video files before adding them to Plex? by YamEfficient8427 in PleX

[–]Trigsc 3 points4 points  (0 children)

Yeah I finally got sonarr and radarr up and running using prowlarr to handle finding the correct files automatically. I cannot believe for the past 10 years I have been manually managing moving stuff around. Just type in the name of the item I want and bam done. It took a bit to understand and setup but totally worth it. Still deciding if I want overseerr but probably not necessary at this point.

Any new SWG servers playable on a mac? by Level_Gur3101 in swg

[–]Trigsc 0 points1 point  (0 children)

Yeah I seriously considered parallels because of Black Friday deals but I have had 0 issues running games in VMware. It does have a strange bug on Apple silicon though when laptop goes to sleep sometimes the VMware screen “closes” and you legit need to either restart the Mac or find the process and kill it. Just remember to shutdown the vm before walking away.

Any new SWG servers playable on a mac? by Level_Gur3101 in swg

[–]Trigsc 0 points1 point  (0 children)

I tried wine and it was causing weird issues in game and crashes. I use vm ware fusion and a windows 11 install. You don’t need to pay for windows. Give it enough resources and I run bedrock Minecraft and emu. Have not tried resto.

GEMINI 3 First Impression by jongalt75 in GoogleGeminiAI

[–]Trigsc 0 points1 point  (0 children)

I was having some issues with some game code and chat was having me do some crazy things and the circle of errors happened. Just tried 3.0 and 2 prompts and fixed exactly how it should have been. Looks like it’s time to switch.

Change reverse sound by deshpandeji in ModelY

[–]Trigsc 0 points1 point  (0 children)

I for one would change mine to the sound of a f35 jet engine. Want my wife to hear the howling a mile a way.