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
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 655 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 811 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 80 App Studio
- 45 Variables
- 771 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 77 Workflows
- 23 Code Engine
- 36 AI and Machine Learning
- 19 AI Chat
- AI Playground
- AI Projects and Models
- 17 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 142 Manage
- 138 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive