SELECT

56 posts

SELECT

@select_dev

The Snowflake optimization and cost management platform. Follow to hear about our latest Snowflake learnings.

🇨🇦 & 🇬🇧 Beigetreten Temmuz 2022

5 Folgt277 Follower

SELECT retweetet

pei@pei0804·4 Haz

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

English

1.7K

SELECT@select_dev·6 Mar

Huge if true.

ian.sql@ianwhitestone

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

English

693

SELECT@select_dev·14 Şub

increase your dbt thread count, you should

ian.sql@ianwhitestone

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

English

486

SELECT retweetet

pei@pei0804·29 Kas

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

CARTA Engineers@carta_engineers

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

日本語

6.8K

SELECT@select_dev·6 Tem

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…

English

700

SELECT@select_dev·8 May

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…

English

1.3K

SELECT retweetet

Carlin Eng@carlineng·31 Mar

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

English

586

SELECT retweetet

Julia Schottenstein@j_schottenstein·25 Mar

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…

English

1.3K

SELECT@select_dev·15 Mar

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

English

241

SELECT@select_dev·15 Mar

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

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…

English

389

SELECT@select_dev·15 Mar

select.dev/posts/should-y…

ZXX

156

SELECT retweetet

Brooklyn Data Co. (a Velir company)@BrooklynData·9 Mar

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

English

321

SELECT retweetet

Brooklyn Data Co. (a Velir company)@BrooklynData·20 Şub

🗣️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

English

361

SELECT@select_dev·17 Şub

@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…

English

321

SELECT@select_dev·23 Oca

⚠️ 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.

English

356

SELECT@select_dev·23 Oca

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.

English

415

SELECT@select_dev·23 Oca

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.

English

15.5K

SELECT@select_dev·21 Oca

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

English

178

SELECT@select_dev·21 Oca

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.