data types BigQuery --> Domo
Hi all,
I used the Google BigQuery connector to import in Domo a dataset directly from BQ. It worked, but I could not choose the data type for each column and the resulting Domo dataset has a numeric column when BQ had a string type.
I know I could convert the data types after the import, but I think it would be better to fix them during the first load.
Could you help me?
thanks
Comments
-
Hi
I think that it is Domo's problem that not only BQ but also column designation can not be done.
Unfortunately, with the current specification you need some kind of handling later.
You can either convert the column type later or you can either remove Flag "False" in DataFlow as below.select * from
(select 'False' as Flag, 'Dummy' as StringColumn),
(select 'True' as Flag, StringColumn from Table_A)----
BQだけでは無く、カラムの型指定ができないのは、Domoの問題だと思います。
残念ながら、今の仕様では後から なにかしらの手ほどきが必要です。
後からカラムの型を変換するか、下記の様にして、DataFlowでFlag "False" を除くかのいずれかになると思います。select * from
(select 'False' as Flag, 'Dummy' as StringColumn),
(select 'True' as Flag, StringColumn from Table_A)0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 623 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 60 App Studio
- 41 Variables
- 690 Automate
- 177 Apps
- 455 APIs & Domo Developer
- 48 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 397 Distribute
- 114 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 127 Manage
- 124 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive