Acrotrend

Acrotrend Cloud Data Warehouse (Snowflake)

Acrotrend’s Cloud Data Warehouse on Snowflake brings your data into an analysis friendly, low-cost platform.
Our cloud data warehousing services are powered by process & technology accelerators, including Gap Analysis Framework, ready made migrations for Oracle to Snowflake, SQL Server to Snowflake, Salesforce.com to Snowflake, and Quick Deployment Packs.

Features

  • Consolidate your data from silos into an analysis friendly platform
  • Consistent and continuous delivery of a 360° customer view
  • Resulting in higher user adoption for analytics and reporting
  • Pay-as-you-go model for computation and storage of data
  • Simple administration and ownership, with scalability
  • Data Science ready big data infrastructure
  • Modernize your legacy data platforms

Benefits

  • Consolidated data
  • 360° view
  • High performance
  • Lower cost
  • Scalable
  • Machine learning ready

Pricing

£40 to £60 a terabyte a month

  • Education pricing available
  • Free trial available

Service documents

Request an accessible format
If you use assistive technology (such as a screen reader) and need versions of these documents in a more accessible format, email the supplier at sandeep.mendiratta@acrotrend.com. Tell them what format you need. It will help if you say what assistive technology you use.

Framework

G-Cloud 12

Service ID

5 2 2 4 7 0 0 9 1 9 2 1 4 9 8

Contact

Acrotrend Sandeep Mendiratta
Telephone: 02081233208
Email: sandeep.mendiratta@acrotrend.com

Service scope

Service constraints
No
System requirements
NA

User support

Email or online ticketing support
Email or online ticketing
Support response times
Flexible Service Level Agreements with 12/7 coverage and same day response times. Priority 1 incidents on weekends.
User can manage status and priority of support tickets
No
Phone support
Yes
Phone support availability
9 to 5 (UK time), 7 days a week
Web chat support
No
Onsite support
Yes, at extra cost
Support levels
1st, 2nd and 3rd line support available, in line with industry methods - delivered by a world-class support organisation using recognised incident management tools.
Support available to third parties
Yes

Onboarding and offboarding

Getting started
Acrotrend has a structured framework for effective onboarding. A customized approach is provided as per the customers needs.
Service documentation
Yes
Documentation formats
  • HTML
  • PDF
End-of-contract data extraction
Snowflake supports bulk export of data into flat, delimited text files or into Amazon S3 or Microsoft Azure. Acrotrend will assist the customers for this activity if required when the contract ends.
End-of-contract process
This can be customized as per the customer needs. Standard inclusions are onboarding and ongoing hosting support.

Using the service

Web browser interface
Yes
Using the web interface
The data warehouse is accessible through a web interface.
Web interface accessibility standard
None or don’t know
How the web interface is accessible
N/A
Web interface accessibility testing
N/A
API
Yes
What users can and can't do using the API
RESTful APIs
API automation tools
OpenStack
API documentation
Yes
API documentation formats
  • HTML
  • PDF
Command line interface
Yes
Command line interface compatibility
  • Linux or Unix
  • Windows
  • MacOS
Using the command line interface
Wide range of commands can be executed through the command line interface.

Scaling

Scaling available
Yes
Scaling type
Automatic
Independence of resources
This is managed without any intervention by users. The system manages this without any downtime.
Usage notifications
Yes
Usage reporting
Email

Analytics

Infrastructure or application metrics
Yes
Metrics types
  • CPU
  • Memory
  • Number of active instances
Reporting types
Reports on request

Resellers

Supplier type
Not a reseller

Staff security

Staff security clearance
Staff screening not performed
Government security clearance
Up to Security Clearance (SC)

Asset protection

Knowledge of data storage and processing locations
Yes
Data storage and processing locations
European Economic Area (EEA)
User control over data storage and processing locations
No
Datacentre security standards
Managed by a third party
Penetration testing frequency
At least every 6 months
Penetration testing approach
Another external penetration testing organisation
Protecting data at rest
  • Physical access control, complying with another standard
  • Encryption of all physical media
Data sanitisation process
No
Equipment disposal approach
In-house destruction process

Backup and recovery

Backup and recovery
Yes
What’s backed up
  • Full data set
  • Incremental data set
Backup controls
Scheduling feature is available for the backup.
Datacentre setup
Multiple datacentres with disaster recovery
Scheduling backups
Users schedule backups through a web interface
Backup recovery
Users can recover backups themselves, for example through a web interface

Data-in-transit protection

Data protection between buyer and supplier networks
TLS (version 1.2 or above)
Data protection within supplier network
IPsec or TLS VPN gateway

Availability and resilience

Guaranteed availability
The data warehouse extends across three availability zones so that Snowflake can continue to operate even if two of these zones become inaccessible or unavailable due to any unforeseen event.
Approach to resilience
The service is fully distributed across multiple data centres at all layers. Data is stored in replicated storage and can be recovered instantly.
Outage reporting
Email alerting.

Identity and authentication

User authentication
  • 2-factor authentication
  • Public key authentication (including by TLS client certificate)
  • Identity federation with existing provider (for example Google apps)
  • Username or password
Access restrictions in management interfaces and support channels
Snowflake provides a stringent control over the access provided to every object and policy.
Access restriction testing frequency
At least every 6 months
Management access authentication
  • 2-factor authentication
  • Public key authentication (including by TLS client certificate)
  • Identity federation with existing provider (for example Google Apps)
  • Username or password
Devices users manage the service through
  • Any device but through a bastion host (a bastion host is a server that provides access to a private network from an external network such as the internet)
  • Directly from any device which may also be used for normal business (for example web browsing or viewing external email)

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
User-defined
Access to supplier activity audit information
Users have access to real-time audit information
How long supplier audit data is stored for
User-defined
How long system logs are stored for
User-defined

Standards and certifications

ISO/IEC 27001 certification
No
ISO 28000:2007 certification
No
CSA STAR certification
No
PCI certification
No
Other security certifications
No

Security governance

Named board-level person responsible for service security
No
Security governance certified
Yes
Security governance standards
Other
Other security governance standards
NIST 800-53 and the CIS Critical Security Controls
Information security policies and processes
Robust password policy for user accounts.
Customer controlled user access.
Data isolation within the VPC.
Logging of all transactions & errors for auditing.

Operational security

Configuration and change management standard
Supplier-defined controls
Configuration and change management approach
Snowflake provides notifications on change management activities via their online knowledge base and customers are notified over email before any updates are applied to their instances.
Vulnerability management type
Supplier-defined controls
Vulnerability management approach
Snowflake maintains system administration procedures for systems that access Customer Data that meet or exceed industry standards, including without limitation, system hardening, system and device patching and proper installation of threat detection software as well as daily signature updates of same.

Snowflake Security reviews US-Cert new vulnerabilities announcements weekly and assess their impact to Snowflake based on a Snowflake-defined risk criteria.
Protective monitoring type
Supplier-defined controls
Protective monitoring approach
Snowflake provider performs regular monitoring and response.
Incident management type
Supplier-defined controls
Incident management approach
Incident reporting over phone and email with appropriate tracking and resolution.
Incident reviews with the governance team at agreed intervals.

Secure development

Approach to secure software development best practice
Conforms to a recognised standard, but self-assessed

Separation between users

Virtualisation technology used to keep applications and users sharing the same infrastructure apart
Yes
Who implements virtualisation
Third-party
Third-party virtualisation provider
Snowflake Computing
How shared infrastructure is kept separate
Each customer gets a dedicated instance of Snowflake, running in a separate Virtual Private Cloud.
Snowflake also isolates data storage. The customer’s data is encrypted using customer-managed keys.

Energy efficiency

Energy-efficient datacentres
No

Pricing

Price
£40 to £60 a terabyte a month
Discount for educational organisations
Yes
Free trial available
Yes
Description of free trial
$400 worth of credits.

Service documents

Request an accessible format
If you use assistive technology (such as a screen reader) and need versions of these documents in a more accessible format, email the supplier at sandeep.mendiratta@acrotrend.com. Tell them what format you need. It will help if you say what assistive technology you use.