Snowflake
Snowflake is an advanced dataplatform that is provided to youas a self-managed service. Snowflake’s data platform brings together data storage,processing, and analyticsolutions 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 Cortext AI Features - Agents, Analyst, Copilot and more
- ML Functions
- Seehttps://docs.snowfl ake.com/en/user-guide/intro-supported-features.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 fo rorganization 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
7 0 6 0 1 0 8 6 2 0 3 2 8 3 0
Contact
OAKLAND GROUP SERVICES LIMITED
Phil Bent
Telephone: 0113 2341944
Email: tenders@weareoakland.com
About your 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.snowfl ake.com/en/user-guide/intro-editions.html - System requirements
- Refer to https://docs.snowflake.com/en/user-guide/setup.html for information on system requirements.
User support
- Email or online ticketing support
- Yes
- Support response times
-
Premier Support response time targets:
Sev 1: 1 hour
Sev 2: 2business hours
Sev 3: 1business day
Sev 4: 2 businessdays
Priority Support response time targets:
Sev 1: 15 minutes
Sev 2: 2 hours
Sev 3: 4business hours
Sev 4: 1business day
Refer to thes esites for details:
https://www.snowflake.com/legal/support-policy-and-service-level-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
-
Premier Support is included in yourcontract. Priority Support can be purchased as a % of credit consumption. Priority support services include Support Account Management.
Refer tot his 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/snowfl ake-professional-services/
For Certification please refer to: https://www.snowflake.com/certifi cations/
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. - 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 oftime (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 - Documentation accessibility standard
- None or don’t know
- How the documentation is accessible
-
The Snowfl ake documentationis 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
- The Snowflake Snowsight graphical user interface meets many, but not all, of the WCAG requirements.
- Accessibility standards
- WCAG 2.2 AAA
- Accessibility testing
- The Snowflake Snowsight graphical user interface meets many, but not all, of the WCAG requirements.
- 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 foreach API.
Refer to this website:
https://docs.snowflake.com/en/api-reference.html
Details onwhat can be performed with API’s:
https://docs.snowflake.com/en/developer-guide/snowflake-rest-api/snowfl ake-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
Resellers
- Supplier type
- Not a reseller
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
- Snowflakes Monthly 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-failedstate) at least one instance of each component in each of the three availability zones. 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 e-mail 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 relevantsecurity and governancestandards which we comply with/undergo audits for.https://trust.snowflake.com/
These include:
-ISO 27001,27017, 27018 and 9001
-SOC 2Type 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.snowfl ake.com/legal/security-addendum/
All employees are required to read and acknowledge policies and procedures (including theInformation 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 bySecurity 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. Incidents 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 trial 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
- 0%
- Between £250,000 and £500,000
- 5%
- Between £500,001 and £1,000,000
- 7.5%
- Between £1,000,001 and £2,500,000
- 10%
- Between £2,500,001 and £5,000,000
- 15%
- Over £5,000,001
- 20%
Non-mandatory Standards and certifications
- ISO/IEC 27001 certification
- Yes
- Who accredited the ISO/IEC 27001
- David Derrick, Regional Director UKAM, LRQA Limited
- ISO/IEC 27001 accreditation date
- Friday 10 May 2024
- What the ISO/IEC 27001 doesn’t cover
- Our ISO/IEC 27001:2022 certification applies to the protection of information and data assets for our core services: Data Strategy, Data Governance, Data Platform, Data Analytics, and Quality & Operational Excellence, as well as internal support functions (HR, sales and marketing, IT operations, finance). Any activities, assets, or business units outside this scope, or not listed in our Statement of Applicability v2, are not covered. This includes services delivered by third parties, cloud platforms we resell (unless explicitly included in our certification scope), and any locations or functions not specified in the certificate or Statement of Applicability.
- ISO 28000:2022 certification
- No
- ISO 9001 certification
- Yes
- Who accredited the ISO 9001 certification
- Matt Page, Managing Director Assurance - UK&I, BSI Group
- ISO 9001 accreditation date
- Saturday 30 November 2024
- What the ISO 9001 doesn’t cover
- Our ISO 9001:2015 certification covers the operation of a Quality Management System for the provision of quality, operational excellence, and data and analytics consultancy services. Any services, activities, or business units outside this scope, including non-consultancy offerings and third-party services not related to quality, operational excellence, or data and analytics consultancy, are not covered by our certification.
- Quality management systems (QMS)
- Yes
- CSA STAR certification
- No
- PCI certification
- No
- Cyber essentials
- Yes
- Please provide your Cyber Essentials Certificate Number
- Cf860cc5-6479-415a-8e84-3fbc2e4f202b
- Cyber essentials plus
- Yes
- Please provide your Cyber Essentials Plus Certificate Number
- F1871e9d-f7fb-42bf-bbfe-df3855b9268a
- Other security certifications
- No
Social value
- Section B - Commitment for Future: Delivery
-
-
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
- 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
- Monitoring and reporting of gender and ethnicity pay gaps and plans to address them where necessary
- 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
- Volunteering opportunities for staff
- 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
- Means of influencing staff, suppliers, customers, communities and/or any other appropriate stakeholders with respect to modern slavery risks relating to the contract
-
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 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
- Activities to support relevant sector related skills growth and sustainability in the contract workforce. Illustrative examples: careers talks, curriculum support, literacy support, safety talks and volunteering
-
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 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
- 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
- Methods for engaging with different parts of the community (including the education system and charities representing the community) and how communities come together to inform decisions, strategy and projects to leave a positive legacy for future generations
- Measures to involve local stakeholders and/or users in design (e.g. in the design of services, systems, products or buildings)
- Plans for positive actions with community groups.
- Measures for making facilities used in the delivery of the contract available for community groups, education or training
- Measures to engage users and communities and build relationships to increase community integration build trust and influence how the contract is delivered
- Plans to respond flexibly and adapt approaches to community engagement and initiatives
- Collaborating with anchor institutions and community groups to make facilities available for education, training or community events
-
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
- Delivery of additional environmental benefits through the performance of the contract, including working towards net zero carbon emissions and use of clean energy and green technologies
- Understanding of how to influence staff, suppliers, customers, communities and/or any other appropriate stakeholders through the delivery of the contract to support climate and nature protection and improvement
- Activities to reconnect people with the environment and increase awareness of ways to protect and enhance it
-
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
- Creation of employment opportunities particularly for those who face barriers to employment, such as prison leavers, care leavers and/or who are located in deprived areas, and for people in industries with known skills shortages or in high growth sectors
- Delivery of training schemes and programmes to address any identified skills gaps and under-representation in the workforce for the contract (e.g. prison leavers, care leavers, kinship carers, disabled people)
- Advertising, promotional and outreach activities designed to raise awareness of the offer to reach the target cohort
- 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
- Collection of the views and expertise of disabled people and their representative organisations on successfully supporting disabled employees or applicants
- Inclusive and accessible recruitment practices, and retention-focused activities, including those provided in the Guide for line managers on recruiting, managing and developing people with a disability or health condition
- Introducing transparency to pay and reward processes
- Working conditions which promote an inclusive working environment and promote retention and progression
- Other measures to provide equality of opportunity for disabled people and those with health conditions into employment, including becoming a Disability Confident employer and inclusion of supported businesses in the contract supply chain
- 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
- Inclusive and accessible development practices, including guidance for line managers on recruiting, managing and developing people with a disability or health condition
-
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 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
- Other measures to offer development opportunities for the target cohort(s) in the contract workforce
- Advertising, promotional and outreach activities designed to raise awareness of the offer to reach the target cohort
- Understanding of issues relating to entering the contract workforce
- Creation of outreach activities to create a pipeline of employees for the future contract delivery
- Content of the outreach activity is designed to suit the target cohort
- Advertising, promotional and outreach activities designed to raise awareness of the offer to reach the target cohort
-
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
- Inclusive and accessible recruitment practices, development practices and retention policies that support-focused activities including those provided in the Guide for line managers on recruiting, managing and developing which support people with a disability or health condition
- Actions to invest in the physical and mental health and wellbeing of the contract workforce
-