This blog will show the comparison between executing a stored procedure using web activity for API for GraphQL and script activity. A stored procedure called usp_PipelineQueue which will return a list of pipelines for orchestration. The stored procedure is stored in Fabric SQL Database which serves as a metadata database. Prerequisite: Already configured item of … Continue reading Performance of API for GraphQL Web Activity vs Script Activity in Fabric Data Pipelines
Category: Fabric
When you extract a file into Fabric (LH or DW) Table from a CSV, you can leave columns as the default varchar(8000), or with additional work apply the proper data types.Some questions we seek to answer Does the correct data types improve performance, given that storage is delta parquet and not a SQL format ? … Continue reading Should you use Datatypes on Staging Tables in Fabric ?