This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I am a little stumped trying to use BigQuery as a data source.
One table has a field for price/currency. The table in BigQuery has a data type of FLOAT, initially I had Appsheet set to Price but I get a error that reads:
Cannot create parameter HEADER_TOTALr0 of type Float64 with value 4.35 of type System.Decimal
I tried to test other data type configs on both sides but regardless of what I have set for datatype on Appsheet or BigQuery.
Has anyone come across this?
I've been using a small CloudSQL instance with the same app for quite some time without issue.
I'm busy setting up my BigQuery db, is there a guide for which data types in BigQuery works best for which data types in AppSheet? Or should I just make all String as in a spreadsheet?
I am a little stumped trying to use BigQuery as a data source.
One table has a field for price/currency. The table in BigQuery has a data type of FLOAT, initially I had Appsheet set to Price but I get a error that reads:
Cannot create parameter HEADER_TOTALr0 of type Float64 with value 4.35 of type System.Decimal
I tried to test other data type configs on both sides but regardless of what I have set for datatype on Appsheet or BigQuery.
Has anyone come across this?
I've been using a small CloudSQL instance with the same app for quite some time without issue.
This is a HUGE BUG. There is no way to enter data into BQ tables that contain FLOAT columns, or NUMERIC columns. This includes the AppSheet data types DECIMAL, PERCENT, and PRICE. The data types cannot be saved to BQ tables.
Yeah I had the same issue still. I was testing it for a small personal project so I just left everything in cloud SQL but BigQuery doesn't seem like a fully viable data source right now.
We reached out earlier today via ticket to clarify some questions. Just wanted to give you a heads up in case you haven't seen the message.
Also, thanks for notifying us of this issue via support. We do take bugs like this seriously. I apologize for the delay but we are working on reproducing the issue and working with our engineering team.
We have been talking with some of the other engineers internally and were able to come up with a fix. Here we have just verified that we are able to add rows from Appsheet (Price and Decimal) to BQ type FLOAT. We are in the process of rolling this fix out to all users. The issue should be resolved once the release goes through today. Let us know if you have any other questions or concerns here.
Hey, it looks this turnaround no longer works and I saw a comment it was fixed, but seems like the problem is there again, im having exactly the same issue
I would say (unfortunately) the integation between AppSheet and BigQuery is well before the GA, as there are bunch of bugs. Not sure why GA is declared.
For us, it is before the preview release status, or maybe far more before.
As the fix was pushed on Friday it did take time to actually rollout to production. We can see as of today this should be fully rolled out and functional to everyone. On the days leading up to today if this was attempted you were likely tested on the un-updated version. This is my fault apologies for that misinformation, if you attempt this now though it should be ACTUALLY fixed. Again thanks everyone for your patience, and sorry for that confusion.
I ran a few simple tests of all data types, and confirmed that values are being inserted into BQ tables correctly. I also confirmed that NULL values can also be inserted.
LinkedIn
Twitter
