Source: Pixabay

Your customers trust you to protect their privacy and identities — and Snowflake makes this easy with Dynamic Data Masks. With this you can get rid of complex systems of secure views or copies of data: Just create policies that allow everyone to share the same tables and queries, while protecting sensitive data.

Watch on Youtube #SnowflakeBytes

Let’s say your customers are superheroes, and you have a table that contains data about them. You know a lot about your customers, and they trust you to protect their identities and privacy — not only from third parties, but also from people in your company that need this data to do their job, but not all of this:

There’s plenty of research establishing that boards should refresh their members regularly. Let’s see the numbers for the Free Software Foundation, Apache Software Foundation, Python Software Foundation and Open Source Initiative.

Rotation in open source boards: Average # of years served by members

The ASF, PSF, and OSI keep renewing their board members. On average each member serves less than 8 years.

Meanwhile the FSF average # of years served per board members keeps growing — currently >13.83 years. Or more, if the count started before 2001.

Why boards should rotate

The following research articles show why institutions need to keep boards fresh, regardless if they are non-profit or not:

Rotating new board directors into the boardroom and on committees prevents the board from becoming stale. The IRS favors term limits because they believe that static board membership leads to unhealthy attitudes, which can cause boards to…

Eva’s challenge: Produce a new daily visualization with Snowflake and Tableau for 30 days. Let’s check on her progress during her first week of this ongoing challenge.

Visualizing Snowflake’s Marketplace Data in Tableau

Eva Murray is a Tableau Zen master and a leader for #MakeOverMonday — and she just joined Snowflake! She loves data storytelling, and when she found thousands of datasets in the Snowflake Data Marketplace — she decided to take this challenge. We taped a call discussing her first 7 days of visualizations — and you can find it here:

Visualizing Snowflake’s Marketplace Data in Tableau

Let’s check some of her visualizations and my thoughts:

The visualizations

SQL is a great tool, but it can’t do everything. For example, figuring out a way to analyze funnels and sessions with SQL is truly difficult — until now. Let’s discover the power of MATCH_RECOGNIZE(), by analyzing a Google Analytics e-commerce funnel with Snowflake.

Image: Pixabay

Check TJ Murphy’s reaction when he discovered that Snowflake now has support for MATCH_RECOGNIZE:

Sample use case: Google Analytics e-commerce funnel with Snowflake

How would you answer this funnel question with SQL:

“We have an e-commerce shop. We need to identify sessions that land into the website from an arbitrary referrer (Instagram, Facebook, etc), and that end up buying something. How many steps did it take for these users to buy something, and how many times they tried to pay before success?”

That’s not an easy question to answer with plain SQL. But MATCH_RECOGNIZE finally gives us an elegant way to find answers to question like this one.

With MATCH_RECOGNIZE we can simply define the steps we…

The Foursquare Places dataset covers more than 96 million places around the world — including interesting fields like the popularity of each one. In this post we’ll explore the dataset and highlight some of its possibilities.

Watch on youtube

This is a map that shows the most popular type of restaurant for each state around the US, and the pattern is clear — states around the East love pizza, states around the West love Mexican food:

Most popular restaurant type per US state. Image by author

But there are some exceptions:

  • Idaho in the West prefers pizza.
  • Louisiana in the South is all about cajun food.
  • And Maine in the Northeast loves seafood.

To build this map I used the Foursquare Places premium dataset, through the Snowflake Data Marketplace. You can find my queries below.

This dataset includes more than 96 million places from all over…

Starschema shares COVID-19 tracking data in the Snowflake Data Marketplace, including vaccination numbers from JHU and Our World in Data. Find here the basic SQL queries to use this data in your projects.

World ranking

2021–03–11: Few countries have vaccinated more than 4% of their population. Gibraltar and Israel display outstanding numbers at almost 50%. They are followed by Seychelles (27%), Bermuda, Cayman Islands, Bahrain, USA, Serbia, Malta, Faeroe Islands, and Chile (6.64%).

% vaccinated per country, source OurWorldInData through Starschema in Snowflake

What’s interesting about this query:

  • Source is Our World in Data, and Starschema loads and shares this data in Snowflake.
  • The owid_vaccinations table reports interesting statistics like # of daily vaccinations, % of population vaccinated, and the specific vaccines each country is using.
  • To get only the latest day of data we use the qualify row_number()=1 instruction. This is especially important…

The Snowflake Data Marketplace Challenge is open. To win you need to come up with a creative answer to a question, by using data from the Snowflake Data Marketplace. Find here a highlight of the Knoema datasets in Snowflake, then join us in the challenge.

There are four questions that you could answer, each focusing on a different industry: financial services, healthcare, media & entertainment, and retail/CPG. For example, one of the questions is

“As a financial planner, your client has received a stipend of $1 million and has asked you to help them invest in foreign currency. Which currency would you choose and why?”

To answer this question, you should go to your Snowflake account (sign up for a free trial), and explore these Knoema datasets.

Knoema has collected thousands of different public datasets — and you can access them for free in…

Easy to use dynamic pivots in Snowflake: How to use and create a JavaScript stored procedure within.

There’s something about SQL and PIVOTs: Everyone wants to PIVOT their results, but there never seems to be an easy way for it. Fortunately, Snowflake users have a native way to perform pivots in SQL, with the function PIVOT():

select *
from (
select * from table(result_scan(last_query_id(-1)))
for pivot_column in ('Spider-Man', 'Wonder Woman', 'Iron Man'))

With Crunchbase in the Snowflake Data Marketplace you can use SQL to track the world of mergers, acquisitions, IPOs, and the key people behind these stories.

During 2020, more than 500 companies in the data and analytics space were acquired all over the world. Can you guess the top three cities where these companies are based?

Number three is London, number two is New York. And number one is San Francisco, where 33 companies in the data analytics space were acquired in 2020.

More than 100,000 of coders are working out the Advent of Code challenges in their favorite programming languages. What if I could use this opportunity to highlight the power of SQL and the latest Snowflake features?

2020 has been a year full of surprises — one of them being that I left Google and joined Snowflake. Last year I did my first run for #AdventOfCode with SQL, and this year the challenge is helping me get acquainted with a different SQL syntax than the one I was used to with BigQuery.

I’ll leave some notes here on my major discoveries and learnings — while developing my new Snowflake expertise.

Find the full code on Github for these solutions..

Day 1: Multiple joins

The first problem was pretty easy to solve with SQL.

Part 1 took only a cross join…

Felipe Hoffa

Data Cloud Advocate at Snowflake ❄️. Originally from Chile, now in San Francisco and around the world. Previously at Google. Let’s talk data.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store