Repository: kedro-org/kedro
Pull request: Add nightly build workflow and create an issue if it fails

## Description
<!-- Why was this PR created? -->
Close https://github.com/kedro-org/kedro/issues/2970

## Development notes
<!-- What have you changed, and how has this been tested? -->
- Add nightly build + notification workflow to GHA similar to `kedro-plugins`
- Pin `azure-storage-blob < 12.18.0` - Temporary fix for this issue causing the CI to fail https://github.com/Azure/azure-sdk-for-python/issues/32056 
## Checklist

- [ ] Read the [contributing](https://github.com/kedro-org/kedro/blob/main/CONTRIBUTING.md) guidelines
- [ ] Signed off each commit with a [Developer Certificate of Origin (DCO)](https://docs.github.com/en/repositories/managing-your-repositorys-settings-and-features/managing-repository-settings/managing-the-commit-signoff-policy-for-your-repository)
- [ ] Opened this PR as a 'Draft Pull Request' if it is work-in-progress
- [ ] Updated the documentation to reflect the code changes
- [ ] Added a description of this change in the [`RELEASE.md`](https://github.com/kedro-org/kedro/blob/main/RELEASE.md) file
- [ ] Added tests to cover my changes
- [ ] Checked if this change will affect Kedro-Viz, and if so, communicated that with the Viz team


Problem statement:
Add nightly build to tests on Github Actions
## Description
<!-- Is your feature request related to a problem? A clear and concise description of what the problem is: "I'm always frustrated when ..." -->
Part of migration to GitHub Actions

Hints from issue discussion:

Commit message: Pin azure-storage-blob version + add nightly  build

Signed-off-by: Ankita Katiyar <ankitakatiyar2401@gmail.com>

Patch to review:
diff --git a/.github/workflows/all-checks.yml b/.github/workflows/all-checks.yml
index 51efe0e4db..5fe306d018 100644
--- a/.github/workflows/all-checks.yml
+++ b/.github/workflows/all-checks.yml
@@ -1,6 +1,7 @@
 name: Run all checks on Kedro
 
 on:
+  workflow_call:
   push:
     branches:
       - main
diff --git a/.github/workflows/nightly-build.yml b/.github/workflows/nightly-build.yml
new file mode 100644
index 0000000000..d2edddbd37
--- /dev/null
+++ b/.github/workflows/nightly-build.yml
@@ -0,0 +1,29 @@
+name: Run nightly tests on all plugins
+
+on:
+  workflow_dispatch:
+  schedule:
+    # Run every day at midnight (UTC time)
+    - cron: '0 0 * * *'
+
+jobs:
+  kedro-test:
+    uses: ./.github/workflows/all-checks.yml
+
+  notify-airflow:
+    permissions:
+      issues: write
+    name: Notify failed build for airflow
+    needs: kedro-test
+    if: failure()
+    runs-on: ubuntu-latest
+    steps:
+      - uses: jayqi/failed-build-issue-action@v1
+        with:
+          github-token: ${{ secrets.GITHUB_TOKEN }}
+          label-name: "nightly build"
+          title-template: "ci: Nightly build failure"
+          body-template: |
+            GitHub Actions workflow [{{workflow}} #{{runNumber}}](https://github.com/{{repo.owner}}/{{repo.repo}}/actions/runs/{{runId}}) failed.
+          create-label: true
+          always-create-new-issue: false
diff --git a/setup.py b/setup.py
index afea8c9587..ba8ac538f7 100644
--- a/setup.py
+++ b/setup.py
@@ -135,6 +135,7 @@ def _collect_requirements(requires):
 extras_require["test"] = [
     "adlfs>=2021.7.1, <=2022.2; python_version == '3.7'",
     "adlfs~=2023.1; python_version >= '3.8'",
+    "azure-storage-blob < 12.18.0",  # Temporary fix https://github.com/Azure/azure-sdk-for-python/issues/32056
     "bandit>=1.6.2, <2.0",
     "behave==1.2.6",
     "biopython~=1.73",


Code review comments:
diff_hunk: @@ -0,0 +1,29 @@
+name: Run nightly tests on all plugins
path: .github/workflows/nightly-build.yml
text: @author:
```suggestion
name: Run nightly tests on Kedro
```