Snowflake
Snowflake is an advanced data
platform that is provided to you
as a self-managed service.
Snowflake’s data platform
brings together data storage,
processing, and analytic
solutions that are faster, easier
to use, and more flexible than
traditional offerings. It offers full
enterprise analytic database
functionality, and unique
features and capabilities.
Features
- Security, Governance and Data Protection
- Standard and Extended SQL Support
- Tools and Interfaces
- Connectivity
- Data Import and Export
- Data Sharing
- Database Replication and Failover
- Snowflake Cortex AI Features - Agents, Analyst, Copilot and more.
- ML Functions
- See https://docs.snowflake.com/e n/user-guide/intro-supportedfeatures.html
Benefits
- AI features for writing SQL queries, understanding data and databases
- Choose the location your data is stored with enhanced authentication.
- Standard and Extended SQL Support
- A broad ecosystem of partners and client connectors and drivers
- Support for bulk loading/unloading of data and continuous loading
- Support for securely sharing data with other Snowflake accounts
- Support for replicating/syncing for organization continuity and disaster recovery
- Near-unlimited scalability and concurrency
- Streamlined data pipelines
- No SRE/DevOps burden - allowing launch of new features faster
Pricing
Service documents
Request an accessible format
Framework
G-Cloud 15
Service ID
1 0 3 1 5 5 8 9 1 9 5 5 8 2 8
Contact
VIZIFY ANALYTICS LTD
Tim Archer
Telephone: 07824468046
Email: tim.archer@vizify.co.uk
About the service
- Service categories
-
Application Development and Deployment
Data management
Database management systems
- Relational Database Management Systems
- Low-Code Database Management Systems
- Object-Oriented Database Management Systems
- Data Lake Management Systems
Database administration and development
- Database Administration
- Database Replication
- Data Modelling
- Database Development and Optimization
Data integration and intelligence
- Data Ingestion and Transformation Software
- Dynamic Data Movement Software
- Data Quality Software
- Data Access Infrastructure Software
- Composite Data Framework Software
- Master Data Intelligence Software
- Metadata Management Software
- Data Archiving and Information LifD-Cycle Management
- Multi cloud support
- Yes
Service scope
- Software add-on or extension
- No
- Cloud deployment model
- Public cloud
- Service constraints
-
Feature sets of the service depend on the edition purchased by the customer. Please refer to the link below for information on features
available per edition.
https://docs.snowflake.com/en/user-guide/intro-editions.html - System requirements
- Refer to https://docs.snowflake.com/en/u ser-guide/setup.html for information on system requirements
User support
- Email or online ticketing support
- Yes
- Support response times
-
Support response times.
Premier Support response time targets:
Sev 1: 1 hour
Sev 2: 2 business hours
Sev 3: 1 business day
Sev 4: 2 business days
Priority Support response time targets:
Sev 1: 15 minutes
Sev 2: 2 hours
Sev 3: 4 business hours
Sev 4: 1 business day
Refer to these sites for details:
https://www.snowflake.com/legal/support-policy-and-servicelevel-agreement/https://www.snowflake.com/support/ - User can manage status and priority of support tickets
- Yes
- Online ticketing support accessibility
- None or don’t know
- Phone support
- Yes
- Phone support availability
- 24 hours, 7 days a week
- Web chat support
- No
- Onsite support
- Yes
- Support levels
-
Support services
Premier Support is included in your contract.
Priority Support can be purchased as a % of credit consumption.
Priority support services include Support Account Management.
Refer to this website for details:
https://www.snowflake.com/support/ - Support available to third parties
- Yes
Onboarding and offboarding
- Getting started
-
Onsite and Online Training as well as certifications are available.
For training please refer to: https://www.snowflake.com/snowflake-professional-services/
For Certification please refer to: https://www.snowflake.com/certifications/
Public documentation regarding the system features and how to use the system can be located here: https://docs.snowflake.com/en/
Snowflake Professional services can be used for migration, implementation, and deployment of the service.
https://www.snowflake.com/snowflake-professional-services/ - Service documentation
- Yes
- Documentation formats
- HTML
- End-of-contract data extraction
-
At the end of the contract a Buyer will be able to access the Service for an agreed period of time (no less than 30 days) in order to retrieve its customer data from the service. For technical information on how to
perform data unloading please refer to data unloading documentation:
https://docs.snowflake.com/en/user-guide-data-unload.html - End-of-contract process
-
At the end of the contract a Buyer will be able to access the Service for an agreed period of time (no less than 30 days) in order to retrieve its customer data from the service. For technical information on how to perform data unloading please refer to data unloading documentation: https://docs.snowflake.com/en/user-guide-data-unload.html
For technical information on how to perform data unloading please
refer to data unloading documentation:
https://docs.snowflake.com/en/user-guide-data-unload.html - Documentation accessibility standard
- None or don’t know
- How the documentation is accessible
-
The Snowflake documentation is available online at.
https://docs.snowflake.com/en/
Using the service
- Web browser interface
- Yes
- Supported browsers
-
- Microsoft Edge
- Firefox
- Chrome
- Safari
- Opera
- Application to install
- No
- Designed for use on mobile devices
- No
- Service interface
- Yes
- User support accessibility
- WCAG 2.2 AAA
- Description of service interface
- Snowflake provides several different applications and tools to access databases in Snowflake. The web interface (Snowsight) distills Snowflake’s powerful SQL support into a unified, easy-to-use experience. The command-line client (SnowCLI) allows users to use the command line to create, manage, update, and view apps running on Snowflake across workloads. The Snowflake Extension for Visual Studio Code is used connect to Snowflake within Visual Studio Code and perform SQL operations. There are many third-party tools and connectors that allow integration with Snowflake. Full details are available at: https://docs.snowflake.com/en/guides-overview-connecting
- Accessibility standards
- WCAG 2.2 AAA
- Accessibility testing
- Snowflake provides several different applications and tools to access databases in Snowflake. The web interface (Snowsight) distills Snowflake’s powerful SQL support into a unified, easy-to-use experience. The command-line client (SnowCLI) allows users to use the command line to create, manage, update, and view apps running on Snowflake across workloads. The Snowflake Extension for Visual Studio Code is used connect to Snowflake within Visual Studio Code and perform SQL operations. There are many third-party tools and connectors that allow integration with Snowflake. Full details are available at: https://docs.snowflake.com/en/guides-overview-connecting
- API
- Yes
- What users can and can't do using the API
-
Snowflake provides many APIs. Developer Guides and API Reference documentation or Source Code is provided for each API. Refer to this website: https://docs.snowflake.com/en/api-reference.html
Details on what can be performed with API’s:
https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/snowflake-rest-api
Customers are able to designate a Snowflake environment as their sandbox or test environment for testing purposes. - API documentation
- Yes
- API documentation formats
- HTML
- API sandbox or test environment
- Yes
- Customisation available
- Yes
- Description of customisation
-
Customers can customize many areas within their Snowflake
account. Their users, permissions, settings, features, databases, tables, and more can all be customized for the use cases that a given customer has.
Scaling
- Independence of resources
- N/A
Analytics
- Service usage metrics
- No
Supplier type
- Supplier type
- Reseller providing extra features and support
- Organisation whose services are being resold
- Snowflake
Staff security
- Staff security clearance
- Staff screening not performed
- Government security clearance
- None
Asset protection
- Knowledge of data storage and processing locations
- Yes
- Data storage and processing locations
-
- United Kingdom
- European Economic Area (EEA)
- Other locations
- User control over data storage and processing locations
- Yes
- Datacentre security standards
- Managed by a third party
- Penetration testing frequency
- At least once a year
- Penetration testing approach
- Another external penetration testing organisation
- Protecting data at rest
- Other
- Other data at rest protection approach
- This is managed by our Cloud Service Providers who host and manage our physical storage.
- Data sanitisation process
- Yes
- Equipment disposal approach
- A third-party destruction service
- Data sanitisation type
-
- Explicit overwriting of storage before reallocation / Secure Erase
- Degaussing
- Physical Destruction / Hardware containing data is completely destroyed
Data importing and exporting
- Data export approach
- N/A
- Data export formats
- ODF
- Data import formats
- ODF
Data-in-transit protection
- Data protection between buyer and supplier networks
-
- Private network or public sector network
- TLS (version 1.2 or above)
- Data protection within supplier network
-
- TLS (version 1.2 or above)
- IPsec or TLS VPN gateway
Availability and resilience
- Guaranteed availability
-
Percentage for the Snowflake Service is 99.9%. For information on availability, SLAs, and refunds, please refer to this website:
https://www.snowflake.com/legal/support-policy-and-service-level-agreement/ - Approach to resilience
-
Snowflake leverages three separate data center clusters called "availability zones," which are "multiple, isolated locations” per region. The deployment of the N+2 redundant components are spread evenly across the three availability zones, so that there is always (in the non-failed state) at least one instance of each component in each of the
three availability zones. Also refer to this whitepaper for more
details on redundancy and resilience:
https://developers.snowflake.com/wp-content/uploads/2021/06/Snowfl
ake-High-Availability-for-Data-Apps-Whitepaper.pdf - Outage reporting
-
Snowflake outages are reported on a public dashboard located
here: https://status.snowflake.com/
Outages and availability incidents are also posted on this website:
https://status.snowflake.com/history
Users can subscribe to email updates for these incidents.
RCAs are provided for all Incidents within 7 days
Identity and authentication
- User authentication needed
- Yes
- User authentication
-
- Multi-Factor Authentication (MFA)
- Public key authentication (including by TLS client certificate)
- Identity federation with existing provider (for example Google Apps)
- Limited access network (for example PSN)
- Dedicated link (for example VPN)
- Username or password
- Access restrictions in management interfaces and support channels
-
Snowflake support personnel
can only obtain access to
customer accounts once
customers grant explicit access
and permissions to their
account. This access is logged
and is temporary, expiring within
24 hours or upon manual
termination by the customer.
Customers control the level of
access granted to the support
personnel and can review logs
as needed to determine what
was performed by the support
personnel. - Access restriction testing frequency
- At least every 6 months
- Management access authentication
-
- Multi-Factor Authentication (MFA)
- Public key authentication (including by TLS client certificate)
- Identity federation with existing provider (for example Google Apps)
- Username or password
Audit information for users
- Access to user activity audit information
- Users have access to real-time audit information
- How long user audit data is stored for
- At least 12 months
- Access to supplier activity audit information
- Users have access to real-time audit information
- How long supplier audit data is stored for
- At least 12 months
- How long system logs are stored for
- At least 12 months
Security governance
- Named board-level person responsible for service security
- Yes
- Security governance certified
- Yes
- Security governance standards
-
- ISO/IEC 27001
- Other
- Other security governance standards
-
Refer to our Snowflake Trust website which lists all relevant
security and governance standards which we comply with/undergo audits for.
https://trust.snowflake.com/
These include: -ISO 27001, 27017, 27018 and 9001 -SOC 2 Type II -SOC 1 Type II - Information security policies and processes
-
See Security Addendum which describes security processes in place. These processes are put in place based on documented policies and procedures. https://www.snowflake.com/legal/security-addendum/
All employees are required to read and acknowledge policies and
procedures (including the Information Security Policy) as part of their annual training.
Logging, monitoring, and alerting are in place for security processes to help ensure policies are followed. Periodic information security and
governance audits also occur multiple times per year. Policies are managed by the Security Compliance team and require approvals from leadership at least annually. The Security Compliance team reports to the
VP of Security who reports to the CFO. - Software Security Code of Practice
- Yes
Operational security
- Configuration and change management standard
- Complies with a recognised standard, for example CSA CCM v4.0 or SSAE-18 / ISAE 3402
- Configuration and change management approach
-
Production system and software
changes are reviewed, tested,
and approved prior to
deployment to production to
ensure the change meets the
authorization, design,
acquisition, implementation,
configuration, and testing
requirements to ensure security,
availability and confidentiality as
outlined in the Secure
Development Life Cycle at
Snowflake Policy. For more
details on this process please
view compliance reports such
as the SOC 2 on this website:
https://trust.snowflake.com/ - Vulnerability management type
- Supplier-defined controls
- Vulnerability management approach
-
Regular internal and external vulnerability scans are automatically performed weekly using an up-to-date vulnerability
database. Scans that detect vulnerabilities meeting
Snowflake-defined risk criteria automatically trigger
notifications to Security personnel and are remediated
according to the documented policy.
● Alerts are evaluated by Security personnel
● Critical, High and Medium vulnerabilities are documented and tracked to closure
● Critical vulnerabilities are reported to the Security
Committee Patches are deployed to the service based on internal policies and procedures. Information regarding potential threats are also gathered based on industry threat and security alerts from US-CERT, CISA, OWASP, CIS, vendor-supplied notifications and others. - Protective monitoring type
- Complies with a recognised standard, for example CSA CCM v4.0 or SSAE-18 / ISAE 3402
- Protective monitoring approach
-
Network activity within Snowflake infrastructure, as well as access to Snowflake, is monitored, logged, and automatically analyzed for suspicious activity to ensure continued system security, integrity, and availability. Included within this monitoring is the implementation of an
Intrusion Detection System (IDS) for systems and networks.
Snowflake uses a dedicated Snowflake database, the Snowflake Security Analytics Warehouse (SAW) as its security information and event
management (SIEM) tool.
Tickets are automatically generated and reviewed by Security personnel. I Icidents are responded to based on criticality rating and the internal Security Incident Response Process. - Incident management type
- Complies with a recognised standard, for example, CSA CCM v4.0 or ISO/IEC 27035:2011 or SSAE-18 / ISAE 3402
- Incident management approach
-
The Snowflake Security Incident
Process consists of three major
phases, Detect, Analyze, and
Respond, which are
documented in detail in the
Snowflake Incident Process
Policy. Snowflake records,
investigates, and resolves
production problems reported
by internal and external
Snowflake users in a timely
manner. All incidents that are
classified as high impact must
go through a post-mortem
process to identify changes to
policies, procedures, best
practices, and documentation to
improve the prevention,
detection, containment, analysis
of or response to applicable
incidents. Incidents are
reported/communicated to
customers and/or other parties
according to contracts, laws,
and regulations. - Post-quantum cryptography secure
- No
Secure development
- Approach to secure software development best practice
- Independent review of processes (for example CESG CPA Build Standard, ISO/IEC 27034, ISO/IEC 27001 or CSA CCM v4.0)
Public sector networks
- Connection to public sector networks
- No
Pricing
- Discount for educational organisations
- No
- Free trial available
- Yes
- Description of free trial
-
There is a 30 day free trail with
a $400 credit. - Link to free trial
- https://signup.snowflake.com/
Discount percentage by annual call-off contract value (excluding VAT)
- Less than £250,000
- 1%
- Between £250,000 and £500,000
- 2%
- Between £500,001 and £1,000,000
- 3%
- Between £1,000,001 and £2,500,000
- 4%
- Between £2,500,001 and £5,000,000
- 5%
- Over £5,000,001
- 6%
Standards and certifications
- ISO/IEC 27001 certification
- Yes
- ISO/IEC 27001 accredited by
- ISOQAR
- ISO/IEC 27001 accreditation date
- Friday 21 June 2024
- What the ISO/IEC 27001 doesn’t cover
- N/A
- ISO 28000:2022 certification
- No
- ISO 9001 certification
- No
- Quality management systems (QMS)
- No
- CSA STAR certification
- No
- PCI certification
- No
- Cyber essentials
- No
- Cyber Essentials Alternative
- In relation to the services you do not have a current and valid Cyber Essentials certificate which has been awarded by one of the government approved Cyber Essentials accreditation bodies but you are working towards gaining it, and will be in a position to confirm that you have been awarded a current and valid Cyber Essentials certificate by one of the government approved accreditation bodies within 12 months of the date of award.
- Cyber essentials plus
- No
- Cyber Essentials Alternative
- In relation to the services you do not have a current and valid Cyber Essentials Plus certificate which has been awarded by one of the government approved Cyber Essentials accreditation bodies but you are working towards gaining it, and will be in a position to confirm that you have been awarded a current and valid Cyber Essentials Plus certificate by one of the government approved accreditation bodies within 12 months of the date of award.
- Other security certifications
- No
Social value
- Mission: Kick start economic growth
-
To secure the highest sustained growth in the G7 - with good jobs and productivity growth in every part of the country making everyone, not just a few, better off.
Policy Outcome 1: Fair work: That offers fair wages and good working conditions. Help people get a job, stay in work, and progress in their careers, with good employment opportunities across the country. Notes: Where there is a large proportion of labour costs in the contract, commercial teams should consider MAC in Outcome 1 as a priority
- New or retained jobs on the contract workforce in the relevant area that meet the criteria set out in MAC 1b, 1c and 1d
- Providing opportunities for, and measuring and monitoring of, staff workforce conditions over time, including employee engagement, involvement in decision-making and satisfaction and adapting to any changes in the results, with clear processes for acting on issues identified
- Plans to engage the contract workforce in deciding the most important workplace issues to address
- Monitoring of employee engagement rates (by protected characteristic) and, where necessary, the development of actions to ensure all voices are heard across the diversity of the workforce
- Employment contracts that reflect actual hours worked; steps taken to ensure employees understand their contracts and have the ability to review and adjust them if actual hours regularly exceed contracted hours
- Activities that support an environment where staff are educated about, and feel empowered to, address their physical wellbeing
- Activities that support an environment where staff are educated about and feel empowered to report and address bullying and harassment
- Activities to cascade good practice on fair working conditions throughout the supply chain
- Offer a pay and leave entitlement to all eligible staff who become kinship carers, ideally equivalent to statutory adoption pay and leave
- Payment of more than the National Minimum Wage or National Living Wage (as appropriate) to the contract workforce
- Entitlement to sick pay for the contract workforce, with provision in place for any staff who do not meet the earnings threshold for statutory sick pay, payment of sick pay from day one of absence and payment of staff on the contract workforce who are off sick a replacement income of 100% of their usual earnings for as long as possible
- Understanding of in-work progression issues affecting the market, industry or sector relevant to the contract, and in the supplier’s own organisation and those of its key sub-contractors
- Measures to support in-work progression to help people in the contract workforce, to move into higher paid work by developing new skills relevant to the contract
- Support for the contract workforce by providing career advice, and providing opportunities for staff working on the contract with in-work progression career development into known skills shortages or high growth areas
- Support for educational attainment relevant to the contract, including training schemes that address skills gaps and result in recognised qualifications
- Understanding of the modern slavery risks and issues affecting the market, industry, sector or country (of origin or of source) relevant to the contract, and the workforce in the supplier’s own organisation and those of its key subcontractors
- Measures to identify, mitigate and manage modern slavery risks relating to the contract and how these will be implemented
- Outline policies and practices to be applied to or put in place for the contract to mitigate and manage modern slavery risks, including: Pre-employment checks, recruitment practices. Workplace conditions, safeguarding plans and processes in place and regular monitoring with relevant groups considered, which may include sampling
- How these flow down the supply chain and are monitored Illustrative examples include reporting, site visits, audits, etc.
- How to ensure business decisions re: price/cost, short lead times, payment timescales do not create modern slavery risks in the supply chain
- Means of influencing staff, suppliers, customers, communities and/or any other appropriate stakeholders with respect to modern slavery risks relating to the contract
Policy Outcome 2: Skills for growth: Supporting growth sectors and addressing skills gaps.
- Understanding of employment and relevant skills issues, and of the education and training issues relating to the contract. Illustrative examples: demographics, skills shortages, new opportunities in high growth sectors, geographic/local community and skills/employment challenges
- Support for educational attainment relevant to the contract, including training schemes that address skills gaps and result in recognised qualifications
Policy Outcome 3: Resilient, innovative and flexible supply chains: Support economic growth through enabling resilient businesses, opportunities for small businesses and voluntary, community and social enterprises
- Understanding of the types of businesses in the market and the level of participation by new businesses, entrepreneurs, start-ups, SMEs, VCSEs and mutuals
- Activities to identify opportunities to open up sub-contracts under the prime contract to a diverse range of businesses, including new businesses, entrepreneurs, start-ups, SMEs, VCSEs and mutuals
- Plans for engaging a diverse range of businesses in engagement activities prior to appointing subcontractors (including activities prior to award of the main contract and during the contract term)
- Activities that demonstrate a collaborative way to work with a diverse range of businesses as part of the supply chain
- Structuring of the supply chain selection process to ensure fairness (e.g. anti-corruption) and encourages participation by a diverse range of businesses, including with regard to new businesses, entrepreneurs, start-ups, SMEs, VCSEs and mutual
- Mission: Make Britain a clean energy superpower
-
To cut bills, create jobs and deliver security with cheaper, zero-carbon electricity by 2030, accelerating to net zero
Policy Outcome 4: Sustainable procurement practices: Reducing carbon footprints, minimising waste, and promoting the use of clean energy and green technologies.
- Understanding of opportunities for additional environmental benefits delivery in the performance of the contract, including working towards net zero carbon emissions and use of clean energy and green technologies
- Collaborative ways of working with the supply chain to deliver additional environmental benefits in the performance of the contract, including working towards net zero carbon emissions and use of clean energy and green technologies
- Mission: Break down barriers to opportunity
-
By reforming our childcare and education systems, to make sure there is no class ceiling on the ambitions of young people in Britain
Policy Outcome 6: Employment and training: For those who face barriers to employment
- Understanding of employment and skills issues, and of the skills and employment shortages of high growth sectors relating to the contract
- Understanding of the issues affecting the representation of disabled people in the workforce in the market, industry or sector relevant to the contract, and in the supplier’s own organisation and those of its key sub-contractors
- Offering a range of quality opportunities with routes of progression if appropriate, e.g. T Level industry placements, students supported into higher level apprenticeships.
- Working conditions which promote an inclusive working environment and promote retention and progression
- Understanding of the issues affecting inequality in employment, skills and pay in the market, industry or sector relevant to the contract, and in the supplier’s own organisation and those of its key sub-contractors. Measures to tackle inequality in employment, skills and pay in the contract workforce
Policy Outcome 7: Creating a pipeline of opportunities: For the contract workforce, reducing barriers to entry for under-represented groups.
- Understanding of the issues affecting the development of new skills by target cohort
- Understanding of the underlying factors affecting improvements to reduce barriers to entry and training schemes for the target cohort(s) related to the contract workforce
- Understanding of issues relating to entering the contract workforce
- Creation of outreach activities to create a pipeline of employees for the future contract delivery
- Mission: Build an NHS fit for the future
-
That is there when people need it; with fewer lives lost to the biggest killers; in a fairer Britain, where everyone lives well for longer.
Policy Outcome 8: Increasing productivity through physical and mental wellbeing: In the supply chain and communities in the relevant area.
- Understanding of issues relating to health and wellbeing, including physical and mental health, in the contract workforce
- Understanding barriers to access to health and social care services or employment opportunities e.g. digital inclusion