Thanks for the reply but I am still facing problems,
When I try to query _metadata.row_id directly in SQL I still get the same error (see attached screenshots).