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.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 621 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 744 Beast Mode
- 58 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive