This video demonstrates a simple, consistent, and easy-to-follow branching strategy for Azure Synapse Analytics to facilitate collaborative code development and version control.
Mind Map
Click to expand
Click to explore the full interactive mind map • Zoom, pan, and navigate
thank you
hello synapse LCD fans
welcome to this video series on synapse
ICD my name is Hui kunye and I'm a
support escalation engineer on the Azure
synapse analytics team
integrating your workspace with the
distributed Version Control System like
kit will give you the flexibility you
need to share and managed code
when altering your code in synapse
Studio your team should find a balance
between this flexibility and the need to
collaborate and share code in a
consistent manner all team members
should publish review and iterate on
code changes through git branches shared
with others in synapse you should adopt
a branching strategy for your team so
they can collaborate better and spend
less time managing Version Control and
more time developing their code
in this video we'll be demonstrating how
you can keep your branching strategy in
synapse very simple
implementing some Concepts that will
result in a Version Control workflow for
your team that is consistent and easy to follow
follow
let's watch the demo and see how you can
achieve this
working collaboratively and tracking
code changes in synapse Studio can be
quite challenging
you can look at synapse Studio as a
front-end to an integrated analytics
platform here we combine
date warehousing
big data analytics data integration
visualization so having
multi-disciplinary teams here
interacting with all these cap
capabilities in different projects
different features it will require to
collaborate and share code in a
consistent manner
this is where adopting a simple
branching strategy for your team is key
for a successful continuous integration
of your code in synapse Studio
you want to apply a branching strategy
that avoids contradictions
will result in a Version Control
workflow for your team that is
consistent and easy to follow
in this video I will show you a simple
Branch strategy that you can adopt in synapse
synapse
so let's start by using feature branches
feature branches or topics
topics
they are helpful when you want to
isolate your work in progress from the
completed work in your main branch
when you hit the branch selector here in
synapse Studio you can differentiate
this collaboration Branch from other
feature branches
by this icon here with this blue star
this Branch represents your
collaboration Branch your shared code base
base
you want to keep this Branch a high
quality and up-to-date Branch okay this
is the branch that you want
to build cleanly and always be correct
your main branch needs these qualities
so that your feature branches created by
your developers they start from a good
known version of a code
so you need to prevent as much
interactions with this Branch direct check-ins
check-ins
and the feature Branch they will do the work
work
so to create this feature branch
you can use this Branch selector in
synapse and click here
on the new branch
and you can create a branch based on
whatever Branch you have here
in synapse Studio the workspace publish
branch is not editable
so it will not appear here in this
Branch list so right now since I have
this main branch only
I will create my feature branch
and I can you can give for example
your developer's name and then
feature one for example
as a naming convention
so I'm going to create this branch
and now
in the branch selector you can see this
Branch already and if you go here to
devops repo you will see under my folder
name my feature branch and this feature
Branch was create based on Main so all
the folder structure that exists in main
branch will be replicated to my feature branch
branch
so now
I'm ready to start on a new feature
so suppose that I want to create a new
SQL script
okay based on my serverless pool simple
slip script like select one plus one
for example
I will see these changes reflected here
in my feature Branch under the SQL
now look at the publish button that is
disabled from any branch except your
collaboration branch
so you cannot publish your code from a
feature Branch only from collaboration
now that's where the second step for
your branches branching strategy comes
in using pull requests
so now you need to merge your feature
Branch into the main branch using a pull request
request
in pull requests you can use code review
and the review that takes place in a
pull request is critical for improving
code quality
you should only merge your branches
through a pull request that pass your
review process
to create a pull request in synapse
Studio you can use the branch selector
and select the create pull request
option here
and by using this pull requests you can
merge your changes from your Source
Branch into destination in this case
from my feature Branch into my
collaboration branch
and you can see the files involved in
this pull request
you can review this code
you can see the commit as well
and you can ask your reviewers to
approve this this pull request as a best
practice you can link this full request
to any work any work item
okay in this case
I I have this process as much simple as
possible so I don't have any code
reviewer right now I'm keeping this
process simple
but you should have these reviewers in
place okay
for the approval process to to start
so now I'm going to approve my pull request
request
and to complete when I complete I can
select here the merge type I will keep
this as the as the standard merge no
fast forward and in terms of post
completion options
I hope to delete my feature Branch after
merging I don't want to keep
too much feature branches here in my in
my branching strategy to avoid any
garbage so
in the in the in the repo in this case I
don't need the feature Branch anymore so
I will delete after completing the pull request
request
so now when I complete the pull request
my merge my changes from feature Branch
will be merged
to my collaboration Branch Main and now
that is pull request is completed I
added my SQL script I can close this
window and when I switch to the main branch
branch
here in
synapse Studio
I will see my SQL script one
here available in this branch and the
publish button will now be enabled so I can
can
publish my changes
one thing that you can do prior to the
publish operation is just to use the validate
validate
all link
to start the workspace validation and
see if there is any inconsistent code
before publishing your changes
now that the workspace validation is
clear so I'm going to hit the publish
button and here it is
depending changes
that were flat
depending on the changes that
were merged to the
main branch or the collaboration Branch
you will see these painting changes
reflected here
so now I'm going to
hit the publish button for my pending
changes only the SQL script will be
published and once the SQL script is
published to live mode
the publish operation will start the
second stage let's call it this way the
arm template generation to the publish branch
branch
so now the publish operation
save this SQL script
in the service live mode
so here it is the SQL script one
it was saved in live mode and
and
if we go here to the branches in the
workspace publish
we should see under the workspace name
the folder
you should see that templates the two
arm templates generated by the publish operation
operation
and this will be the outcome of your
continuous integration
workflow let's call it this way in
synapse Studio
These Arm templates they represent the
outcome of your continuous integration
life cycle and synapse
and they will represent the input
the starting point for your continuous delivery
delivery
of artifacts in synapse
we will see this continuous delivery
stage in a later stage
in another video
thanks for watching this video we would
love to hear from you don't forget to
like comment and subscribe to our Channel
Channel
thanks again for watching and I will
catch you up on the next one [Music]
Click on any text or timestamp to jump to that moment in the video
Share:
Most transcripts ready in under 5 seconds
One-Click Copy125+ LanguagesSearch ContentJump to Timestamps
Paste YouTube URL
Enter any YouTube video link to get the full transcript
Transcript Extraction Form
Most transcripts ready in under 5 seconds
Get Our Chrome Extension
Get transcripts instantly without leaving YouTube. Install our Chrome extension for one-click access to any video's transcript directly on the watch page.
