Should you consider adopting a cloud data warehouse

information-age.com | January 13, 2020

Both the data lake and the data warehouse within the cloud have their benefits. While data lakes consist of unorganised lagoons without categories, they are great for data scientists to analyse different kinds of data at once.The two kinds of data storage also differ in the tools that can be accessed.In general, for the likes of Redshift, Snowflake, Azure, SQL Data Warehouse, one of the most important things when you talk about a data warehouse is the accessibility to the tools that are available today and that people are familiar with,” said SnapLogic CTO Craig Stewart.This can be something like Microstrategy or Tableau, or something like AWS Insights or Microsoft Power BI, all of which can talk SQL to that data store.That’s really what differentiates the data warehouse from the data lake. The accessibility to those tools, as well as the query ability in that SQL form makes it democratised so that anybody who can use SQL can use those things, whereas if you were talking about a data lake, you have a much more diverse set of capabilities, the API’s to deal with the files like Parquet, etcetera. That’s much more wide open, and generally tends to require much deeper knowledge.

Spotlight

Cloud services have transformed the IT landscape and several cloud platforms have become mainstream alternatives to hosting IT infrastructure in traditional data centers. With numerous public cloud options available, many business technology deployment architectures have evolved to include multiple cloud services as part of an overall cloud strategy. This approach has resulted in a MultiCloud paradigm that introduces challenges around making IT services highly available and resilient.


Other News

Dom Nicastro | April 03, 2020

Read More

Dom Nicastro | April 03, 2020

Read More

Dom Nicastro | April 03, 2020

Read More

Dom Nicastro | April 03, 2020

Read More

Spotlight

Cloud services have transformed the IT landscape and several cloud platforms have become mainstream alternatives to hosting IT infrastructure in traditional data centers. With numerous public cloud options available, many business technology deployment architectures have evolved to include multiple cloud services as part of an overall cloud strategy. This approach has resulted in a MultiCloud paradigm that introduces challenges around making IT services highly available and resilient.

Resources