The Data Warrior

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

Archive for the category “SnowflakeDB”

Adapting Agile Principles for Data Warehousing

Despite the clear benefits of data warehousing programs, business units often question what they perceive to be long delivery timelines and a lack of data accessibility. Nearly half (48%) of the respondents in a TDWI survey reported that personnel in their organizations spend at least 61% of their time finding and preparing data. Only 28% said that their business users and analysts can access and analyze new data, including external data, without close IT support.

Check out how to solve these type of issues, and more, by applying the principles of Agile to data warehousing in my newest post and ebook:

Adapting the Agile Manifesto Principles to Data Warehousing

Cheers.

Kent, The Data Warrior &

Chief Technical Evangelist, Snowflake

Advertisements

5 Business Needs That Fuel Enterprise Data Warehouse Development

The global market for data warehousing is expected to grow to $34.7 billion by 2025, according to a recent report from Allied Market Research. That’s nearly double the $18.6 billion it was worth in 2017.

What fuels investment in enterprise data warehouse development? Cloud data warehouse technology has given rise to innovative systems and practices that increase efficiency and reduce costs across company functions. Today, departments like marketing, finance, and supply chain operations benefit from a modern data warehouse as much as the organization’s engineering and data science teams.

In this blog post, I list five business priorities that fuel increased investment in modern enterprise data warehouse development. See them here on the Snowflake blog site:

5 Business Needs That Fuel Enterprise Data Warehouse Development

And don’t forget to download my newest ebook (free) listed at the end of the post!

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

The Elephant in the Data Lake and Snowflake

So is Hadoop finally dead? For many use cases, I think it really is. The cloud and the continued evolution of technology has created newer, better ways of working with data at scale. Check out what Jeff has to say about it!

Jeffrey Jacobs, Consulting Data Architect, Snowflake SnowPro Core Certified

Let’s talk about the elephant in the data lake, Hadoop, and the constant evolution of technology.

Hadoop, (symbolized by an elephant), was created to handle massive amounts of raw data that were beyond the capabilities of existing database technologies. At its core, Hadoop is simply a distributed file system. There are no restrictions on the types of data files that can be stored, but the primary file contents are structured and semi-structured text. “Data lake” and Hadoop have been largely synonymous, but, as we’ll discuss, it’s time to break that connection with Snowflake’s cloud data warehouse technology.

Hadoop’s infrastructure requires a great deal of system administration, even in cloud managed systems.   Administration tasks include: replication, adding nodes, creating directories and partitions, performance, workload management, data (re-)distribution, etc.  Core security tools are minimal, often requiring add-ons. Disaster recovery is another major headache.  Although Hadoop is considered a “shared nothing” architecture, all…

View original post 809 more words

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: