ryanwaldorf

10 ms·

1.
by ryanwaldorf 2y ago
Oh that's really interesting! I imagine there could be a reason for it, for instance the data is distributed differently in the micropartitions so different where values could result in different data lookup patterns as you may skip m
2.
by ryanwaldorf 2y ago
Really interesting! Could you clarify what difference having two different query_parameterized_hash for similar queries is? Is there a performance hit?
3.
by ryanwaldorf 2y ago
Totally agree. In my last job I was able to create my own ETL jobs as a PM to get data for my own analyses and figured out a fairly minor configuration change could save us $10M per year. It was from one of many random ETL jobs I created
4.
by ryanwaldorf 2y ago
What motivated this: I kept hitting token limits when working with Claude on tasks with many parts. For instance, Claude would recommend three different areas of code to work on, but by the time I started on the second area, I'd get t
5.
Show HN: Open-source extension to fork Claude chats preserving context and files(chromewebstore.google.com)
4 points by ryanwaldorf 2y ago|1 comments
6.
Show HN: Easily Upload Files to Claude Projects(github.com)
1 points by ryanwaldorf 2y ago|1 comments
7.
by ryanwaldorf 2y ago
I've really enjoyed using Claude projects to help generate code drafts. However, one thing that's been painful is uploading new files versions after changes. I'd have to separately go through each folder in my project to up
8.
by ryanwaldorf 2y ago
just replied to chrisjc that I created a branch with externalbrowser auth and pushed it to github. would you mind taking a look and letting me know if it works for you? would love to get your feedback as I don't have SSO set up in my
9.
by ryanwaldorf 2y ago
I just pushed the external_browser branch to github that should offer 1/ externalbrowser authentication and 2/ the ability to use TOML files with profiles with instructions on how in the readme. if you run the following you shoul
10.
by ryanwaldorf 2y ago
This makes sense, thank you!
11.
by ryanwaldorf 2y ago
Ah gotcha! Do you have a use case where you'd look to remodel/transform the data between warehouses?
12.
by ryanwaldorf 2y ago
Thank you! Will take a look at this over the next few days
13.
by ryanwaldorf 2y ago
Would that be to support SSO? If so, I haven't planned it yet but I could. Would that make this more useful to you?
14.
by ryanwaldorf 2y ago
That's really interesting! Could you tell me a bit more of what you're thinking? I'm not the most familiar with SQL Mesh and the typical workflows there.
15.
by ryanwaldorf 2y ago
I wanted to start with duckdb since it's really an incredibly powerful tool that people should try out. The performance you can get on analytical queries running on your local compute is just really impressive. And with snowflake str
16.
Show HN: Melchi – Open-Source Snowflake to DuckDB Replication with CDC Support(github.com)
7 points by ryanwaldorf 2y ago|17 comments
17.
by ryanwaldorf 2y ago
Played with this and it did a great job of creating the initial framework for my most-recent react app based on a few paragraphs of text. Would recommend trying it out
18.
by ryanwaldorf 2y ago
You can download one of the NZ government's Annual Enterprise Surveys here: https://www.stats.govt.nz/large-datasets/csv-files-for-downl... . Then simply go to the Excel to SQL tab ( https://sqlgenerator
19.
by ryanwaldorf 2y ago
What's the benefit of this approach?
20.
by ryanwaldorf 2y ago
Cool site! What are the main use cases for this?
21.
Show HN: SQL Generator – OS React App for SQL Table/Insert Statement Generation(github.com)
12 points by ryanwaldorf 2y ago|3 comments
22.
by ryanwaldorf 2y ago
Why were folks concerned about the transaction logs?
23.
by ryanwaldorf 2y ago
Fair callouts. For the first version I was looking to solve the basic use case of "I've downloaded a standard CSV from one database and I want to ingest it into another". I'll look at adding the ability to handle non-s
24.
by ryanwaldorf 2y ago
It's helpful for the ones that don't have this yet like Redshift (for full disclosure I'm a PM there). If your system does have this already though you probably just want to use that.
25.
by ryanwaldorf 2y ago
Yup that's exactly it. This is an ease-of-use option for when you need to ingest somewhat small amounts of data into another database for joining. For large amounts of data, copying the CSV via a copy command should be your best bet.
26.
Show HN: Turn CSV Files into SQL Statements for Quick Database Transfers(github.com)
13 points by ryanwaldorf 2y ago|15 comments