Can we do Data modeling in Visio by connecting to GCP Bigquery?

Question

Can we do Data modeling in Visio by connecting to GCP Bigquery?

Mudassar A 491

Can we do Data modeling in Visio by connecting to GCP Bigquery or we need to use any specific tool to achieve this ?

Goal- Is to draw a Data model of the existing GCP Bigquery Dataset tables\views.

I was looking for fast method which can read the schema and let me arrange the tables in the Data model diagram/

1 answer

Your answer

Answer 1

Emily Hua-MSFT 27,796

@Anonymous

To create a Database Model in Visio, we may use Database Model Diagram template, and select the database driver for database management system (DBMS). After searching online, currently, there are BigQuery ODBC drivers to let some applications connect to BigQuery, such as Excel. (Please note, the drivers can be downloaded for free. Queries run using the driver are charged based on how the driver is configured. Besides, Since the 2 web sites are not hosted by Microsoft, the links may change without notice. Microsoft does not guarantee the accuracy of this information.)

But as we do not have the test environment with GCP Bigquery, I could not test for you to verify that wether Visio supports this connections. Thanks for your understanding.

------------------
Update -------------------

Currently, we are unable do Data modeling in Visio by connecting to GCP Bigquery.

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Emily Hua-MSFT 27,796 Reputation points

2021-06-24T08:05:34.423+00:00

@Anonymous
I am checking this thread, if you have any updates or questions, you may post back and discuss with us.
Mudassar A 491 Reputation points

2021-06-25T19:22:37.76+00:00

II downloaded Symbian driver and it shows me the below screenshot when I launched from Visio .

I am not sure what inputs I need to give here.

Given the Popularity of Big Query and other Cloud datawarehouse ,the Visio team should have done some content around how to connect and work with these databases . But looks like the support for Visio is not great .

Do you know by the way what inputs I may have to provide here ?
Emily Hua-MSFT 27,796 Reputation points

2021-06-30T10:11:22.473+00:00

@Anonymous
Sorry for delay.
Currently, I find the following blog, maybe you could have a look.
Connect to BigQuery from Microsoft Excel using ODBC
((Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information. Besides, due to the limitations of the test conditions, I did not verify this process, thanks for your understanding.)

Any further issues, it‘s also recommended to contact Google Cloud support team.
Mudassar A 491 Reputation points

2021-06-30T21:29:59.15+00:00

I was able to connect using Simba driver
using the below document .

https://storage.googleapis.com/simba-bq-release/odbc/Simba%20Google%20BigQuery%20ODBC%20Connector%20Install%20and%20Configuration%20Guide.pdf
But again Visio lets us down as the Reverse engineer wizard is so worse that it doesn't even expand to see all the objects .

If Microsoft can come up with a better data modeling tool to cover the deficiencies of Visio and PowerBI( cant generate diagrams and not much customization) it will be great .
Mudassar A 491 Reputation points

2021-06-30T21:33:41.527+00:00

Even after connecting again the Visio failed.
Emily Hua-MSFT 27,796 Reputation points

2021-07-01T07:26:15.427+00:00

@Anonymous
Thanks for your sharing.
So far, the answer to this thread is no, I will update my previous reply later.
I would suggest you go to Visio > Feedback > I Have a Suggestion, then submit on this request to let Visio development team know which feature are most important to you.

Share via

Can we do Data modeling in Visio by connecting to GCP Bigquery?

1 answer

Your answer