The idea of putting Data Warehouses in the cloud has been around for a while now. However, until now there, there hasn’t really been much difference between many of the cloud data engineering offerings and what is achievable with on-premises equipment.
This has all changed thanks to the solution from Snowflake. Unlike other platforms, Snowflake has built their offering to be a Cloud Data Warehouse from the very beginning. This means that they have been able to deal with a lot of the issues that other “Big Data Storage” tools have struggled with in the past, such as;
- Accommodating vast amounts of data
- Providing the fast processing speed needed for quick responses
- Providing access to the large amount of storage needed
- Level of administration support needed for indexing, tuning or partitioning
Snowflake’s response to this was to make a product that is very fast and handles huge data volumes. Users are given the ability to scale the computing resource up and down, both manually and automatically in response to peaks and troughs in demand. As the cherry on the top, customers only pay for the storage and compute that they use.
The virtues of Snowflake don’t stop there. In order to make their solution as versatile as possible, it uses the SQL language throughout so all existing tools will work with it – both ETL system for data transformation and load plus all reporting tools for user analysis and queries.
As well as normal “structured” data, Snowflake also handles “semi-structured” data in formats such as json and XML. This makes it easy to use and allows it to perform “big data” queries with minimal hassle. Plus, as it is SQL-based, it means that no new tools are needed, and the users can still use their existing BI for querying.
[km-cta-block block-classes=”has-dark-teal-background-colour has-white-colour” label=”Contact us to discuss your requirements”]
Want to know more?
Our data experts would love to hear from you
[km_button link=”https://www.dufrain.co.uk/contact/” classes=”cta-2″]Contact us[/km_button] or [km_button link=”tel:08001303656″ classes=”cta-2″]Call us on 0800 130 3656[/km_button][/km-cta-block]
Some of the interesting additional features that Snowflake offers are…
- Encryption – All data is encrypted, both at rest and in-flight
- Simultaneous Data Loading – Data can be queried while new data is being loaded
- Simultaneous Users – Unlimited number of users
- Data Loading – Both bulk data loading in batches and continuous data loading is supported
- Time Travel – Data that has previously been deleted or updated can still be queried (for up to 90 days)
- Built-In High Availability – Data is transparently replicated as it is ingested
- Built-In Disaster Recovery – Automated data backups
As a Snowflake partner, Dufrain is delighted to work with the Snowflake cloud data warehouse solution. Dufrain can help you with:
- Snowflake POCs (Proofs of Concept)
- Snowflake Data Warehousing
- Snowflake Dimensional Modelling
- Snowflake Batch Data Ingestion
- Snowflake Streaming Data Ingestion
- Snowflake Integration with Reporting Tools
- Snowflake Connection with ETL Tools
[km-cta-block padding=20 block-classes=”has-dark-teal-background-colour has-white-colour” label=”Contact us to discuss your requirements”]
Find out which approach works best for your data
Our data experts would love to hear from you
[km_button link=”https://www.dufrain.co.uk/contact/” classes=”cta-2″]Contact us[/km_button] or [km_button link=”tel:08001303656″ classes=”cta-2″]Call us on 0800 130 3656[/km_button][/km-cta-block]