Cursor sql error on postgres FDA table

I'm connecting to a postgres database on AWS via FDA but getting errors on the primary key.

The table is called transactions and has an attribute called betId as a unique primary key field.

When I access the data in the table (via schema data view) I either get an error that primary key needs to be defined or when I define betId as primary key a sql error for cursor:
ERROR: column a0.betid does not exist.

'SELECT A0.betId FROM adobe.transactions A0 LIMIT 200' could not be executed.

Schema definition:
<key internal="true" name="pid" noDbIndex="true">
  <keyfield xpath="@id"/>
</key>
<attribute advanced="false" label="betId" name="id" length="16" sqlname="betId" type="string"/>