AI-powered search & chat for Data / Computer Science Students

Snowflake — First concepts

 Analytics Vidhya

Snowflake is an analytical DW (Data Warehouse) considered as a SaaS (Software as a Service) that provides a data warehouse that has some advantages, such as that the user doesn’t need to manage any…

Read more at Analytics Vidhya

Getting Started with Snowflake ❄️

 Towards Data Science

Whether you’ve heard of Snowflake Inc. from its record-breaking IPO this September, or from its ever-growing presence in data job ads, there is definitely a lot of hype around this company at the…

Read more at Towards Data Science

7 reasons snowflake might not be the right option

 Level Up Coding

The data warehouse is a key component of any organization’s IT strategy, serving as the central repository for all data. It is generally considered to be an expensive component to deploy and…

Read more at Level Up Coding

Snowflake and Dask

 Towards Data Science

Snowflake is the most popular data warehouse among our Saturn users. This article will cover efficient ways to load Snowflake data into Dask so you can do non-sql operations (think machine learning)…

Read more at Towards Data Science

What You Can Do With Snowflake

 Level Up Coding

Snowflake is a popular cloud-based data storage and analytics service. Personally, when I examine new technologies and products, I would like to have a summary of the most important features. This…

Read more at Level Up Coding

Why You Need To Know Snowflake As A Data Scientist

 Towards Data Science

Maybe you heard of this name somewhere but still are not sure what exactly Snowflake does as a data warehouse and what makes it different compared to other platforms. I just started knowing more…

Read more at Towards Data Science

Revolutionary features of Snowflake that sets it apart — A Deep dive

 Towards Data Science

Lately, I got the chance to attend Snowflake summit in Sydney. I learnt a few things and thought to try it on the actual data. Tentative at first but after using it on 40GB of data, I realized there…

Read more at Towards Data Science

Snowflake with Spark

 Analytics Vidhya

Snowflake is a cloud-based SQL data warehouse that focuses on a great performance, zero-tuning, diversity of data sources, and security. The Snowflake Connector for Spark enables using Snowflake as…

Read more at Analytics Vidhya

Data Analysis with Snowflake

 Analytics Vidhya

Example using Snowflake Database to load NOAA weather data staged in a cloud storage bucket. Data cleaning in SQL and authenticating Snowflake to external cloud storage bucket.

Read more at Analytics Vidhya

Using Snowflake? Don’t Make These Expensive Mistakes

 Level Up Coding

Since the beginning of (database) times, databases have always been there for us, up 24/7, eagerly waiting to serve the next query. I am pretty sure that if we were to add all the database idle time…

Read more at Level Up Coding

Car buying is fun with Snowflake

 Analytics Vidhya

Like everyone else, I found car buying process complex and time consuming. Mainly so because one has to visit many dealer’s website for inventory to look for the perfect car with all the desired…

Read more at Analytics Vidhya

Implementing Snowflake Algorithm in Golang

 Better Programming

Snowflake in action Photo by Aaron Burden on Unsplash The background of the snowflake algorithm is, of course, the demand for unique ID generation in the high concurrency environment of Twitter. Than...

Read more at Better Programming

Accessing Snowflake with R

 R-bloggers

Snowflake is a well known cloud-based database. It’s used for Data Warehouses and other big data applications. In this article and the following ones I want to show how to setup and access a snowflake...

Read more at R-bloggers

Terraforming Snowflake

 Analytics Vidhya

Snowflake is a managed cloud data warehouse solution. It is similar to BigQuery or Redshift, but has some unique features like separation of compute and storage and strong support for semi-structured…...

Read more at Analytics Vidhya

Intelligent computing in Snowflake

 Towards Data Science

In a little over a week, I’m heading over to Snowflake’s inaugural user summit in San Francisco, where I’ll be speaking on data sharing in the Australian Private Health Insurance industry. Not only…

Read more at Towards Data Science

Snowflake DARK Mode

 Towards Data Science

I’ve been tinkering with the Snowflake Data Warehouse for a while now. I think it is the best data warehouse on the market at the moment considering it’s performance, scalability and other unique and…...

Read more at Towards Data Science

Car buying is fun with Snowflake Part 3

 Analytics Vidhya

In part 2, entire pipeline to ingest data into Snowflake was automated using Azure Logic App and SnowPipe. JSON Data was loaded in Snowflake landing table with a single 1 column called JSON_DATA…

Read more at Analytics Vidhya

Machine Learning on Snowflake

 Towards Data Science

Snowflake is one of the leading data platforms out there. In this article, we will explore the capabilities of its’ snowpark Python library Photo by Aaron Burden on Unsplash Throughout this article, ...

Read more at Towards Data Science

5 Things to Know Before Using Snowflake’s Native Data Classification

 Towards Data Science

Get the lowdown on Snowflake’s PII detection feature Photo by AbsolutVision on Unsplash In today’s world, data collection and processing are regulated and organizations have no choice but to comply w...

Read more at Towards Data Science

Snowflake Best Practices for Users, Roles, and Permissions

 Towards Data Science

A guide to setting up your data warehouse the right way Continue reading on Towards Data Science

Read more at Towards Data Science

Everything You Need to Know About Snowflake Parameters (Part 2)

 Towards Data Science

In the first part of this two-part series, you learned how Snowflake parameters worked. In this final part, learn about the important ones.

Read more at Towards Data Science

Cooking with Snowflake

 Towards Data Science

Simple recipes & instant gratification on your Data Warehouse Generated using Midjourney (paid subscription) The Snowflake community is rife with information dumps on how to optimize expensive querie...

Read more at Towards Data Science

Is Snowflake a Data Warehouse for Analytics and Insights?

 Better Programming

There’s an important difference between the analytics terms “virtual warehouse” and “data warehouse.” Here’s what you need to know Continue reading on Better Programming

Read more at Better Programming

Using Machine Learning Models to make Prediction directly from Snowflake

 Towards Data Science

Often, we are faced with the scenarios (and myself recently), where the model which was deployed by the data scientist runs on a schedule and whether that’s once an hour, once a day, or once a…

Read more at Towards Data Science