Datatype incompatibility when inserting data from AppSheet into BigQuery

AppSheet AppSheet Q&A
,
1

Hi, I’ve been testing the BigQuery integration with AppSheet, which since a few months ago it has allowed write access. However, I’m unable to for example create a new item because the datatypes that BigQuery uses aren’t the same as the ones that AppSheet uses. In the “type” selector in AppSheet I can only see a generic “number” type which is incompatible with “integer” or “numeric” from BigQuery. Is there a way to cast it into those types to resolve this issue? Thanks.

2

Hi @nlozano

I don’t have experience yet with BigQuery, but as “numeric” type in AppSheet you have:

  • Number

  • Decimal

  • Percent (close to Decimal)

  • Price (close to Decimal)

Would picking Decimal type in AppSheet do the trick ?

For reference:

Math expressions - AppSheet Help

section “Numeric Types”

1 Like
3

Thanks for replying. Decimal would not work either, as this is an issue with different types of integers used in AppSheet and BigQuery.

1 Like
4

@Steve would you have someone to tag on this topic ?

1 Like
5

BigQuery problems should go to Support.

1 Like
6

I asked internally about this issue. Someone more familiar with BQ than me said this particular issue should be referred to Support (confirming what I said earlier).

1 Like
7

I suggest having a look to the latest post here:

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Data-Types-for-Decimals-Currency-Appsheet-gt-Bigquery/m-p/474854#M187192

1 Like
8

Thanks for the responses, in the end the issue was in the BigQuery datatypes and we resolved it.

2 Likes