How to manage with BigQuery dataset
Hello,
I have to work on BigQuery dataset and I would like to know what is the more efficient way to structured data into DOMO ?
Some fields are ok but some are aggregated and not understand by DOMO. For example, geo field is aggregated like that
[FieldValue{attribute=PRIMITIVE, value=Europe}, FieldValue{attribute=PRIMITIVE, value=France}, FieldValue{attribute=PRIMITIVE, value=Normandy}, FieldValue{attribute=PRIMITIVE, value=Valognes}, FieldValue{attribute=PRIMITIVE, value=Western Europe}, FieldValue{attribute=PRIMITIVE, value=(not set)}]
How did you manage your data coming from BigQuery ?
Thank you for your help,
Philippe.
Comments
-
Hi Dojo User,
Each use case with this connector is customer-specific/dataset-specific. Could you please open a Domo Support case & provide us with links to your dataset in Domo, with a brief description of the data in your dataset & what you are expecting to extract from it. Below I have linked our Domo KB Articles alongside the BQ API docs.
"Domo+Google BigQuery Connector"
"Big Query API"
https://cloud.google.com/bigquery/docs/reference/rest/
*Please review the documentation above^ to help you better understand the Domo+Google BQ Connector you are working with today.
Please let me know if you have any other concerns at this time by replying to this message with any additional insights or questions that may arise.
Thank You,
- RR0
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