Synapse CI/CD: Using a custom parameter template

Подписаться 14 тыс.

Просмотров 7 тыс.

50% 1

Hello Synapse CI/CD fans! In the third video of our Synapse CI/CD series, Rui walks you through how you can take advantage of custom template parameterization when deploying your Synapse artifacts to a target environment.
To watch all of the videos in this series, check out the Synapse CI/CD playlist: • Synapse CI/CD
00:06 Introduction
01:30 Demo
16:35 Wrap-Up
Azure Synapse Analytics Community site: aka.ms/Synapse...
Join the Azure Synapse Influencer program!
aka.ms/Synapse...
Rui's Twitter: / _azurui_
Synapse Twitter: / azure_synapse
#azuresynapse #cicd

Опубликовано:

13 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 16

@ptirockssss Год назад

This is excellent series. Thank you

@Joeeaw Год назад

Love your video, but somehow, I can hear a noise. It starts around 1:32 - at the beginning of the demo.

@sikandervempalli2035 Месяц назад

Why did you add "_default" to the ARM template files?

@shaikshahenshah3892 Год назад

Rui❤

@albinlim7688 Год назад

What if you have multiple pipelines created in Synapse Workspace? How do you parameterize each especially when multiple pipelines have the same parameter names?

@franciscoanalytics Год назад

Hello Rui! I've a question... How do you think I should go forward in order to deploy an SQL script? Imagine that I have SQL script with a create external table statement or a create SQL table and I want to create the table in the new workspace. How can I do it? Great video, you saved my life with the custom parameter template!

@thefabricbuddy Год назад

Hey Francisco, Sql scripts are not meant to be use to deploy database changes across environments. Consider automating the deployment of your database changes using DACPAC (there's a video in this playlist covering that 😉)

@InspireAZ Год назад

@@thefabricbuddy Can you please provide the link that point directly to DACPAC please ?

@paramesh4881 Год назад

Hi Rui, thanks for the video, i have setup it in my account, but we are using Selfhosted IR, i am not able to parametrize this, how can i skip self hoste ir from deployment and just make it refer in UAT ENV??

@nitropan 8 месяцев назад

Hi Rui, is there a way to access these parameter values from the Library Variable groups?

@vivekanand5078 Год назад

How to parameterize Synapse pool name, Self hosted IR name as a parameter?

@thefabricbuddy Год назад

by adding the "name" property to the corresponding artifact definition will allow you to parameterize the artifact name: here's an example below that will allow you to parameterize the Integration Runtime name. "Microsoft.Synapse/workspaces/integrationRuntimes": { "name":"=", "properties": { "typeProperties": { "*": "=" } } },

@vinaynan Год назад

if we have 20 different note books? then should we have somany

@paramesh4881 Год назад

Same question I too have, every time we keep adding new note books..

@MikeHowles 9 месяцев назад

@@paramesh4881 I ended up making a bash script prior to the Synapse Deploy task to rename parameter values, as the MS spec to rename stuff is clunky.

@joaosamura 8 месяцев назад

@@MikeHowles Hi Mike, how are you? I'm trying the same approach as you, but using Powershell it seems that my automation didn't work, I'm having errors when deploying and this is very strange because my automation is correct, the parameters are being changed. Can you help me with this?