'How can I create an Entity Relationship diagram (ER) For BigQuery Tables/ Views [closed]
I have some complex BigQuery views that nest each other. I would like to map them in an ER diagram so they are easier to visualize. I can do t his manually but prefer a system that can create the mapping automatically.
Are there any tools that can accomplish this?
Solution 1:[1]
There are not know official google tool that provides such a feature from google side. Most of the diagram tools works like retrieving the schema information from google BigQuery and paste it on its services to have an image of it. On the web, there are some tools like dbschema, dataedo, quickdatabasediagrams to count some. Even small guides from know pages like this post how-to-create-an-entity-relationship-diagram-erd-for-bigquery from medium site.
As mention on google official documentation tutorials about data visualization, It can be achieved by using pandas, notebooks, data studio although it requires some effort to have something as you envision on your question.
If you have ideas to have that feature implemented on google BigQuery you can also open a feature request on google issue tracker.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 |