Multiple ways to connect Snowflake warehouses to collibra
Hey, we have 5 Snowflake warehouses and want to connect them with Collibra.
But instead of making 5 different connections with Collibra, there is mentioned we could use one snowflake warehouse as master that reads from the other 4 snowflake warehouses to the master snowflake warehous and collibra only reads that from the master. Is that a logical design decision?
We could do that by doing this in snowflake:
grant select on all tables in schema TABLE.PUBLIC to role DATA_OWNER;
Adem Gungormus
Posted 2 years ago ยท Edited 1 year ago
0 comments