Database Access
Standard database access
The first thing you’ll need to work with Create a Derived Table is an Analytical Platform account with standard database access. If you don’t have that already, follow the guidance on how to make changes to the standard database access project file in the Data Engineering Database Access repo.
Your Data Engineering Database Access project access file
As well as standard datbase access, you’ll need a project access file that’s specific to your (or your team’s) work. This will give you access to the source databases used to derive tables as well as the derived tables themselves. Access to derived tables is granted at the domain level, this means you will need to know which domain you will be creating derived tables in before you start working. Your project file should include the source databases and domain(s) that you’ll use to derive your tables from, and the domain(s) that your tables will go in. A list of already available domains can be found in the database access resources for Create a Derived Table. If you don’t know already, you can learn how to set up a project access file by following the guidance on access to curated databases in the Data Engineering Database Access repo.
A typical project access file might look like:
project_id: Analytical Team 1 Derived Tables
review_date: 2022-10-20
approver_position: >=G7 of Analytical Team 1 Derived Tables
approver_email: approver.name@justice.gov.uk
alternative_approver_emails:
- alternative.approver-name@justice.gov.uk
resources:
- create_a_derived_table/domain_a
- create_a_derived_table/domain_b
- source_database_a/full
- source_database_b/full
users:
- alpha_user_name_a
- alpha_user_name_b
- alpha_user_name_c
business_case: >
To create derived tables for Analytical Team 1.