Daanalytics

Snowflake GROUP BY Data Heroes

Wednesday 15 July 2020, I had the privilege to present at the first online Snowflake ❄️ GROUP BY Data Heroes online event. For me personally a great opportunity to get more involved into the Snowflake Community. A fantastic chance to help others and myself to get better.

Special thanks to Angelica ColemanElsa Mayer and Kent Graziano for the organisation and the support.

“GROUP BY is an opportunity for data practitioners around the world to come together virtually and learn how some of the most engaged users are leveraging Snowflake. Dive deep into use cases, participate in workshops, and discuss popular Snowflake features with our amazing Data Heroes.”

Angelica Coleman — Intoduction

Kent Graziano — Data Hero — Opening remarks

In his opening remarks, Kent emphasised the importance of giving back to the community, the basis for the GROUP BY event. Kent has done this all his life and it brought him a lot, bot professionally as wel as socially.

Benoit Dageville — Supreme Data Wizard — Opening remarks

Focus on ease and simplicity of using the product. Mission Statement every organization should be able to be Data Driven. Every decision and every activity should be based on Data.

Welcome to the Data Cloud

All data should be available in one single place in one platform. All kinds of data types; Structured and Semi Structured. Non-Structured to follow. No limits. Also direct access to data you do not own; Data Sharing.

Any workload. No scale-limit.

One Single Global platform, Cross-Region and Cross-Cloud (AWS, Azure and Google)

“If you like Snowflake today, you will love Snowflake tomorrow”

Benoit stated the importance of the global Snowflake Community.

Slim Baltagi — Data Hero — Snowflake Features to Drive Your Business Forward

Five Stages of the Business Lifecycle, linked to Snowflake:

  1. Launch — High Upfront Costs -DwaaS and Pay-as-you-Go
  2. Growth — Rapid increasing demand –
  3. Shakeout –
  4. Maturity — New revenues like the Market Place or things like Advanced Analytics
  5. Renewal / Decline — Innovation — Experiment with e.g. Data Applications

Unfortunately (it was a live show after all) we were not able to hear part of Slim’s presentation.

Daan Bakboord — Data Hero — How to execute the T in ELT

Check out my presentation on Noti.st.

Randy Pitcher — Data Hero — Streams and Tasks

Randy introduced us with a Hands-on Lab into Snowflake Streams and Tasks. Check out his Lab-details on Github.

Sonny Rivera — Data Hero — Data meets BBQ

Sonny gave us a quick BBQ workshop based on IOT-data. Where did BBQ’ing and Data meet? Understand the Business challenge. Bring the Business and e.g. Data Engineers together. Experience day-to-day challenges in the Business. Augmenting Intelligence to improve your BBQ skills. Enterprise Tools to store and Visualize data and add Weather Data via the Snowflake Exchange. Collaboration is key. Automation. Start in the Cloud.

“Get involved into the local Snowflake Community. Help others to get better and yourself”

Stephanie Stillman — Data Sharing & Data Exchange

Stephany demos some of the really cool features of Snowflake; Data Sharing. She also shows how Snowflake practices what it preaches because the Snowflake Data Exchange is built on Data Sharing functionality.

Lenny Fishler — Data Hero — How Snowflake with Monge Change Streams drives Real Time BI

Lenny shows how he streames Mongo changes into Snowflake

  • Mongo Change Streams
  • AWS S3
  • Snowpipe Auto Ingestion
  • Snowflake Streams & Tasks

Joyce Avila — Super Data Hero — What a Snowflake Certification can do for you

Joyce explains what education and certication can do for you, both from a Business-, and an IT perspective. There are various training and certification paths available and more to come:

Elsa Mayer — Closing Remarks

Please share your feedback!

Check out the Snowflake Discussion Groups Become a Snowflake Data Hero

Please get into contact with me if you want to know more about Snowflake or need help with the implementation of Snowflake in your organisation.

Cheers,

Daan Bakboord

Bekijk ook:

Amsterdam User Group Meeting October 2024

Snowflake Dutch User Group – October 2024

Last night I had the privilege to organize a Snowflake ❄️ User Group in Snowflake’s Amsterdam Office.

Johan van der Kooij shared his experiences regarding optimizing Snowflake from a cost & performance perspective. He shared practical hints, as well as example queries, that you can use to optimize your Snowflake environment.

Lees verder »
Snowflake Data Cloud Summit - Wrap Up

Snowflake Snowflake Data Cloud Summit — Wrap Up

Snowflake Data Cloud Summit proved that after all this years the core idea remains the same and is still strong. Technology should serve and Snowflake makes things simple. One Single Unified Platform, one product and one engine. Ease of use and Govenance. Maximum efficiency and maximum simplicity.

Bring the processing of data to the data instead of the other way around. Snowflake as a Platform where you build and share your Data, Apps and AI Products. Your data never has to leave the Platform and Snowflake takes care of this Platform.

Lees verder »
Snowflake Data Cloud Summit - Day II

Snowflake Data Cloud Summit – Day II

The second day of Snowflake Summit in the Moscone Center in San Francisco started with Platform Keynote packed with announcements and demo’s. The announcements were not necessarily completely new, but a continuation of things Snowflake was already working on. Lot’s of Developments and Previews have made it to GA status and are now Generally Available to the public. A few announcements were made as wel.

This blogpost a summarization of my notes with were possible a link to Snowflake publications or documentation.

Lees verder »