Synapse CI/CD: Deploying Synapse Workspace artifacts using Azure DevOps

[@avicool08]

very detailed and in simple language, thanks for sharing.

[@НиколайБеляшов-в6к]

I can't thank you enough! You are a great guy and your video helps me a lot!

[@govindk1360]

It is really good session, you explained very detail. Thank you so much.

[@sunilupadhyay8845]

Good Detailed session, Thank you!.. I have a question on How to deploy stored procedures of database using CI-CD pipeline of the database created in Dedicated pool.

[@error-j7z]

Great video! Tks. I have one question though. Imagine the following scenario. The client has three environments, four teams are working in DEV environment, they want to promote the code individualy. As of now, if two teams(TEAM A/ TEAM B)promote their code to UAT and one team gets the confirmation(TEAM A)/okay to promote their changes, the current CI/CD process will promote BOTH codes(TEAM A and TEAM B). What would be the approach? Would you build a CI/CD process from DEV to UAT and once approved there would be another process pushing exactly the same pull request form DEV to PROD? Does that make sense? Thank you.

[@saurabh7337]

Is it possible to selectively promote workspace artifacts, such as single notebook, code grouped under a folder etc ? Or it has to be always all or nothing within a workspace ?

[@thefabricbuddy]

Unfortunately, you cannot cherry pick the artifacts you need to deploy in Synapse.

[@howiefu5282]

You have to do it outside of Synapse Workspace. Up till now, Synapse Workspace does not support cherry-pick but you can still do that using git command.

[@mhatheshtsr4212]

How to invoke the pipline run after deployment in done via azure devops?

[@prodbyseeker]

Any tips on cicd for dedicated/serverless sql pools? Also, if you create the required spark pool in another environment, does it need to have the same config? Or just the same name?

[@carter.hughes]

Second this. Good questions

[@thefabricbuddy]

We have already released a couple of videos covering cicd for dedicated sql and very soon a cicd video for serverless will be released 😊We strongly advise compute pool naming to be consistent across enviroments to avoid the additional effort of doing custom parameterization.

[@thefabricbuddy]

here's the link in case you missed kzbin.info/www/bejne/pHrci6ifjbaJl6c

[@kadamteja5743]

Hii Rui, Could you please reupload your videos on custom template parameterization which were created earlier??

[@AzureSynapse]

Hello! Here are a few videos Rui has created on custom template parameterization: Synapse CI/CD: Using a custom parameter template: kzbin.info/www/bejne/aZPWqGake8qHorc Synapse CI/CD: Advanced custom template parameterization kzbin.info/www/bejne/aqLLoKN5r9iZg5I

[@GuillaumeBerthier]

@@AzureSynapse could you sort the videos from your playlists , like this kzbin.info/aero/PLzUAjXZBFU9NPD095eD-9TOHk3O7DExdl . Currently video are not in sequential order in playlists which make it difficult to know on which video should be watched first. Thanks !

[@MrSatishc84]

I need the video for synapse deployment using YAML file

[@nitropan]

Seems like the Release Pipelines are no longer an option. I only have Pipelines, Environment, and Library. Ok, I found how to enable the classic Release Pipelines in "Project Settings" or "Organization Settings" under Pipelines>Settings>Disable creation of classic release pipelines (turn off)

[@shardulpatil7260]

Hi, it was a good video, could you please help me with migrating hive tables that has some partitions and buckets to synapse tables in dedicated sql pool?

[@thefabricbuddy]

could you please elaborate to better understand your use case for cicd in synapse? 😊

[@satyadevi639]

How to ignore some artifacts in this approach

[@chocolatemonster6165]

I love these videos, I am slowly making my way through them. But the hissing in the background when you are demonstration while sharing your screen is killing me. I am not sure if it is something that is fixed in later videos or not, but I really hope so.