How do I raise a "pull request" to merge my [transform branch] back into the main trunk of DAP⇨flow's [dap-airflow] repository?
1. Log into your GitHub account
🖱 Open your web browser and log into your GitHub account using your Hackney email address with two-factor authentication.
👉 Users without a GitHub account or existing GitHub users without membership of the London Borough of Hackney organization, should start here ► DAP⇨flow📚GitHub access
2. Access the dap-airflow repository
🖱 When you are ready, open the dap-airflow repository in your web browser.
3. Switch to your working [transform branch]
👉 If you haven't yet created your [transform branch] then see here how to do that ► DAP⇨flow📚GitHub branching
🖱 Select the "Code" tab at the top of the repository page.
Fig. 3a 
🖱 Click the ▼dropdown button next to 
main.
🖮 Start typing your [transform branch] name.
🖱 Find and select your [transform branch] from the menu below.
Fig. 3b 
👁 Your [transform branch] should reappear next to the ▼dropdown button.
👉 If you've yet to commit your [transform SQL] to your [transform branch] then check back here ► DAP⇨flow📚Committing transforms
👉 If you don't remember if you committed your [transform SQL] to your [transform branch] then check here ► 📚Appendix
4. Create your pull request
🖱 Select the "Pull requests" tab at the top of the repository page.
Fig. 4a 
🖱 Click the "New pull request" button on the right.
🖱 Set the base: branch to the main trunk.
Fig. 4b 
🖱 Set the compare: branch to your [transform branch].
🖱 Click the "Create pull request" button.
Fig. 4c 
5. Add the details to your pull request
🖮 Enter a title for your pull request.
🖮 Add a description explaining the changes you have made.
Fig. 5 & 6 
6. Submit your pull request
🖱 Click the "Create pull request" button below the description on the right.
GitHub should begin the process of pulling your [transform branch] into the main trunk or the dap-airflow repository:
✉ You will be sent an email to confirm that.
✉ A pull request email will be sent to the DAP Platform Team to notify them of your request.
"We ♡ your feedback!"
👉 Please use this link ► DAP⇨flow UX Feedback / github-pull-request
Your feedback enables us to improve DAP⇨flow and our Data Analytics Platform service.
We encourage all our users to be generous with their time, in giving us their recollections and honest opinions about our service.
We especially encourage our new users to give feedback at the end of every 📚Onboarding task because the quality of the onboarding experience really matters.
☝ Please use this link to help us understand your user experience!
📚UX criteria
- Hackney Google Workspace user
- Hackney
[service]Data Analyst - GitHub beginner
How do I raise a "pull request" to merge my [transform branch] back into the main trunk of DAP⇨flow's [dap-airflow] repository?
Measures the GitHub and dap-airflow repository behavior:
Given in my web browser, I am logged on to my GitHub account using my Hackney email address with two-factor authentication
~and I am granted membership of London Borough of Hackney organization on GitHub incorporating the dap-airflow private repository
~and I previously committed my [transform].sql file, containing my [transform SQL], to my current [transform branch]
~and I have not previously raised a pull request on my [transform branch]
When I access the dap-airflow repository
~and I select the "Code" tab at the top of the repository page
~and below that, I click on the "main" ▼dropdown button
~and I begin typing my [transform branch]
~and below that, I select my [transform branch] so that my [transform branch] reappears above next to the ▼dropdown button
~and I select the "Pull requests" tab at the top of the repository page
~and I click the "New pull request" button over on the right
~and I set the base: branch to the main trunk
~and I set the compare: branch my [transform branch]
~and I click on the "Create pull request" button
~and I add a title for my pull request and a description explaining the changes I have made
~and below on the right, I click the "Create pull request" button
Then GitHub should begin the process of pulling my [transform branch] into the main trunk or the dap-airflow repository
~and I will be sent an email confirming that
~and a pull request email will be sent to the DAP Platform Team.
Scale of 13 to 16 ~and flow features.
📚Appendix
Let's assume you set up your [transform branch] earlier but then you got distracted so, now, you are not certain if you actually committed your [transform SQL] to a [transform].sql file.
So, how will you know if you did or you didn't?
Those that have GitHub integrated with their editors eg. Visual Studio Code can quickly pull up a Git Graph to simply find out. But what if you only have GitHub's web interface available, because you are on a Chromebook or you don't have a local copy of the repository?
Here's a neat trick you can use!
You must be logged into your GitHub account for this to work...
🖱 Use the following link to open a separate new tab in your web browser:
https://github.com/LBHackney-IT/dap-airflow/activity?ref=[transform branch]
🖮 Then replace all the text immediately after ref= with the name of your [transform branch] before hitting Enter.
👁 Then below, GitHub should appear with your [transform branch] showing.
👁 If, below that, you get the message "No activity matched your search" then you can be certain you never actually committed a [transform].sql file.
👉 If you did not commit your [transform SQL] to your [transform branch] then check back here ►DAP⇨flow📚Committing transforms
👁 Otherwise, you should see a list of one-or-more commits to your [transform branch].
🖱 But if you are not sure about those, then you can click on … after each commit message and select "Compare changes"
👁 Then, on the next screen you will be presented with a list of changes that should remind you what you actually did!
👉 If you are not sure you have properly committed your [transform SQL] to your [transform branch] then you should retrace your steps here ►DAP⇨flow📚Committing transforms