Hi GD Cloud team! This is a question for connectin...
# gooddata-cloud
n
Hi GD Cloud team! This is a question for connecting tables: We have a lot of customized area for our clients, witch make the data headers for different clients are slightly different. but also customized data has a standard header format {Data xx}. for example client A has header ["Address", "Number", "Data Sales", "Data Sales Lead"], for the same table, client B could have header ["Address", "Number", "Data Kickoff Call Date"], and the value under the header is the object id of the entity. and the entities have been saved in another table with primary key Id. Question: 1. Is that possible to use a universal Logical Data Model for all our clients? 2. Is that possible to connect entities with table {data xx} part automatically? p.s. I saved my data in BigQuery to store my data.
i
Hi again Neal, Have you already tried to connect your BigQuery schema to GD to check how model gets created automatically based on your data source? Do you plan to work with multi-tenant environmental with a Parent and child workspaces sharing the same model, is this the case?
n
Thank you Ivana! Yes! I already connected BigQuery to GD. Yes, that's my plan, but if assigning every client a separate workspace could help, there's no limit for using separate workspace than parent - child environment.
i
Hey Neal, Nice, thank you for the confirmation. What is the plan here then, please? To have one main model and some additive entities in child workspaces? Here are some information about multi-tenant setup: https://www.gooddata.com/docs/cloud/workspaces/
n
Thanks for you reply! My Question is: I have 10 tables which have multiple columns. Some of the columns are in format: {Data: xx}. This "xx" can be replaced by anything our clients want. and the cells under these columns is the object Id of the information. I have another table called "Data" which has a column of object Id which is the same as the object ID in the cells of the first 10 tables if they should be connected.
So, Does GD has a mechanism to do this connection automatically? like link any label with data: to the data table?
i
He Neal, Connections are actually inherited from your data source, unless you manually change them.
Some hints about the modeling and table connections can be found also in our free university.