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.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 282 Workbench
- 3 Cloud Amplifier
- 4 Federated
- 2.8K Transform
- 86 SQL DataFlows
- 548 Datasets
- 2.2K Magic ETL
- 3.2K Visualize
- 2.3K Charting
- 544 Beast Mode
- App Studio
- 26 Variables
- 566 Automate
- 134 Apps
- 411 APIs & Domo Developer
- 21 Workflows
- DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 345 Distribute
- 87 Domo Everywhere
- 257 Scheduled Reports
- 1 Software Integrations
- 85 Manage
- 84 Governance & Security
- 8 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 81 Community Announcements
- 4.8K Archive