René's URL Explorer Experiment

Title: GitHub - NHSDigital/nhs-notify-reporting

Open Graph Title: GitHub - NHSDigital/nhs-notify-reporting

X Title: GitHub - NHSDigital/nhs-notify-reporting

Description: Contribute to NHSDigital/nhs-notify-reporting development by creating an account on GitHub.

Open Graph Description: Contribute to NHSDigital/nhs-notify-reporting development by creating an account on GitHub.

X Description: Contribute to NHSDigital/nhs-notify-reporting development by creating an account on GitHub.

Mail addresses
england.nhsnotify@nhs.net

Opengraph URL: https://github.com/NHSDigital/nhs-notify-reporting

X: @github

direct link

Domain: patch-diff.githubusercontent.com

route-pattern	/:user_id/:repository
route-controller	files
route-action	disambiguate
fetch-nonce	v2:d9f1c584-2bac-24d0-4f7f-4eb9379fd551
current-catalog-service-hash	f3abb0cc802f3d7b95fc8762b94bdcb13bf39634c40c357301c4aa1d67a256fb
request-id	BF88:74626:1185353F:119D591F:697638A6
html-safe-nonce	8ce24f8ded7fb07a7ac4c5c943e72d9dc4dbfb199c3c92540b7d64fda9cfc1fc
visitor-payload	eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJCRjg4Ojc0NjI2OjExODUzNTNGOjExOUQ1OTFGOjY5NzYzOEE2IiwidmlzaXRvcl9pZCI6IjEzMzI3ODk1MTgzNDc0MTc3NjYiLCJyZWdpb25fZWRnZSI6InNlYSIsInJlZ2lvbl9yZW5kZXIiOiJzZWEifQ==
visitor-hmac	92128d99f990194449f19b944d7b16dab74d0ff2e67f55add6d7b8c64b19389c
hovercard-subject-tag	repository:813082117
github-keyboard-shortcuts	repository,copilot
google-site-verification	Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-url	https://collector.github.com/github/collect
analytics-location	//
fb:app_id	1401488693436528
apple-itunes-app	app-id=1477376905, app-argument=https://github.com/NHSDigital/nhs-notify-reporting
twitter:image	https://opengraph.githubassets.com/7e6b9dd50847e4608787d1f0bd38c928470285814cc0024cd3832d4b06abdc34/NHSDigital/nhs-notify-reporting
twitter:card	summary_large_image
og:image	https://opengraph.githubassets.com/7e6b9dd50847e4608787d1f0bd38c928470285814cc0024cd3832d4b06abdc34/NHSDigital/nhs-notify-reporting
og:image:alt	Contribute to NHSDigital/nhs-notify-reporting development by creating an account on GitHub.
og:image:width	1200
og:image:height	600
og:site_name	GitHub
og:type	object
hostname	github.com
expected-hostname	github.com
None	c6814b4cc7afd45cd6e64525d0cff0e76dd802f315a5b0e55a7abda1d1d070d0
turbo-cache-control	no-preview
go-import	github.com/NHSDigital/nhs-notify-reporting git https://github.com/NHSDigital/nhs-notify-reporting.git
octolytics-dimension-user_id	6683590
octolytics-dimension-user_login	NHSDigital
octolytics-dimension-repository_id	813082117
octolytics-dimension-repository_nwo	NHSDigital/nhs-notify-reporting
octolytics-dimension-repository_public	true
octolytics-dimension-repository_is_fork	false
octolytics-dimension-repository_network_root_id	813082117
octolytics-dimension-repository_network_root_nwo	NHSDigital/nhs-notify-reporting
turbo-body-classes	logged-out env-production page-responsive
disable-turbo	false
browser-stats-url	https://api.github.com/_private/browser/stats
browser-errors-url	https://api.github.com/_private/browser/errors
release	4ea235bfed58ef16c8a5642b3ac64b74f10c9f52
ui-target	full
theme-color	#1e2327
color-scheme	light dark

Links:

Skip to content	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#start-of-content
	https://patch-diff.githubusercontent.com/
Sign in	https://patch-diff.githubusercontent.com/login?return_to=https%3A%2F%2Fgithub.com%2FNHSDigital%2Fnhs-notify-reporting
GitHub CopilotWrite better code with AI	https://github.com/features/copilot
GitHub SparkBuild and deploy intelligent apps	https://github.com/features/spark
GitHub ModelsManage and compare prompts	https://github.com/features/models
MCP RegistryNewIntegrate external tools	https://github.com/mcp
ActionsAutomate any workflow	https://github.com/features/actions
CodespacesInstant dev environments	https://github.com/features/codespaces
IssuesPlan and track work	https://github.com/features/issues
Code ReviewManage code changes	https://github.com/features/code-review
GitHub Advanced SecurityFind and fix vulnerabilities	https://github.com/security/advanced-security
Code securitySecure your code as you build	https://github.com/security/advanced-security/code-security
Secret protectionStop leaks before they start	https://github.com/security/advanced-security/secret-protection
Why GitHub	https://github.com/why-github
Documentation	https://docs.github.com
Blog	https://github.blog
Changelog	https://github.blog/changelog
Marketplace	https://github.com/marketplace
View all features	https://github.com/features
Enterprises	https://github.com/enterprise
Small and medium teams	https://github.com/team
Startups	https://github.com/enterprise/startups
Nonprofits	https://github.com/solutions/industry/nonprofits
App Modernization	https://github.com/solutions/use-case/app-modernization
DevSecOps	https://github.com/solutions/use-case/devsecops
DevOps	https://github.com/solutions/use-case/devops
CI/CD	https://github.com/solutions/use-case/ci-cd
View all use cases	https://github.com/solutions/use-case
Healthcare	https://github.com/solutions/industry/healthcare
Financial services	https://github.com/solutions/industry/financial-services
Manufacturing	https://github.com/solutions/industry/manufacturing
Government	https://github.com/solutions/industry/government
View all industries	https://github.com/solutions/industry
View all solutions	https://github.com/solutions
AI	https://github.com/resources/articles?topic=ai
Software Development	https://github.com/resources/articles?topic=software-development
DevOps	https://github.com/resources/articles?topic=devops
Security	https://github.com/resources/articles?topic=security
View all topics	https://github.com/resources/articles
Customer stories	https://github.com/customer-stories
Events & webinars	https://github.com/resources/events
Ebooks & reports	https://github.com/resources/whitepapers
Business insights	https://github.com/solutions/executive-insights
GitHub Skills	https://skills.github.com
Documentation	https://docs.github.com
Customer support	https://support.github.com
Community forum	https://github.com/orgs/community/discussions
Trust center	https://github.com/trust-center
Partners	https://github.com/partners
GitHub SponsorsFund open source developers	https://github.com/sponsors
Security Lab	https://securitylab.github.com
Maintainer Community	https://maintainers.github.com
Accelerator	https://github.com/accelerator
Archive Program	https://archiveprogram.github.com
Topics	https://github.com/topics
Trending	https://github.com/trending
Collections	https://github.com/collections
Enterprise platformAI-powered developer platform	https://github.com/enterprise
GitHub Advanced SecurityEnterprise-grade security features	https://github.com/security/advanced-security
Copilot for BusinessEnterprise-grade AI features	https://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 support	https://github.com/premium-support
Pricing	https://github.com/pricing
Search syntax tips	https://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
documentation	https://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
Sign in	https://patch-diff.githubusercontent.com/login?return_to=https%3A%2F%2Fgithub.com%2FNHSDigital%2Fnhs-notify-reporting
Sign up	https://patch-diff.githubusercontent.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E&source=header-repo&source_repo=NHSDigital%2Fnhs-notify-reporting
Reload	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting
Reload	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting
Reload	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting
NHSDigital	https://patch-diff.githubusercontent.com/NHSDigital
nhs-notify-reporting	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting
NHSDigital/nhs-notify-repository-template	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-repository-template
Notifications	https://patch-diff.githubusercontent.com/login?return_to=%2FNHSDigital%2Fnhs-notify-reporting
Fork 1	https://patch-diff.githubusercontent.com/login?return_to=%2FNHSDigital%2Fnhs-notify-reporting
Star 0	https://patch-diff.githubusercontent.com/login?return_to=%2FNHSDigital%2Fnhs-notify-reporting
nhsdigital.github.io/nhs-notify-reporting/	https://nhsdigital.github.io/nhs-notify-reporting/
MIT license	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/LICENCE.md
0 stars	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/stargazers
1 fork	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/forks
Branches	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/branches
Tags	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/tags
Activity	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/activity
Star	https://patch-diff.githubusercontent.com/login?return_to=%2FNHSDigital%2Fnhs-notify-reporting
Notifications	https://patch-diff.githubusercontent.com/login?return_to=%2FNHSDigital%2Fnhs-notify-reporting
Code	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting
Issues 0	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/issues
Pull requests 3	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/pulls
Actions	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/actions
Projects 0	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/projects
Security 0	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/security
Insights	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/pulse
Code	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting
Issues	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/issues
Pull requests	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/pulls
Actions	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/actions
Projects	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/projects
Security	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/security
Insights	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/pulse
Branches	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/branches
Tags	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/tags
	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/branches
	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/tags
243 Commits	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/commits/main/
	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/commits/main/
.devcontainer	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/tree/main/.devcontainer
.devcontainer	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/tree/main/.devcontainer
.github	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/tree/main/.github
.github	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/tree/main/.github
.vscode	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/tree/main/.vscode
.vscode	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/tree/main/.vscode
docs	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/tree/main/docs
docs	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/tree/main/docs
infrastructure	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/tree/main/infrastructure
infrastructure	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/tree/main/infrastructure
scripts	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/tree/main/scripts
scripts	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/tree/main/scripts
src	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/tree/main/src
src	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/tree/main/src
tests	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/tree/main/tests
tests	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/tree/main/tests
.editorconfig	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/.editorconfig
.editorconfig	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/.editorconfig
.gitattributes	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/.gitattributes
.gitattributes	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/.gitattributes
.gitignore	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/.gitignore
.gitignore	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/.gitignore
.gitleaksignore	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/.gitleaksignore
.gitleaksignore	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/.gitleaksignore
.sonarcloud.properties	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/.sonarcloud.properties
.sonarcloud.properties	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/.sonarcloud.properties
.tool-versions	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/.tool-versions
.tool-versions	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/.tool-versions
AGENTS.md	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/AGENTS.md
AGENTS.md	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/AGENTS.md
CHANGELOG.md	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/CHANGELOG.md
CHANGELOG.md	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/CHANGELOG.md
LICENCE.md	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/LICENCE.md
LICENCE.md	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/LICENCE.md
Makefile	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/Makefile
Makefile	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/Makefile
README.md	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/README.md
README.md	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/README.md
VERSION	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/VERSION
VERSION	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/VERSION
project.code-workspace	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/project.code-workspace
project.code-workspace	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/project.code-workspace
README	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting
MIT license	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting
Security	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting
	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#nhs-notify-reporting
	https://github.com/NHSDigital/nhs-notify-reporting/actions/workflows/cicd-1-pull-request.yaml
	https://sonarcloud.io/summary/new_code?id=NHSDigital_nhs-notify-reporting
	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#introduction
HashiCorp Terraform	https://developer.hashicorp.com/terraform
AWS Step Functions	https://docs.aws.amazon.com/step-functions/latest/dg/welcome.html
AWS Glue	https://docs.aws.amazon.com/glue/latest/dg/what-is-glue.html
AWS Athena	https://docs.aws.amazon.com/athena/latest/ug/what-is.html
AWS S3	https://docs.aws.amazon.com/AmazonS3/latest/userguide/Welcome.html
AWS Parameter Store	https://docs.aws.amazon.com/systems-manager/latest/userguide/systems-manager-parameter-store.html
Apache Iceberg	https://iceberg.apache.org/
Microsoft Power BI	https://learn.microsoft.com/en-us/power-bi/
	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#table-of-contents
Introduction	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#introduction
Table of Contents	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#table-of-contents
Setup	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#setup
Prerequisites	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#prerequisites
Usage	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#usage
Athena Workgroups	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#athena-workgroups
How Do I?	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#how-do-i
Workarounds / Limitations	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#workarounds--limitations
Testing	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#testing
Design	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#design
Architecture Overview	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#architecture-overview
Staging Table Design	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#staging-table-design
Ingestion Query Design	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#ingestion-query-design
Multiple Ingestion Passes	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#multiple-ingestion-passes
Handling PID	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#handling-pid
Permissions	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#permissions
Housekeeping	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#housekeeping
Canned Reports	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#canned-reports
Completed Communications Report	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#completed-communications-report
Completed Batch Report	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#completed-batch-report
Watchdog Queries	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#watchdog-queries
Contacts	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#contacts
Licence	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#licence
	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#setup
	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#prerequisites
	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#usage
here	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/infrastructure/terraform/components/reporting/scripts/sql/README.md
	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#athena-workgroups
	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#workarounds--limitations
limitation in the Terraform provider	https://github.com/hashicorp/terraform-provider-aws/issues/36531
shell scripts	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/infrastructure/terraform/components/reporting/scripts
	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#how-do-i
	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#how-do-i-define-a-new-projectionaggregation
create_table	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/infrastructure/terraform/components/reporting/scripts/create_table.sh
here	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/infrastructure/terraform/components/reporting/scripts/sql/tables
here	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/infrastructure/terraform/components/reporting/scripts/sql/ingestion
here	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/infrastructure/terraform/components/reporting/scripts/sql/migration
here	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/infrastructure/terraform/components/reporting/sfn_state_machine_ingestion.tf
here	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/infrastructure/terraform/components/reporting/sfn_state_machine_housekeeping.tf
SSO access	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/infrastructure/terraform/components/acct/data_iam_policy_document_sso_read_only_table_access.tf
Power BI Gateway	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/infrastructure/terraform/components/reporting/iam_instance_profile_powerbi_gateway.tf
	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#how-do-i-define-a-view
create_replace_view	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/infrastructure/terraform/components/reporting/scripts/create_replace_view.sh
here	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/infrastructure/terraform/components/reporting/scripts/sql/views
SSO access	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/infrastructure/terraform/components/acct/data_iam_policy_document_sso_read_only_table_access.tf
Power BI Gateway	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/infrastructure/terraform/components/reporting/iam_instance_profile_powerbi_gateway.tf
	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#how-do-i-add-a-new-column-to-a-projectionaggregation-retrospectively
add_column	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/infrastructure/terraform/components/reporting/scripts/add_column.sh
table definition	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/infrastructure/terraform/components/reporting/scripts/sql/tables
	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#testing
	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#design
	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#architecture-overview
	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/docs/diagrams/reporting.png
	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#staging-table-design
Apache Iceberg	https://iceberg.apache.org/
MERGE INTO	https://docs.aws.amazon.com/athena/latest/ug/merge-into-statement.html
readme	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/infrastructure/terraform/components/reporting/scripts/sql/README.md
	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#ingestion-query-design
MERGE INTO	https://docs.aws.amazon.com/athena/latest/ug/merge-into-statement.html
COALESCE	https://trino.io/docs/current/functions/conditional.html#coalesce
readme	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/infrastructure/terraform/components/reporting/scripts/sql/README.md
	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#multiple-ingestion-passes
	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#handling-pid
Step Function Terraform	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/infrastructure/terraform/components/reporting/sfn_state_machine_ingestion.tf
	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#permissions
	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#housekeeping
	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#canned-reports
	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#completed-communications-report
	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#completed-batch-report
	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#watchdog-queries
	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#contacts
	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#licence
LICENCE.md	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/blob/main/LICENCE.md
© Crown Copyright	https://www.nationalarchives.gov.uk/information-management/re-using-public-sector-information/uk-government-licensing-framework/crown-copyright/
Open Government Licence v3.0	https://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/
nhsdigital.github.io/nhs-notify-reporting/	https://nhsdigital.github.io/nhs-notify-reporting/
Readme	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#readme-ov-file
MIT license	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#MIT-1-ov-file
Security policy	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting#security-ov-file
Please reload this page	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting
Activity	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/activity
Custom properties	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/custom-properties
0 stars	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/stargazers
1 watching	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/watchers
1 fork	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/forks
Report repository	https://patch-diff.githubusercontent.com/contact/report-content?content_url=https%3A%2F%2Fgithub.com%2FNHSDigital%2Fnhs-notify-reporting&report=NHSDigital+%28user%29
Releases 22	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/releases
1.1.6 Latest Nov 18, 2025	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/releases/tag/1.1.6
+ 21 releases	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/releases
Packages 0	https://patch-diff.githubusercontent.com/orgs/NHSDigital/packages?repo_name=nhs-notify-reporting
Please reload this page	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting
Contributors 14	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/graphs/contributors
Please reload this page	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting
HCL 61.2%	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/search?l=hcl
Shell 22.4%	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/search?l=shell
Go Template 12.6%	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/search?l=go-template
Gherkin 2.0%	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/search?l=gherkin
Makefile 0.9%	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/search?l=makefile
JavaScript 0.8%	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/search?l=javascript
Dockerfile 0.1%	https://patch-diff.githubusercontent.com/NHSDigital/nhs-notify-reporting/search?l=dockerfile
	https://github.com
Terms	https://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacy	https://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Security	https://github.com/security
Status	https://www.githubstatus.com/
Community	https://github.community/
Docs	https://docs.github.com/
Contact	https://support.github.com?tags=dotcom-footer

Viewport: width=device-width

URLs of crawlers that visited me.