Data and data warehouses have gone “off piste” with Snowflake: How can this benefit your business or organisation?
By Venkat Elumalai, Knoware Practice Lead
There used to be a time when setting up a data warehouse involved investing in massive amounts of hardware that was usually sited “on premises”.
Today, data and data warehouses have essentially gone “off piste” thanks to technology and providers like Snowflake.
What is Snowflake?
Snowflake is a cloud-native platform service that can be platformed on AWS, Azure or Google Cloud which does away with the need for maintaining and supporting expensive on premises servers. There’s no software to install, configure, or manage and it is straight -forward and easy to move data into Snowflake using standard ETL solutions.
With Snowflake being built entirely in the cloud, it effectively tackles and resolves many of the issues that hampered traditional hardware-based data warehouses.
Workloads scale independently from one another, making it an ideal platform for data engineering, data transformation, data sharing, developing data applications and managing high query volumes.
Knoware update on the Log4j vulnerability & SAS
A serious vulnerability in a piece of open source software called Log4j was recently discovered and reported.
Log4j is widely used in many software products to standardise logging processes and includes parts of SAS Software (most notably Java components).
If the vulnerability is exploited, then an attacker could execute code on the machine running those exposed SAS processes.
Being highly responsive, SAS quickly released a tool and associated instructions on how to find and patch this vulnerability called Logucinno.
Loguccino remediates the Log4j vulnerabilities CVE-2021-44228 and CVE-2021-45046 within the specified scope of support. SAS recommends that you use Loguccino, where supported, instead of completing manual mitigation or remediation tasks.
If you would prefer Knoware to assist you in implementing this patch for Log4j, then please let us know by contacting us directly via email at email@example.com.
Happy holidays from the team at Knoware
The year 2021 has brought both challenges and possibilities. Benjamin Franklin said, ‘Out of adversity comes opportunity’, and we look forward to working on opportunities with you in 2022.
We wish you all a fabulous holiday break and time in the company of family and friends.
See you in the new year. From the team at Knoware.
Congratulations Janina on becoming a SAS Certified Specialist: Base Programming Using SAS 9.4.
Big congratulations to Janina Stenbo, Knoware Operations Administrator for her achievement in becoming a SAS Certified Specialist: Base Programming Using SAS 9.4.
Base Programming Specialists have passed a performance-based exam where they have demonstrated proficiency in reading and creating data, manipulating data with functions and formats, controlling program flow with loops and conditional statements, creating summary and frequency reports, and identifying and correcting program errors.
As a forward-looking consultancy in full growth mode, Knoware’s team of thought leaders and data and analytics practitioners pride themselves on a culture of supportive excellence and achievement.
Great work Janina, congrats from the whole Knoware team on your certification!
Steve Carline is Knoware’s new Client Account Manager
Steve Carline has joined Knoware in the role of Account Manager bringing his considerable experience of working with customers to provide solutions around data management, data quality and data visualisation technologies across a variety of sectors including government, corporates, charities and education.
COVID-19 Alert Level 1 Message
Knoware is committed to a unified response to fighting the spread of COVID-19 in our communities.
Under both Levels 1 and 2, the Knoware offices will remain open with appropriately applied social distancing restrictions and protective measures.
COVID-19 Message – Level 2
The New Zealand government has announced that from 8th September 2021, that parts of New Zealand including Wellington will step down to level 2.
In light of Government’s position on combating the COVID-19 outbreak, we made the decision to close the Knoware office from Monday 23 March and will be working remotely until further notice.
Our aim is for Knoware to continue to provide the best service we can, particularly across New Zealand government where we are already utilising our extensive hands-on experience and knowledge of data and systems in helping some agencies with COVID-19 related work.
We see ourselves as a logical extension of many analyst teams in the Wellington business community. The wider Knoware team of consultants are all set up to work remotely from home, and most clients are taking up this option especially where additional hands are required to assist in support activities. We do have some resource availability.
The Executive team are always available for you to contact. Details can be found here
We will be replacing face to face meetings with online technology. We’re utilising Microsoft Teams for this but happy to use other means if preferred.
Please be assured we will be here to provide whatever level of service we can for you.
Best wishes and stay safe.