_RowNumber is forced to be the key of a Big Query database

[Julien]

Hi Community,

I'm trying to connect a Big Query database to a test App.

The platform forces the _RowNumber as key even if I set another columns. After hitting Save, the _RowNumber is set back as the key with this message :

The spreadsheet row number is being used as a key in the table '10316071_CTMP'. It's best to include an 'ID' column in the table.

In the App, when I try to edit a row, I get this error message :

Unable to update row in table '10316071_CTMP'. → The service bigquery has thrown an exception. No HttpStatusCode was specified. Job bigquery-305114/EU/job_871fc367_645c_4f1d_a84f_32792f47b6ab contained 2 error(s). First error message: Unrecognized name: _RowNumber at [1:817]: Message[Unrecognized name: _RowNumber at [1:817]] Location[query - ] Reason[invalidQuery] Domain[], Message[Unrecognized name: _RowNumber at [1:817]] Location[query - ] Reason[invalidQuery] Domain[]

Thanks for your help!