topic Re: Fabric GraphQl - How to create multiple record under single mutation. in Data Engineering

Fabric GraphQl - How to create multiple record under single mutation.

Anonymous — Mon, 03 Feb 2025 05:19:58 GMT

I am working on GraphQl In fabric. I am having a table which conatins 5 records. I want to create more twomore records in table. When I am tring below query getting some error.

For ex - In sql
INSERT INTO Student (ROLL_NO, NAME, ADDRESS, PHONE, AGE) VALUES
(1, 'Ram', 'Delhi', 'XXXXXXXXXX', 18),
(2, 'Ramesh', 'Gurgaon', 'XXXXXXXXXX', 18),

How can we achive this in Graph QL ?

Re: Fabric GraphQl - How to create multiple record under single mutation.

nilendraFabric — Mon, 03 Feb 2025 08:13:54 GMT

hello @Anonymous

there are two things which I want to emphasise

Primary key constraints (even `NOT ENFORCED`) are required for mutations, but these only enable single-row operations.
• Bulk operations aren’t listed as supported in Microsoft’s GraphQL API FAQ

Try this instead

mutation {
createStudent1: createStudent(item: {ROLL_NO: 1, NAME: "Ram", ...}) { result }
createStudent2: createStudent(item: {ROLL_NO: 2, NAME: "Ramesh", ...}) { result }
}

or you can explore stored proc approach for bulk inserts

something like this

CREATE PROCEDURE BulkBatchInsert
AS
BEGIN
BULK INSERT StagingStudents FROM 'data.csv' WITH (BATCHSIZE=100000);
INSERT INTO Students SELECT * FROM StagingStudents;
END;

please give it a try and let us know

thanks

Re: Fabric GraphQl - How to create multiple record under single mutation.

Anonymous — Mon, 03 Feb 2025 08:28:21 GMT

Hi @nilendraFabric,
Thanks for your quick respone.
I tried the above query but still unable to solve my issue. Below is the snapshot attched. Can you plz help me with this.

Re: Fabric GraphQl - How to create multiple record under single mutation.

nilendraFabric — Mon, 03 Feb 2025 08:36:49 GMT

You might have to change the syntax like this

mutation {
createempinfo1: createempinfo(item: {Id: 30, Name: "Rohan", Address: "Amravati"}) {
result
}
createempinfo2: createempinfo(item: {Id: 31, Name: "Raj", Address: "Nagpur"}) {
result
}
}

Re: Fabric GraphQl - How to create multiple record under single mutation.

Anonymous — Mon, 03 Feb 2025 08:58:53 GMT

can you help me in this ?

Re: Fabric GraphQl - How to create multiple record under single mutation.

nilendraFabric — Mon, 03 Feb 2025 09:12:29 GMT

There can be multiple reasons

Ensure pk is still valid

do try this

ALTER TABLE YourTable ADD CONSTRAINT PK_YourTable PRIMARY KEY NONCLUSTERED (Id) NOT ENFORCED;

And then try

mutation {
createempinfo1: createempinfo(item: {Id: 30, Name: "Rohan", Address: "Amravati"}) {
Id
Name
Address
}
createempinfo2: createempinfo(item: {Id: 31, Name: "Raj", Address: "Nagpur"}) {
Id
Name
Address
}
}

Re: Fabric GraphQl - How to create multiple record under single mutation.

nilendraFabric — Mon, 03 Feb 2025 09:32:41 GMT

Try to change the keys as well

Re: Fabric GraphQl - How to create multiple record under single mutation.

Anonymous — Mon, 03 Feb 2025 09:35:44 GMT

Unable to the first query which you had shared.

Re: Fabric GraphQl - How to create multiple record under single mutation.

nilendraFabric — Mon, 03 Feb 2025 09:38:49 GMT

Try to run it in warehouse

Re: Fabric GraphQl - How to create multiple record under single mutation.

Anonymous — Mon, 03 Feb 2025 09:42:45 GMT

We had ID column as PK already.

Re: Fabric GraphQl - How to create multiple record under single mutation.

nilendraFabric — Tue, 04 Feb 2025 14:33:48 GMT

Hello @Anonymous

I have created a new WH called Graphql_test and created one table

MyTable and

ALTER TABLE MyTable

ADD CONSTRAINT PK_MyTable PRIMARY KEY NONCLUSTERED (ID) NOT ENFORCED;

It was empty table .

I added it to graphql api
and use muttation to add two records, it worked

Please see if this is helpful