The Snowflake optimization and cost management platform. Follow to hear about our latest Snowflake learnings.
Joined July 2022
- Tweets 56
- Following 5
- Followers 277
- Likes 12
11 Photos and videos
3
16
1,681
6 Mar 2024
Huge if true.
1
4
701
14 Feb 2024
increase your dbt thread count, you should
14 Feb 2024
Thanks for sharing!
Wrote about this in more detail here for those curious: select.dev/posts/snowflake-d…
490
SELECT Cloud、3ヶ月ほど運用したので満を持して、事例公開しました。
OSS版も素晴らしいですが、Cloudはもっとすごいので、Snowflakeのコストやパフォーマンスで、お困りの方は、是非チェックしてください🥰
@SnowflakeDB_jp @SnowflakeDB @select_dev
29 Nov 2023
❄ SELECT Cloud国内初導入！❄
Snowflake使用コストを最大40%最適化
SELECT Cloudについて @pei0804
が導入実績を解説！
> 利用料を40％程度削減できてるワークロードも出てきて、この節約機能だけで、SELECT Cloudの利用料を回収できてしまうレベルのインパクトでした。
techblog.cartaholdings.co.jp…
13
41
6,768
5 Jul 2023
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-2023
1
4
702
8 May 2023
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-counci…
3
1,280
SELECT retweeted
30 Mar 2023
Geeking out about Snowflake optimization with the @select_dev crew @NiallWoodward and @ianwhitestone. 5/7
2
1
3
587
SELECT retweeted
24 Mar 2023
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/2j8…
2
12
1,266
15 Mar 2023
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!
15 Mar 2023
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-you-…
2
1
390
SELECT retweeted
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
2
1
323
SELECT retweeted
20 Feb 2023
🗣️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
1
2
363
23 Jan 2023
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
15,529
23 Jan 2023
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
1
416
23 Jan 2023
⚠️ 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
3
357
21 Jan 2023
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.
1
1
6
562
23 Dec 2022
As of Tuesday, users now have programatic access to all the query performance statistics available in the Query Profile. This is possible through a brand new function, get_query_operator_stats. You can run this function on one query_id at a time:
3
1
11
1,471
23 Dec 2022
Similar to the Query Profile, data is only retained for queries run in the last 14 days. If you want this to stick around for longer, you’ll have to persist it with a scheduled Snowflake job.
1
1
268
23 Dec 2022
We'll be diving deeper into this functionality and sharing some sample queries in the coming weeks. For now, you can read the:
- Original announcement post: snowflake.com/blog/programma…
- Snowflake docs: docs.snowflake.com/en/sql-re…
- Our post on the Query Profile: select.dev/posts/snowflake-q…
2
233