Datavault

dbt cloud

dbt (data build tool) is a command-line tool that enables data analysts, data engineers and data scientists to transform data in their warehouses more effectively.
dbt performs the T (Transform) of ETL allowing you to transform data as queries and orchestrate them in a highly efficient way.

Features

• Easy version controlled way of writing transformations for data platforms
• dbt takes code, compiles SQL, and runs against your database
• dbt provides a mechanism to write, version-control, and share documentation
• dbt has a package manager for public and private repositories
• Support for Snowflake, Big Query, Postgres, Apache-Spark and Redshift
• Vendor support for Databricks, Oracle, Teradata, Firebolt, Rockset
• Support SQL Server, Azure SQL, Azure Synapse, Exasol and Vertica

Benefits

• dbt is simple to understand, learn and run
• Designed by Data Engineers but easy to use by non-engineers
• Extremely flexible data model (recreate data easily, backfills are easy)
• SQL can be difficult to test - dbt facilitates testing
• Graphical view of data lineage
• Easy to apply version control
• Open source and customisable
• Allows the automation of testing ensuring data quality
• Complex queries can be debugged using easy-to-test models and macros
• Facilitates Data Vault automation using AutomateDV

£240 a user a month

• Free trial available

Service documents

• Pricing document

  PDF

• Skills Framework for the Information Age rate card

  PDF

• Service definition document

  PDF

• Terms and conditions

  PDF

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 samantha.cole@data-vault.com. Tell them what format you need. It will help if you say what assistive technology you use.

Framework

G-Cloud 14

Service ID

600459682600426

Contact

Samatha Cole
023 92 637171
samantha.cole@data-vault.com

Service scope

• Software add-on or extension: No
• Cloud deployment model: Public cloud
• Service constraints: No
• System requirements: Internet connection with an up to date web browser

User support

• Email or online ticketing support: Email or online ticketing
• Support response times: To be discussed.
• 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: Web chat
• Web chat support availability: 9 to 5 (UK time), 7 days a week
• Web chat support accessibility standard: None or don’t know
• How the web chat support is accessible: Dont know
• Web chat accessibility testing: Dont know
• Onsite support: Yes, at extra cost
• Support levels: Support Level in https://www.getdbt.com/enterprise-terms/
• Support available to third parties: Yes

Onboarding and offboarding

• Getting started: Documentation is available via the dbt website. Options https://www.getdbt.com/dbt-learn/
• Service documentation: Yes
• Documentation formats: HTML
• End-of-contract data extraction: Exports available upon request
• End-of-contract process: Dbt code is available and hosted by the end user, it can be taken free of charge

Using the service

• Web browser interface: Yes
• Supported browsers:
  • Internet Explorer 11
  • Microsoft Edge
  • Firefox
  • Chrome
  • Safari
  • Opera
• Application to install: Yes
• Compatible operating systems:
  • Android
  • IOS
  • Linux or Unix
  • MacOS
  • Windows
  • Windows Phone
  • Other
• Designed for use on mobile devices: No
• Service interface: No
• User support accessibility: None or don’t know
• API: Yes
• What users can and can't do using the API: The dbt Cloud API makes it possible to fetch data from your dbt Cloud account and programmatically run and monitor dbt jobs. https://docs.getdbt.com/dbt-cloud/api-v2
• API documentation: Yes
• API documentation formats: Other
• API sandbox or test environment: No
• Customisation available: No

Scaling

• Independence of resources: Constant monitoring

Analytics

• Service usage metrics: Yes
• Metrics types: Yes, through https://status.getdbt.com/
• Reporting types:
  • API access
  • Real-time dashboards
  • Reports on request

Resellers

• Supplier type: Reseller providing extra support
• Organisation whose services are being resold: Dbt Labs

Staff security

• Staff security clearance: Other security clearance
• 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 every 6 months
• Penetration testing approach: Another external penetration testing organisation
• Protecting data at rest: Other
• Other data at rest protection approach: We utilize AES-256 for all data encrypted at rest.; https://www.getdbt.com/security/
• Data sanitisation process: No
• Equipment disposal approach: A third-party destruction service

Data importing and exporting

• Data export approach: Data is kept in DWH and metadata in git, so all stays with customer except for run logs which are kept in the application
• Data export formats: CSV
• Data import formats: CSV

Data-in-transit protection

• Data protection between buyer and supplier networks: TLS (version 1.2 or above)
• Data protection within supplier network: TLS (version 1.2 or above)

Availability and resilience

• Guaranteed availability: 99.9% https://www.getdbt.com/enterprise-terms/
• Approach to resilience: Dbt Cloud is hosted in AWS, with availability in multiple AZ’s (availability zones) in a region.; ; Our retention of backups are a minimum of seven (7) days.; ; Our staff is remotely distributed across the US providing support to customers globally. Our distributed workforce allows us to provide support virtually from anywhere and reduce the impact of support interruption in a geographic location.
• Outage reporting: Status.getdbt.com

Identity and authentication

• User authentication needed: Yes
• User authentication: Identity federation with existing provider (for example Google Apps)
• Access restrictions in management interfaces and support channels: https://docs.getdbt.com/docs/dbt-cloud/access-control/enterprise-permissions
• Access restriction testing frequency: At least every 6 months
• Management access authentication:
  • 2-factor authentication
  • Dedicated link (for example VPN)

Audit information for users

• Access to user activity audit information: Users contact the support team to get 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

Standards and certifications

• ISO/IEC 27001 certification: Yes
• Who accredited the ISO/IEC 27001: The Cadence Group
• ISO/IEC 27001 accreditation date: 9/12/2021
• What the ISO/IEC 27001 doesn’t cover: The scope of this certificate includes dbt Labs’s products, teams, and ; ISMS managed at its headquarters Philadelphia, PA. The in-scope ; people, processes, technology, and locations are defined within the ; dbt Labs Information Security Management System Policy, dated ; August 3, 2021, and the Statement of Applicability, dated April 4, 2021.
• ISO 28000:2007 certification: No
• CSA STAR certification: No
• PCI certification: No
• Cyber essentials: No
• Cyber essentials plus: No
• Other security certifications: Yes
• Any other security certifications: ISO/IEC 27701:2019 over its privacy information management system (PIMS)

Security governance

• Named board-level person responsible for service security: Yes
• Security governance certified: Yes
• Security governance standards: ISO/IEC 27001
• Information security policies and processes: ISO 27001:2013, ISO 27701:2019

Operational security

• Configuration and change management standard: Supplier-defined controls
• Configuration and change management approach: In SOC2 Report
• Vulnerability management type: Supplier-defined controls
• Vulnerability management approach: In SOC2 Report
• Protective monitoring type: Supplier-defined controls
• Protective monitoring approach: WAF
• Incident management type: Undisclosed
• Incident management approach: https://www.getdbt.com/disclosure

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 v3.0)

Public sector networks

• Connection to public sector networks: No

Social Value

• Social Value:

  Social Value

  • Fighting climate change
  • Covid-19 recovery
  • Tackling economic inequality
  • Equal opportunity
  • Wellbeing

  Fighting climate change

  Datavault supports the move to de-carbonise the economy and is committed to achieving Net Zero by 2050. We have a Carbon Reduction Plan completed in accordance with PPN 06/21 and associated guidance. This commitment is signed off by our CEO and is published on our website. We encourage our employees to cycle to work. We have fitted a cycle rack at our offices and employees have access to the cycle to work scheme. We further encourage the use public transport instead of driving and when driving to carshare whenever possible. We have implemented hybrid working enabling our employees and contractors to work from home. Our entire IT infrastructure, apart from desktop PCs/laptops is hosted in the cloud. Our desk booking system to ensure limited office capacity is used optimally while providing the opportunity to work flexibility in hygienic working conditions. We have no plastic coffee cups and plastic bottles in the office all are reusable China. We focus on using local suppliers where appropriate to minimise the environmental impact. The use of paper and printing is limited with staff being encouraged to think before printing anything. Increasingly documents are being signed and kept electronically where possible. We believe our initiatives, even small ones, are supporting to fight against climate change.; We have made reasonable adjustments to working hours for team members to support their use of public transport, therefore reducing car emissions. We have employed staff in the US in order to manage client engagements there, reducing requirements for team members to travel to the USA. Overnight accommodation is made available to staff who may travel very long journeys to reduce the number of commutes.; We have a cloud first strategy aimed at using innovative technologies improve productivity, allow our business to scale easily and minimise our carbon footprint.

  Covid-19 recovery

  Datavault recognises its responsibility to support people and communities to manage and recover from the impacts of COVID-19, both directly through work for clients and through interactions with the wider community.; Initiatives include:; - Using local suppliers where possible to support the local economy.; - Supporting staff requiring time off to have flu or COVID-19 vaccinations. ; - Continued use of hand sanitiser, signage and cleaning products.; - Flexible working and encouraging staff that are not well to stay away from the office.; - Support hybrid working through a defined model that allows staff the benefits of both home-based and office-based working, while meeting client needs. ; - Lockdowns have affected different people in different ways, it is only normal for some staff to feel uncertain and apprehensive about going back to the workplace. The company has tasked managers with ensuring that practical support is given to the return to normal working models.; Our benefits package has a wealth of health and well being services, including life support and bereavement assistance.

  Tackling economic inequality

  Datavault is committed to tackling economic inequality by offering job opportunities to young people from a range of backgrounds. The company is headquartered in a borough, Havant, ranked within the most deprived 25% of local authorities in England in terms of the education, skills and training indicator. Our commitment to helping to tackling economic inequality from the root level comes from supporting education and skills locally. ; We have created new roles for apprentices, fresh graduates and re-trainers, to diversify our talent pool and support growth in the local economy. Datavault is committed to help our staff to develop their skills. We will also seek to create corporate social value in recruiting staff with a view to developing their skills. Activities facilitating training and skills development include:; - Supporting or sponsoring relevant formal education (through financial contribution and/or study leave); - Graduate recruitment and development; - Providing internships and placements for students in higher education; - Supporting or sponsoring product or industry specific training and certifications; - Data Vault 2.0 certification for all technical employees within two years of starting; - Internal training platform with dedicated content author, currently over 45 classes developed for use by staff.; In 2022 we introduced Level 3 and 4 apprenticeship programmes to help and to support our drive to tackle economic inequality by providing opportunities particularly for the next generation and improving skills. ; We are cognitive of ensuring Diversity and Inclusion issues in our employment and recruitment practises. This includes skills-based assessments, structured interviews, transparent promotions to senior positions by ensuring roles, with full job descriptions are advertised internally.

  Equal opportunity

  Datavault is committed to help our staff to develop their skills. We will also seek to create corporate social value in recruiting staff with a view to developing their skills. Activities facilitating training and skills development include:; Supporting or sponsoring relevant formal education (through financial contribution and/or study leave); Graduate recruitment and development; Providing internships and placements for students in higher education; Supporting or sponsoring product or industry specific training ; Data Vault 2.0 certification for all technical employees within two years of starting; Internal training platform with dedicated content author, currently over 45 classes developed for use by staff and evolving; Product training, for example, on Erwin Data Intelligence, Data Modeller, dbt and Snowflake; We have demonstrated our commitment through the following activities:; Sponsorship of an Open University degree in business and computing; Sponsorship of a professional HR qualification ; 8-week placements for students under the Sepnet programme ; Employing graduates for their first job; Member of a university employers’ liaison group ; Guest lecturing on a university MBA course; Two apprenticeships in digital marketing; One software development apprenticeship; Wherever we seek suppliers that align with our social value and equal opportunities policies, their supply chain partners also need to reflect these values and maintain appropriate cyber security standards.; All new technical appointments engage in our ‘Datavault bootcamp’ which is designed to equip new staff with the necessary skills, knowledge, and confidence to seamlessly integrate into our project teams. Mentoring is in place to support the transition from academia to a business environment. ; We implement a fair recruitment strategy for external and internal posts and have thorough interview processes that are transparent.; We attend university open days as employer representatives and engage in careers fairs in order to provide opportunities for all university students to understand about careers in the our industry.

  Wellbeing

  Datavault recognises that our strength comes from our people whether they be staff, associates or subcontractors. We want staff to stay with us for the long term and believe that they will stay if we take good care of them and offer training and development opportunities. Therefore, we always seek to support them and be sensitive to their broader family lives. Also: ; We help them to enhance their knowledge and career/professional development with training and support to get certifications.; Team leaders have been trained to be aware of and sensitive to mental health, diversity and inclusion issues.; We hold daily stand-up meetings for core teams to share knowledge and experiences, solve problems. ; We hold podcasts and monthly hackathons as strategies to encourage engagement across the company in learning activities to build knowledge and collaboration.; Our line managers regularly hold “keeping-in-touch” hold meetings with their team members allowing them to ask for support, not only with work-related issues but also their personal issues.; Staff are encouraged to participate in community volunteering or charity projects (examples include being a school governor and guest lecturing at a university).; We support home-working with office equipment if needed to ensure ergonomically sound working environments.; We have hybrid and flexible working to account for varied staff circumstances.; Mental health is taken seriously, and staff are encouraged to consider the mental health of colleagues and are provided with mental health learning resources. ; Employees have access to a range of health and wellbeing options that include an employee assistance programme, a free counselling service provided by fully qualified professionals. ; Our HR system allows the rewarding of “Thanks”, which is open to all employees and is a standing agenda item on company days. Company seeks to celebrate work anniversaries, exam results, certifications etc.

Pricing

• Price: £240 a user a month
• Discount for educational organisations: No
• Free trial available: Yes
• Description of free trial: There is a free open source version dbt.
• Link to free trial: https://www.getdbt.com/

Service documents

• Pricing document

  PDF

• Skills Framework for the Information Age rate card

  PDF

• Service definition document

  PDF

• Terms and conditions

  PDF

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 samantha.cole@data-vault.com. Tell them what format you need. It will help if you say what assistive technology you use.