BigQuery as sink:- Write operation(INSERT) does not reflect any error while adding values to Table Key and Dedupe by Fields

Description

When using BigQuery as Sink, no error is reflected on performing (INSERT) write operation and proving values to Table Key and Dedupe By fields

Steps to reproduce:-

1.Open the BigQuery Sink
2.Click on properties.
3.Go to Advanced Operations
4.Select INSERT operation
5.Go to Table Key
6.Enter any random value which does not exist in the table/Exists in the table
7. Go to Dedupe By
8.Enter any random value which does not even exist in the table/Exists in the tale
9.Validate the properties
10.No error is reflected

Expected result:-

Table Key and Dedupe by should be disabled while using INSERT operations as per the documentation.
Table key :- Determines relation between tables during Update and Upsert operations.

Release Notes

None

Attachments

3

Activity

Show:

Prashant JaikumarAugust 10, 2021 at 5:08 PM

Reopening the bug the update the documentation.

RaginiAugust 10, 2021 at 5:51 AM

As discussed please re-open the bug.

Attached the screenshot for reference as

“Table Key and Dedupe by should be disabled while using INSERT operations as per the documentation”, these operations are only for Update and Upsert.

Prashant JaikumarAugust 6, 2021 at 6:44 PM

These fields are ignored when using Insert. They are only used for Update and Upsert.

This is WAI.

Unresolved
Pinned fields
Click on the next to a field label to start pinning.

Details

Assignee

Reporter

Reviewer

Fix versions

Priority

More fields

Created August 6, 2021 at 10:49 AM
Updated December 3, 2024 at 5:00 PM