SELECT

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

[pei @pei0804]

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

[SELECT @select_dev]

Huge if true.

[ian.sql @ianwhitestone]

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

IYKYK

[SELECT @select_dev]

increase your dbt thread count, you should

[ian.sql @ianwhitestone]

Thanks for sharing!

Wrote about this in more detail here for those curious: https://t.co/rkiYjv4bQW

[pei @pei0804]

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

[SELECT @select_dev]

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👇

https://t.co/unKXEGP4bk

[SELECT @select_dev]

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 👇

https://t.co/33hm57TVW2

[Carlin Eng @carlineng]

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

[Julia Schottenstein @j_schottenstein]

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 🧠🫰

https://t.co/753DEYrm4z

[SELECT @select_dev]

@toppare beat* 🤦‍♂️

@elonmusk edit button pretty plz

[SELECT @select_dev]

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
https://t.co/vSGXwhLt6v

[SELECT @select_dev]

https://t.co/7jfSeSH4Mn

[Brooklyn Data Co. (a Velir company) @BrooklynData]

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! 👉 https://t.co/LzGBI7t8lQ

[Brooklyn Data Co. (a Velir company) @BrooklynData]

🗣️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 👉https://t.co/dSyHDHWYMZ

[SELECT @select_dev]

@SnowflakeDB query tags are indeed awesome. We recently covered them in depth for those wondering why and how they should use them: https://t.co/c6CpcaZSSq

[SELECT @select_dev]

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

[SELECT @select_dev]

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.

[SELECT @select_dev]

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.

[SELECT @select_dev]

All the details are in here 👇
https://t.co/RlhIkkbzje

[SELECT @select_dev]

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.

[SELECT @select_dev]

@SnowflakeDB All I want for🎄is a 7-XL