question

DataArtist avatar image
0 Votes"
DataArtist asked emilyhua-msft edited

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

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/

office-visio-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

emilyhua-msft avatar image
1 Vote"
emilyhua-msft answered emilyhua-msft edited

@DataArtist

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.

· 6
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@DataArtist
I am checking this thread, if you have any updates or questions, you may post back and discuss with us.

0 Votes 0 ·

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 ?


109475-image.png


0 Votes 0 ·
image.png (54.3 KiB)

@DataArtist
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.


1 Vote 1 ·
Show more comments