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.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Data Types for Decimals/Currency Appsheet > Bigquery

Posted on 06-18-2022 10:20 AM
jstreit
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

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. 

0 27 960
Topic Labels
0 Likes
27 REPLIES 27

Posted on --/--/---- --:-- AM
Steve
Platinum 4
Platinum 4
Reply posted on --/--/---- --:-- AM

Please contact AppSheet Support for help with this.

https://www.appsheet.com/Support/Contact

Posted on --/--/---- --:-- AM
arriedewaal
Bronze 3
Bronze 3
In response to Steve
Reply posted on --/--/---- --:-- AM

Hi Steve,

Thanks for all the great replies.

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?

Thanks

0 Likes

Posted on --/--/---- --:-- AM
arriedewaal
Bronze 3
Bronze 3
In response to arriedewaal
Reply posted on --/--/---- --:-- AM

above @Steve 

0 Likes

Posted on --/--/---- --:-- AM
JAG
Bronze 1
Bronze 1
In response to arriedewaal
Reply posted on --/--/---- --:-- AM

appsheetVSbigquery.png

This may help to make some decisions.

0 Likes

Posted on --/--/---- --:-- AM
Steve
Platinum 4
Platinum 4
In response to arriedewaal
Reply posted on --/--/---- --:-- AM

I've never used BigQuery, nor am I familiar with the available documentation for its use an AppSheet.

0 Likes

Posted on --/--/---- --:-- AM
JAG
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

So... Has there been any update to the support for BQ FLOAT columns?

There are still errors being produced for the simplest cases, which is AppSheet Decimal type mapping to BigQuery Float columns.


Unable to update row in table 'table3'. โ†’ Failed to update rows (big_query): Unable to use value of type System.Decimal in BigQueryParameter

@jstreit wrote:

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. 

0 Likes

Posted on --/--/---- --:-- AM
Steve
Platinum 4
Platinum 4
In response to JAG
Reply posted on --/--/---- --:-- AM

I am unaware of any changes. Please contact AppSheet Support for help with this.

Attn @Aleksi @Rob_Just

0 Likes

Posted on --/--/---- --:-- AM
JAG
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

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.

0 Likes

Posted on --/--/---- --:-- AM
jstreit
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

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.

0 Likes

Posted on --/--/---- --:-- AM
JAG
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

There's ANOTHER MAJOR BUG as well. Null values cannot be entered period. All data types are affected. Not possible! Incredible!

0 Likes

Posted on --/--/---- --:-- AM
JAG
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

These BUGS are very easy to reproduce.

Go to BigQuery in Google Cloud Console

  • Create a new table
  • Add a new column, FLOAT

Go to AppSheet

  • Create a new application
  • Choose the BigQuery data source
  • Choose the table created above
  • Wait for the new application to be created
  • Now try to enter some data into the table

You should see an error that says "Unable to use value of type System.Decimal in BigQueryParameter"

 

0 Likes

Posted on --/--/---- --:-- AM
JAG
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

FYI, AppSheet Support has been contacted. But of course, this may awhile for any kind of resolution.

If anyone is hitting these bugs then please add a comment or two here. A larger crowd always gets more notice.

0 Likes

Posted on --/--/---- --:-- AM
JAG
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

For a MAJOR BUG like this, you'd think that someone from the AppSheet team would be piping, and asking for more details. ๐Ÿ˜ฉ

0 Likes

Posted on --/--/---- --:-- AM
JAG
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

@jstreit Can you add "[BUG]" to the title? Maybe that will get some attention.

0 Likes

Posted on --/--/---- --:-- AM
JAG
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

Received this from AppSheet support...

Hello ...,

Thanks for your patience on this.

I'll need to consult the AppSheet engineering team regarding your issue.

We're attempting to reproduce this locally, so please allow us some time to review your request and investigate your issue.

AppSheet engineering may contact you directly through this channel If they need additional information.

Posted on --/--/---- --:-- AM
JAG
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

Still waiting for a reply from AppSheet support / engineering... If only there was someway to post a bug to AppSheet. โ˜น๏ธ

0 Likes

Posted on --/--/---- --:-- AM
Rob_Just
Staff
In response to JAG
Reply posted on --/--/---- --:-- AM

Hello JAG,

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.

Thanks!

Posted on --/--/---- --:-- AM
julianjones
Staff
Reply posted on --/--/---- --:-- AM

Hey all,

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.

Best,

Julian

Posted on --/--/---- --:-- AM
Abnersi
Bronze 2
Bronze 2
In response to julianjones
Reply posted on --/--/---- --:-- AM

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

0 Likes

Posted on --/--/---- --:-- AM
JAG
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

I sure hope the release contains fixes for both BUGS.

0 Likes

Posted on --/--/---- --:-- AM
JAG
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

October 3rd Release... ๐Ÿ˜ฒ

Bug fixes

None ๐Ÿ˜ฉ

0 Likes

Posted on --/--/---- --:-- AM
Koichi_Tsuji
Gold 4
Gold 4
In response to JAG
Reply posted on --/--/---- --:-- AM

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.

 

@Steve 

Posted on --/--/---- --:-- AM
JAG
Bronze 1
Bronze 1
In response to Koichi_Tsuji
Reply posted on --/--/---- --:-- AM

Agreed. The announcement was way before being ready for prime time.

Hopefully, Google will spend some resources to fix this interface.

Posted on --/--/---- --:-- AM
Steve
Platinum 4
Platinum 4
In response to Koichi_Tsuji
Reply posted on --/--/---- --:-- AM

@lizlynch ^^

0 Likes

Posted on --/--/---- --:-- AM
julianjones
Staff
Reply posted on --/--/---- --:-- AM

Hi all,

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.

Best,

Julian 

Posted on --/--/---- --:-- AM
JAG
Bronze 1
Bronze 1
In response to julianjones
Reply posted on --/--/---- --:-- AM

@julianjones Thanks for the update.

I was following the release notes, but did not see any mention of the bug fix. It certainly would have been nice to see the mention.

0 Likes

Posted on --/--/---- --:-- AM
JAG
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

@julianjones Thanks for the fixes.

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.

๐ŸŽ‰๐ŸŽ‰๐ŸŽ‰๐ŸŽ‰

Top Labels in this Space