Azure Synapse Step by Step Sink to SQL Database

Hi there,

I am struggling to get my transformed data from the ‘sink’ to my SQL Database. I am using CSV data types – what sink type to use (integration dataset, inline).

I am pretty sure I want to press inline as that is the only option that allows me to select the sql database with the linked service I am wanting to use as well. On the settings tab, schema name and table name pop up could you explain what I am putting into these.

Finally I am unsure how to create tables in my SQL database

Any help on any of these points would be greatly appreciated, thank you!