Hello, I hope you’re well and having a great week!

It’s been a couple of months since we held the ‘Mastering Snowflake Solutions’ book launch, so we thought we’d touch base to let you know how we’re tracking with the fundraising efforts!

I am delighted to tell you that in the first month alone we sold 143 copies of the book, and as promised, I have donated 100% of the royalties received to The Black Dog Institute.

With the funds raised through the Book Launch ticket sales and the royalties, we’ve raised a total of $2770 to date!

It’s a great first month of book sales and we’re excited to keep you updated with his progress as the months go on!

Thanks again for your support and contribution to this great cause, you can keep track of the donation efforts here.

--

--

I don’t know about you but I wasn’t able to travel to Las Vegas for the annual Snowflake Summit recently.

If you were able to be there in person I hope you had a great time and took away some valuable knowledge and new connections!

If not, then I always find it very time consuming to research and keep up to date on all the announcements.

This is why I put together a short video summarising the key announcements and the benefits for you!

Watch the video here!

--

--

User Defined Functions (UDFs in Snowflake)
This concept should be familiar as it’s very similar to other RDBMSs. There are two primary types of functions in Snowflake:

Types of UDF
Scalar function — returns one output value for each input value.

Tabular (table) function — returns a table of zero, one or many rows for each input row.

Supported Functions
Functions can be written in SQL, JavaScript and Java (currently in preview mode). You’ll be typically working with SQL unless you wish to do any branching or looping in your function, this is when you can use JavaScript or Java to provide greater flexibility.

Ready to learn more?
In this video I introduce you to user defined functions in Snowflake. Learn the differences between a scalar and table user defined function and how to apply them to solve real-world problems.

--

--

Mastering Snowflake

Mastering Snowflake

Our mission is to help people trapped in a career dead end, working with on-premise, legacy technology break into cloud computing by using Snowflake.