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
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 602 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 697 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive