Json parameter problem form Get Metadata activity to Stored Procedure

Kvaratshelya, Vladimir 5 Reputation points
2023-05-09T14:32:43.0033333+00:00

I have a pipeline with Metadata Activity, which looks up the parquet file structure and passes it to the stored procedure, which creates table in serverless sql pool.

User's image

Json parameter is

@string(activity('Get Metadata1').output.structure)

The input of Stored procedure look like this:

User's image

But, it doesn't create the table because something is wrong with json parameter. When I pass it as string in stored procedure, it works.

User's image

Any help is appreciated.

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.
4,557 questions
{count} votes