BigQuery connector unexpected converts String to Number
Hello Community,
I'm using the Google BigQuery Service connector.
I found an unexpected behaviour truncating long numeric strings.
fullVisitorID is a string in BQ schema, even though this arrives in Domo as a string (when using BigQuery schema in the connector settings); there is a weird behaviour where the long numeric string is truncated to number and transformed to exponential form.
For example instead of
10139350147955357369 the string that appears in Domo is 1.0139350147955357E19
Has anyone experienced this?
Thanks for any comments
Comments
-
You may need to reach out to Domo Support to get this investigated
1 -
Hi,
It's a bit hacky but you could try and force Domo to read it as a string.
In the query you can add an arbitrary letter to the string so it is not possible for the value to be interpreted as a numeric value.
For example instead of
SELECT fullVisitorID FROM tablename;
use something like:
SELECT CAST(concat(fullVisitorId,'A') AS STRING) as fullVisitorID from tablename;
then there should be no way Domo can read it as a string and you can preserve all the precision of the value.
hope that helps
1 -
Awesome, thanks for that.
Works like a charm, bit hacky but this will do for the moment.
I've already commented on Ideas Sharing, for having the developers to look into it.
Thanks!
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 294 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 707 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive