How to connect SQL to use many schema? it is mandatory field, what is format for multiple values?
j
Jan Soubusta
04/22/2022, 3:32 PM
If you work with GoodData.CN, multiple schemata are supported only in case of Drill and Dremio. How much does this block you?
t
Tom Chen
04/22/2022, 3:34 PM
it totally blocks my work as I have relational data need to import on multiple schema. I am using goodata cloud not community version for a poc.
j
Jan Soubusta
04/22/2022, 3:37 PM
Let me discuss it internally, I will get back to you as soon as possible.
t
Tom Chen
04/22/2022, 3:46 PM
thanks
m
Martin Burian
04/22/2022, 4:17 PM
Tom, there are 2 ways ...
1. create view in schema X for every table you want to use and use schema X
2. use multiple datasources with different schemas
I recommend to go with 1.