DP-203: 11 - Dynamic Azure Data Factory 

This has to be the best series I've followed. The content is priceless. Thanks for this Tybul this.

Good video to learn how to ingest data using lookup, foreach in Azure!! I liked your way of iterative way of teaching !! Hopefully will complete this series and will plan for my certification!! Thanks for your effort on this series!!

Great stuff tybul. I appreciate your valuable insights.take a look at copy activity settings as well.

Hi Tybul I am following the series and it's awesome. Thank u so much!!

Wow this was GREAT!! So much i learnt from this.Thank You So much Sir!! And for the test which you gave at the end to have table name wise target structure, i added this and it worked !! @concat( dataset().ServerName, '/', dataset().DatabaseName, '/', dataset().TableName, '/Year=', formatDateTime(utcnow(),'yyyy'), '/Month=', formatDateTime(utcnow(),'MM'), '/Day=', formatDateTime(utcnow(),'dd') )

Wonderful video sir, thank you

Gold material. Thanks

Great one! Thanks!

SELECT QUOTENAME(t.name) AS tableName, QUOTENAME(SCHEMA_NAME(t.schema_id)) AS schemaName FROM sys.tables as t

Hi Tybul, amazing video series! I've been following your videos religiously and plan on taking the exam sometime next year. I'm currently practicing sql on leetcode. What do you suggest would be the fastest way to get fluent with SQL?

Another super vidéo💪🙏🙏 Thank you very much Say Hi to jour cat 😸 (33') Are you planning any vidéo on Databricks? Stream Analytics? Azure data + DevOps?

@concat(dataset().schemaName,'_', dataset().tableName,'.csv')

@concat('SELECT * FROM ', item().schemaName, '.', item(). tableName)

You're the best, bravo!!... Next course Azure architecture 😁.

@concat( dataset().serverName, '/', dataset().databaseName, '/Year=', formatDateTime(utcnow(),'yyyy'), '/Month=', formatDateTime(utcnow(),'MM'), '/Day=', formatDateTime(utcnow(),'dd') )

i selected parquet for sink dataset , however it gave an error while running the pipeline for dbo.BuildVersion . it says "ErrorCode=ParquetInvalidColumnName,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=The column name is invalid. Column name cannot contain these character:[,;{}() \t=],Source=Microsoft.DataTransfer.Common," . Does anyone know how to solve it ? Thank You !