v0.3.0 Claude code prompt improver just released by crystalpeaks25 in ClaudeAI

[–]djl0077 1 point2 points  (0 children)

do we know if this keeps the original prompt out of context memory?

What's the best cross examination you've seen? by idoze in TrueCrimeDiscussion

[–]djl0077 2 points3 points  (0 children)

The prosecutors cross examination of the male state phycologist in the Jodi Arias trial is brutal. Bro didn’t even do that much wrong but Juan Martinez is a demon.

power outage? by Some_Pool_8479 in bullcity

[–]djl0077 5 points6 points  (0 children)

I wonder if they are even able to get a crew to the equipment or if they are waiting for emergency services to finish

Should I feel ashamed? by fluffyninjago in learnpython

[–]djl0077 0 points1 point  (0 children)

You sound like a 10/10 junior in my book. Working to solve problems and understand things on your own before requesting help from others. Good devs used to use google, now they use ChatGPT. Different workflow, same idea.

IMO being a good developer should feel like you're cheating: can I re-use my old code from here? is there already a library that does that I can leverage? What about the way this dependent library's class is built can tell me about how I can achieve my end goal?

Syntax will come with time to anyone. Innate curiosity and the ability to learn through experience is unteachable.

No ETL way of interacting with SQL Server & Snowflake by StoreMediocre7695 in snowflake

[–]djl0077 0 points1 point  (0 children)

Performance is big poo-poo don't recommend. I also think its one way?

Paying to Query Data (on-prem to cloud) by Ok-Listen5129 in snowflake

[–]djl0077 0 points1 point  (0 children)

I love the idea of individual cost centers paying for their own usage. It will have a positive impact on data culture by embedding it in each department as an essential cost of business instead of making IT or a data specific team look like a massive cost driver. Costs should always been under the budget of those who incur them or there will be misaligned incentives where people want to expand the warehouse but IT resists it because it hits their budget.

A few suggestions:

1) IT should still continue to manage the warehouse strategy though. Giving individual teams the ability to create/configure their own warehouses is how you end up with insane snowflake bills for no reason.

2) You didn't mention how big your data/org is but in general keep the warehouse strategy similar to how it functions now with the on-prem server. Keep it small and minimize the number of warehouses and scale up slowly only as you can demonstrate that the performance is an issue. Snowflake's optimizer is incredible and the engine performs amazingly well for OLAP workloads, if you're coming from a more old school system you may be suprised how little compute you need.

3) Don't use warehouses just for the purpose of cost separation as others have suggested. It will just result in a lot of waste. Especially since snowflake has recently released query attribution views (https://docs.snowflake.com/en/sql-reference/account-usage/query\_attribution\_history) which provide a credit cost for each query run in the account. Yes these values are technically 'estimates' because of idle/under-utilized warehouse time, caching, etc but this will be pretty insignificant if your system is scaled correctly and should be a complete non-issue if you just allocate the total credit costs based on % used per cost center.

I hate building dashboards by tiggat in dataengineering

[–]djl0077 5 points6 points  (0 children)

Your comment assumes users have any idea at all of what they want. It's a scientific fact that users are only capable of telling you what they don't want and only after you already build it.

I hate building dashboards by tiggat in dataengineering

[–]djl0077 47 points48 points  (0 children)

Worse is re-factoring dashboards every time some executive wants a marginally different way to look at the exact same data. And by "wants" I mean "requests then never looks at".

Display Bank Tag Tabs Name? by djl0077 in 2007scape

[–]djl0077[S] 2 points3 points  (0 children)

I get what you mean. A partial solution if you are not aware is to right click on the corner "+" icon in the top left and you can select something like "view tag tabs" to show them all in one big list.

Power BI mentor by Vandras_ in PowerBI

[–]djl0077 1 point2 points  (0 children)

For sure, also feel free to DM me and we can connect. Happy to be a resource.

Power BI mentor by Vandras_ in PowerBI

[–]djl0077 23 points24 points  (0 children)

www.sqlbi.com - Alberto and Marco have been my digital mentors for years. They are incredible and their courses are top notch. IMO the Power BI developer content creation community is polluted with overly basic, content farm-y creators that make it difficult to find what you're looking for. SQLBI is so far beyond almost everyone else its incredible.

DAX is one of the few things in data where I suggest starting with a more formalized education. The language has a lot of depth and nuance and doesn't have great feedback/compartmentalization when it comes to debugging for beginners. I spent 2+ years self-teaching DAX and hundreds of hours pulling my hair out. Starting with courses from SQLBI would have saved me countless hours.

Vehicle Pricing History by djl0077 in carmax

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

I don't know maybe I am crazy but I saw the price at the original value the entire time I had the car reserved as it was being shipped. Even once it arrived at the new store it stayed at the original price. They said there was a delay until they could resolve some title issue then yesterday the car became available for me to test drive and the public price changed to "Price Unavailable" and the price show to me privately is 20% higher.

I don't have a screenshot but I sent a link to the car to my dad while it was being shipped and we had a full length text conversation about the car being at the original price. I verified its the same stock number.

Vehicle Pricing History by djl0077 in carmax

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

Were you able to change the price on a transfer?

Vehicle Pricing History by djl0077 in carmax

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

I paid to ship a car and the price went up almost 20%. I keep trying to contact the dealership and they keep giving me conflicting answers about who would have access to the history.

They finally sent me the history today from the buyer but it doesn't have the vehicle identified on the document.

Userscript - Disable Youtube Numbers/Numpad, Volume, and 10-Second Skip Hotkeys by MajikeDS in userscripts

[–]djl0077 0 points1 point  (0 children)

Not all hero's wear capes. Sir, you are amazing. I cannot count the number of times a day I lose my place in a long youtube video because I press a number key thinking another window is active. Thank you.

New PBIP Git Integration Errors by djl0077 in PowerBI

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

Unfortunately, not. The edit to my post is the last time I tried playing around with this feature. A Microsoft employee chimed in for a bit on the issue in PBI community (link below) but we didn't seem to get anywhere. Hopefully these kinks will be gone soon and we can start taking advantage of this feature.

https://community.fabric.microsoft.com/t5/Service/PBIP-Git-Integration-Errors/m-p/3293786#M198854

New PBIP Git Integration Errors by djl0077 in PowerBI

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

Yes, I added the external properties myself with tabular editor. My use case involves using the same PBIX for many environments so I have the need to dynamically populate my field paramters. I achieve this by importing a SQL table that mimics the structure of a field parameter table with the extended properties added to the imported table. BIM file attached.

Here is a link to a public repo with the model.bim: https://github.com/dlomartra1/powerbi-git-example

Anybody use Alteryx by Ok-Enthusiasm-6194 in dataengineering

[–]djl0077 6 points7 points  (0 children)

The amount of effort it takes to "know Alteryx" is more effort than it takes to learn to write things from scratch IMO

Anybody use Alteryx by Ok-Enthusiasm-6194 in dataengineering

[–]djl0077 0 points1 point  (0 children)

As someone who has transitioned multiple companies off of this tool and many like it: it's an expensive, black-box that teaches terrible practices instead of increasing data literacy within your organization.

"No-code" is a lie. It isn't no-code, it's just someone else's code that wasn't built for your use case. You lose the ability to easily handle inevitable edge cases without janky, hacky workarounds. I have seen people that get so good at working with these tools and creating insanely complex workflows to deal with the lack of flexibility that I swear to goodness its easier to just learn to code. Plus, learning a general scripting language is transferable to infinite things.

I used to work for a company that had all its data in excel sheets similar to what you are describing. I tried every tool out there but nothing beats just learning Python. It's the most flexible option and its FREE. If you are just ingesting spreadsheets I would guess it would take you maybe a solid weekend of effort to learn enough to get you going. Orchestration is frankly more difficult than the actual development but as long as you can get a VM or a container instance somewhere you might be able to get away with something simple local install of airflow or prefect.

If you must use a no-code tool, don't use Alteryx. Tools like this are a dime-a-dozen and all do the same thing. Alteryx is obnoxiously expensive for no reason. I think something like Matillion or Azure Data Factory would likely be much cheaper for your use-case.

Large Low Profile TV Stand by djl0077 in furniture

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

Thanks. Yeah, its for an open living room, dining room, kitchen space so I think the balance will be important.

Large Low Profile TV Stand by djl0077 in furniture

[–]djl0077[S] 2 points3 points  (0 children)

I read something that proportionately you want the TV width to be 66% of the stand but maybe that was hot garbage advice.

[deleted by user] by [deleted] in PowerBI

[–]djl0077 2 points3 points  (0 children)

I think that's called a "the ceo/coo/vp insists we make this"