Feeding few data for some Synapse tables

pmscorca 217 Reputation points


for a my Synapse Analytics solution I've a dedicated SQL pool and I need to feed some tables with few row data (10-15-20 rows). I've already used the INSERT ... VALUES statement, but repeating this instruction in a complete manner (for SQL Server I can write the INSERT keyword only one time).

Does it exist a more quick/efficient manner to solve a such issue? Thanks

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
3,797 questions
{count} votes