How can I access Views using Google Big Query Service Account connector?


I have an gbq service account connector in my domo instance to access tables of a gbq dataset. however, i cannot access the views.
Best Answers
-
Are you using the Table Data report or the Query report? Have you tried using the Query report and querying against the view?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
@dmurgit1 When working with the BigQuery Service Account connector, I usually just use the custom query report and then do 'SELECT * FROM MY_VIEW' as the query.
I'm not sure if the connector has a view report like the table report. I usually run my queries in GCP to make sure they run properly, then add the query to the connector settings in Domo.
1
Answers
-
Are you using the Table Data report or the Query report? Have you tried using the Query report and querying against the view?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Could you please explain me more about your query?
0 -
I wanted to be able to browse the available views in a GBQ dataset. Looking for a View option with the Query and Table Data Reports.
0 -
@dmurgit1 When working with the BigQuery Service Account connector, I usually just use the custom query report and then do 'SELECT * FROM MY_VIEW' as the query.
I'm not sure if the connector has a view report like the table report. I usually run my queries in GCP to make sure they run properly, then add the query to the connector settings in Domo.
1
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Data Connections
- 1.3K Connectors
- 309 Workbench
- 17 Cloud Integrations
- Data & ETL
- 2.3K Magic ETL
- 120 SQL DataFlows
- 666 Datasets
- 827 Beast Mode
- Visualize & Apps
- 90 App Studio
- 198 Pro-code Components
- 2.6K Charting & Analyzer
- 46 Calculations & Variables
- AI & Data science
- 23 Domo AI & AI Chat
- 4 Managing AI
- 18 Jupyter Workspaces
- 122 Workflows
- Distribute
- 118 Domo Everywhere
- 284 Reporting
- Manage
- 145 Governance & Security
- 489 APIs
- 11 Add-ins & Plugins
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 117 Community Announcements
- Automate
- 5K Archive