feat(Google BigQuery Node): Return numeric values as integers

[riascho]

Summary

Google BigQuery returns a JSON response where numeric values are always strings. This PR adds the option to Return Integers as Numbers.

Test Setup

1. Create BigQuery Dummy Data

CREATE TABLE [INSERTDATASETNAME].dummy_data (
  string_column STRING,
  integer_column INT64,
  numeric_column NUMERIC(10, 2), -- Precision of 10 digits, 2 decimal places
  float_column FLOAT64,
  bignumeric_column BIGNUMERIC(20, 5), -- Precision of 20 digits, 5 decimal places
  date_column DATE
);

INSERT INTO [INSERTDATASETNAME].dummy_data (string_column, integer_column, numeric_column, float_column, bignumeric_column, date_column)
VALUES
  ('String 1', 10, 123.45, 3.14159, 1234567890.12345, '2023-01-01'),
  ('String 2', 20, 456.78, 2.71828, 9876543210.98765, '2023-02-02'),
  ('String 3', 30, 789.01, 1.61803, 1234567890.12345, '2023-03-03'),
  ('String 4', 40, 123.45, 3.14159, 9876543210.98765, '2023-04-04'),
  ('String 5', 50, 456.78, 2.71828, 1234567890.12345, '2023-05-05'),
  ('String 6', 60, 789.01, 1.61803, 9876543210.98765, '2023-06-06'),
  ('String 7', 70, 123.45, 3.14159, 1234567890.12345, '2023-07-07'),
  ('String 8', 80, 456.78, 2.71828, 9876543210.98765, '2023-08-08'),
  ('String 9', 90, 789.01, 1.61803, 1234567890.12345, '2023-09-09'),
  ('String 10', 100, 123.45, 3.14159, 9876543210.98765, '2023-10-10');

2. Set up BigQuery Node - Execute Query with your credentials
3. Run query select * from [INSERTDATASETNAME].dummy_data;

Related Linear tickets, Github issues, and Community forum posts

• https://linear.app/n8n/issue/NODE-1615/community-issue-google-bigquery-node-returns-integer-values-as-string

• Google BigQuery Node Returns Integer Values as String Instead of Number #10503

Review / Merge checklist

• PR title and summary are descriptive. (conventions)
• Docs updated or follow-up ticket created.
• Tests included.
• PR Labeled with release/backport (if the PR is an urgent fix that needs to be backported)

[ShireenMissi]

LGTM 🎉

[github-actions]

⚠️ Some Cypress E2E specs are failing, please fix them before merging

[cypress]

n8n    Run #7046

Run Properties:   Passed #7046  •  88139389ed: 🌳 🖥️ browsers:node18.12.0-chrome107 🤖 riascho 🗃️ e2e/*

Project	n8n
Branch Review	node-1615-google-bigquery-node-return-integer-values
Run status	Passed #7046
Run duration	04m 23s
Commit	88139389ed: 🌳 🖥️ browsers:node18.12.0-chrome107 🤖 riascho 🗃️ e2e/*
Committer	Ria
View all properties for this run ↗︎

---

Test results
Failures	0
Flaky	1
Pending	0
Skipped	0
Passing	432
View all changes introduced in this branch ↗︎

[github-actions]

⚠️ Some Cypress E2E specs are failing, please fix them before merging

[github-actions]

✅ All Cypress E2E specs passed

[janober]

Got released with n8n@1.62.1