CCM-15446 Add request_item_plan_read_status_smsnudge view (#220)

* CCM-15446: add request_item_plan_read_status_smsnudge view

* CCM-15446: update .gitleaksignore file

* CCM-15446: correct view sql

* CCM-15446: standardise keyword case

* CCM-15446: update trivy version

CCM-15149 sms nudge billing (#217)

* SMS Nudge billed by originator

* Column name consistency fixes

* Support the originating sender ODS code

* Sonarqube fix

* Fix missing dependency

* Missing view creation line

Bump github/codeql-action from 4.32.5 to 4.32.6 (#214)

Bumps [github/codeql-action](https://github.com/github/codeql-action) from 4.32.5 to 4.32.6.
- [Release notes](https://github.com/github/codeql-action/releases)
- [Changelog](https://github.com/github/codeql-action/blob/main/CHANGELOG.md)
- [Commits](github/codeql-action@c793b71...0d579ff)

---
updated-dependencies:
- dependency-name: github/codeql-action
  dependency-version: 4.32.6
  dependency-type: direct:production
  update-type: version-update:semver-patch
...

Signed-off-by: dependabot[bot] <[email protected]>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>

CCM-14728 ingest billing fields (#210)

* Adopt existing conventions for new columns

* Add message length fields for billing purposes

* Fix incorrect data type

* Add senderodscode column

* Small performance tweak

* Fix secrets fingerprint

CCM-12034: Added new sms nudge views (#208)

* CCM-12034: Added new sms nudge views

* CCM-12034: update terraform docs

* CCM-12034: typo in workflow description

* CCM-12034: add nudge client id to tfvars

* CCM-12034: add flagged guids to .gitleaksignore file

* CCM-12034: view query performance improvement

---------

Co-authored-by: Ian Hodges <[email protected]>

Bump peter-evans/create-pull-request from 8.0.0 to 8.1.0 (#200)

Bumps [peter-evans/create-pull-request](https://github.com/peter-evans/create-pull-request) from 8.0.0 to 8.1.0.
- [Release notes](https://github.com/peter-evans/create-pull-request/releases)
- [Commits](peter-evans/create-pull-request@v8.0.0...v8.1.0)

---
updated-dependencies:
- dependency-name: peter-evans/create-pull-request
  dependency-version: 8.1.0
  dependency-type: direct:production
  update-type: version-update:semver-minor
...

Signed-off-by: dependabot[bot] <[email protected]>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>

CCM-13935: Athena Alarm Tuning (#198)

Revert "Add templateid dimension to plan summary tables/views (#151)" (…

…#174)

This reverts commit 0a2bfb1.

Fix issue with Synertec messages sent on a Sunday and invoiced on Mon…

…day (#165)

CCM-12593: Reduce latency alarm sensitivity (#161)

* Reduce alarm sensitivity

* Fix SQL

* Fix multi line

* Fix for time series comparison

* Type fix

* Fix maths again

* Tweak comment

* Lint fix