SELECT @select_dev

The Snowflake optimization and cost management platform. Follow to hear about our latest Snowflake learnings. select.dev 🇨🇦 & 🇬🇧 Joined July 2022

Tweets

56
Followers

277
Following

5
Likes

12

pei @pei0804

2 years ago

Great Thank you🥰 @NiallWoodward @ianwhitestone @select_dev #SnowflakeSummit #DataCloudSummit

0 3 16 2K 0

View Details

ian.sql @ianwhitestone

2 years ago

uhhh, this query just ran successfully in @SnowflakeDB. LFG. IYKYK

5 5 33 10K 9

1 0 4 700 1

View Details

SELECT @select_dev

2 years ago

increase your dbt thread count, you should

ian.sql @ianwhitestone

2 years ago

Thanks for sharing! Wrote about this in more detail here for those curious: select.dev/posts/snowflak…

1 0 3 1K 2

0 0 0 490 0

View Details

pei @pei0804

3 years ago

SELECT Cloud、3ヶ月ほど運用したので満を持して、事例公開しました。 OSS版も素晴らしいですが、Cloudはもっとすごいので、Snowflakeのコストやパフォーマンスで、お困りの方は、是非チェックしてください🥰 @SnowflakeDB_jp @SnowflakeDB @select_dev

CARTA Engineers @carta_engineers

3 years ago

❄ SELECT Cloud国内初導入！❄ Snowflake使用コストを最大40%最適化 SELECT Cloudについて @pei0804 が導入実績を解説！ > 利用料を40％程度削減できてるワークロードも出てきて、この節約機能だけで、SELECT Cloudの利用料を回収できてしまうレベルのインパクトでした。 techblog.cartaholdings.co.jp/entry/select-c…

0 10 25 16K 3

0 13 41 7K 3

View Details

SELECT @select_dev

3 years ago

We finally got some time to I finally got some time properly reflect on everything @SnowflakeDB announced last week at Summit 2023. Learn about every announcement and our thoughts on each in our latest post👇 select.dev/posts/summit-2…

0 1 4 702 0

View Details

SELECT @select_dev

3 years ago

Back in March we had the opportunity to speak at @datacouncilai in Austin. We had a blast sharing everything we've learned about @SnowflakeDB cost and performance optimization. Slides & recording now available 👇 select.dev/posts/data-cou…

0 0 3 1K 3

View Details

Carlin Eng @carlineng

3 years ago

Geeking out about Snowflake optimization with the @select_dev crew @NiallWoodward and @ianwhitestone. 5/7

2 1 3 587 0

View Details

Julia Schottenstein @j_schottenstein

3 years ago

New @dbt_labs Analytics Engineering Podcast is LIVE🎙️! @jthandy and I sit down with @brad_culberson from @SnowflakeDB and @NiallWoodward from @select_dev to talk about cloud warehouse optimization. Listen for practical advise on a top of mind topic 🧠🫰 open.spotify.com/episode/2j8Djh…

0 2 12 1K 2

View Details

SELECT @select_dev

3 years ago

@toppare beat* 🤦‍♂️ @elonmusk edit button pretty plz

0 0 0 242 0

View Details

SELECT @select_dev

3 years ago

Was about to tweet our latest post but @toppare bet me to it 🏃‍♂️. Thanks for sharing! Curious about when to use CTEs in Snowflake? Read on!

Baran Toppare 🧟‍♂️ @toppare

3 years ago

Another great post from @select_dev about CTEs. Summary: - continue using CTEs 🤘 - specify column names (don't "import" with select *) - for special queries, experiment with repeating logic instead of reusing CTEs - learn how to read query plan select.dev/posts/should-y…

0 0 2 1K 1

2 0 1 390 0

View Details

SELECT @select_dev

3 years ago

select.dev/posts/should-y…

0 0 0 157 0

View Details

Brooklyn Data Co. (a Velir company) @BrooklynData

3 years ago

We're two weeks out from the next Analytics Engineering meetup in London at the @thoughtmachine office. 🙏Big thank you to our friends over @SpectaclesCI and @select_dev for letting us support such a great event! The countdown to grab your seat is on! 👉 bit.ly/3Izk2hj

0 2 1 323 0

View Details

Brooklyn Data Co. (a Velir company) @BrooklynData

3 years ago

🗣️UK friends: The next Analytics Engineering meetup is approaching fast! 🤝We’ve joined forces with @SpectaclesCI and @select_dev in co-hosting this event at @thoughtmachine in London, March 23 at 6pm GMT. Save your seat 👉bit.ly/3Izk2hj

0 1 2 363 0

View Details

SELECT @select_dev

3 years ago

@SnowflakeDB query tags are indeed awesome. We recently covered them in depth for those wondering why and how they should use them: select.dev/posts/snowflak…

Baran Toppare 🧟‍♂️ @toppare

3 years ago

0 0 2 1K 1

1 1 1 324 0

View Details

SELECT @select_dev

3 years ago

⚠️ Unfortunately, this function isn't guaranteed to be deterministic. As a result, it won't be able to leverage Snowflake's result cache, so be careful when using in performance or cost sensitive applications where the query is executed frequently.

1 0 3 357 0

View Details

SELECT @select_dev

3 years ago

More generally, you can use these to find the row containing the min/max value for a particular column, then return the value of another column in that row.

1 0 1 416 0

View Details

SELECT @select_dev

3 years ago

In @SnowflakeDB 's latest release, they've given us a nice new set of aggregate functions: min_by and max_by. In this example I look across each user's query history, and find the ID of the first and last queries they executed.

2 2 16 16K 2

View Details

SELECT @select_dev

3 years ago

All the details are in here 👇 select.dev/posts/snowflak…

0 0 2 179 0

View Details

SELECT @select_dev

3 years ago

Range joins are notoriously slow in many databases. @SnowflakeDB is no exception. We're using a binned range join technique across a number of models in our @getdbt project and have seen incredible results. A 300x speedup for this query.