The Data Warrior

Changing the world, one data model at a time. How can I help you?

Archive for the tag “@SnowflakeDB”

Tips for Optimizing the #DataVault Architecture on #Snowflake

Data Vault is an architectural approach that includes a specific data model design pattern and methodology developed specifically to support a modern, agile approach to building an enterprise data warehouse and analytics repository.

Typical Data Vault Design with Hubs, Sats, and a Link

Snowflake Cloud Data Platform was built to be design pattern agnostic. That means you can use it with equal efficiency 3NF models, dimensional (star) schemas, DV, or any hybrid you might have.Snowflake supports DV designs and handles several DV design variations very well with excellent performance.

This series of blog posts will present some tips and recommendations that have evolved over the last few years for implementing a DV-style warehouse in Snowflake.

Here is the first set of tips:Tips for Optimizing the Data Vault Architecture on Snowflake (part 1)

I hope you find this helpful!

Kent

The Data Warrior and Chief Technical Evangelist for Snowflake

Around the World with the #DataWarrior

Yup I traveled a lot in 2019. Mostly in my role as Chief Technical Evangelist for Snowflake, but some for family vacations (yes I do take those!).

Inspired by good friend Jeff Smith, here is my travel report based on Google location services. Surprisingly accurate (should I be concerned?).

While traveling this much can be taxing (especially on my family), it is a blessing to be able to see all these wonderful places and meet lots of wonderful people as part of my job at Snowflake, even if it means being a #RoadWarrior.

By The Numbers

  • 174 miles on foot!
    • There are more miles when I did not have my phone
    • This includes a great hike with my family all the way from Waikiki Beach to the top of Diamond Head and then back.
  • 2 miles by bike – I know that was in Berlin using an Uber Bike (a very neat and useful concept)
  • 14,450 miles by mass transit (cars, trains)
  • And then a lot more air miles!

Wow. That adds up to 7 times around the world for an estimated 173,475 miles! Yikes.

In 2019 I got to explore both countries and cities I had never been to before, as well as some fo my old favorites.

New Locales:

In the “never been here before” category:

  • Stockholm, Sweden – first time ever to Sweden! Even in January it was quite fun with lots of sites to see including the Viking Museum.
Vikings!
  • Berlin, Germany
  • Dublin, Ireland – actually got to go there twice!
  • Madrid, Spain
  • Lisbon, Portugal – LOVED the seafood!
Amazing fresh, cheap, seafood in Lisbon
  • Hannover, Germany
  • Stuttgart, Germany
  • Zurich, Switzerland
  • Australia & New Zealand – I had two separate 2 week trips down under and got to see quite a bit, plus catch up with some old friends I had not seen in over 20 years.
    • Sydney (2x)
    • Melbourne (2x)
    • Canberra
    • Brisbane
    • Auckland (2x)
  • Cleveland, Ohio – yup, never been there before. Managed a visit to the Rock and Roll Hall of Fame (with Jeff Smith).
  • Costa Mesa, California

Old Favorites

I did manage to also visit places in the US where I have bene before like Dallas, Miami, Ft Lauderdale, Orlando, Santa Monica, Philadelphia, Honolulu (vacation), and Stowe (Vermont). I had LOTS of trips to San Francisco and San Mateo (where Snowflake HQ is located).

Outside the US, I got the pleasure of return visits to Rome (which I LOVE LOVE LOVE), Milan, London (2x), Amsterdam (2x), Utrecht (2x), Helsinki (Finland), and at the end of the year, a trip to snowy Montreal in Canada.

Me and Caeser in Rome
The Colosseum, Rome
Panini in Rome! What is Italia without food, gelato, and vino?

Where to next?

So where will I go in 2020? Stay tuned. The adventure continues…

Sailing on an America’s Cup boat in Auckland, NZ

Happy New Year 2020!

Kent

The Data (and Road) Warrior

P.S. One place I will be for sure in June is the Aria Hotel in Las Vegas where we will be hosting the 2nd Annual Snowflake Summit. We do expect it to SELL OUT again this year. Super Early Bird registration closes January 30th, so get your registration in today!

New Snowflake Community Advocate Program

I am happy to announce that The Snowflake Community—a hub for Snowflake users to connect, share, and learn from each other both offline and online—is launching a new program called the Select Star Program.

What is a Select Star?

The Select Star program recognizes and rewards our most engaged community members who go above and beyond to help other users around the globe. The program offers many opportunities, including speaking at meetups or during webinars, publishing technical tutorials and blog posts, answering questions on Stack Overflow, and sharing your own Snowflake story with the community. The more you engage and offer support, the more award points you’ll earn. Once you’ve collected 1,000 points, we’ll officially accept you into the Select Star program.

Get the rest of the details and how to sign up here: 4 Ways to Become a Snowflake Select Star

Cio for now.

Kent

The Data Warrior

How to manage GDPR compliance with Snowflake’s Time Travel and Disaster Recovery 

One year after implementation, the European Union’s General Data Protection Regulation (GDPR) continues to be a hot regulatory topic. As organizations work to bring their data practices into compliance with the new law, one question comes up repeatedly: How does Snowflake, the data warehouse built for the cloud, enable my organization to be GDPR compliant?

Check out my latest post to see my answer:

How to manage GDPR compliance with Snowflake’s Time Travel and Disaster Recovery | Snowflake Blog

Cheers!

Kent

The Data Warrior

Automatic Clustering, Materialized Views and Automatic Maintenance in Snowflake 

Boy are things going bananas at Snowflake these days. The really big news a few weeks back was another round of funding! This time we got another $450 million.

A-MAZ-ING!

We are gaining marketshare everyday with name brands signing up in droves. I am constantly taken aback by the names I see on our win-wire. In my role as evangelist, I am getting to speak with folks at places like Sony, NBC Universal, and CapitalOne to name a few. Not only here in the US but over in EMEA as well (as my frequent flyer status will attest). And early next year I will be heading out to Australia and New Zealand too (stay tuned for details).

As exciting as all that is (#ILoveMyJob), even more exciting is how our engineering team is putting all that funding $$ to use to continue to improve what is already the leading cloud-built data warehouse. This week we announced two new major features.

From today, two new automation and performance capabilities are available in Snowflake. They are the latest advancements to Snowflake’s ability to deliver the best performance and scalability without requiring administration or maintenance from our customers. They also lay the foundation for a series of new features to come in the months ahead.

Read all the details here: Automatic Clustering, Materialized Views & Automatic Maintenance in Snowflake

After reading up on these features, head on over to our site and sign up fro your FREE trial account to see for yourself how awesome, and easy, moving to the cloud can be.

Make it snow!

Kent

Chief Technical Evangelist, Snowflake

The Data Warrior

Post Navigation

%d bloggers like this: