Hello,
You have mixed incompatible types between your AppSheet table columns and the the BigQuery table. It is unfortunate that the naming conventions amongst systems are not consistent.
To match things up correctly:
| AppSheet Type |
|
BigQuery Type |
| Number |
= |
INTEGER |
| Decimal |
= |
NUMERIC |
| Price |
= |
NUMERIC |
| Date |
= |
DATE |
| Time |
= |
TIME |
| DateTime |
= |
DATETIME |
| Yes/No |
= |
BOOLEAN |
| Ref |
= |
STRING |
| Enum |
= |
STRING |
| EnumList |
= |
STRING |
| Text |
= |
STRING |
| LongText |
= |
STRING |
| *Duration |
= |
STRING |
| I believe all others (yet to test) |
= |
STRING |
*I have found Duration to be problematic. Although there is a DURATION type in BigQuery, AppSheet does not appear to transform correctly to the BiqQuery type. Additionally, it doesn't seem that a STRING value from BigQuery is converted into Aduration at read time. I have needed to store/read durations as Text/STRINGS and then use a Virtual Column defined as type Duration to convert the Text column to a Duration. I have not re-tested in recent months to see if this has been addressed.
LinkedIn
Twitter
