A database is a logical grouping of schemas. Each database belongs to a single Snowflake account.
A schema is a logical grouping of database objects (tables, views, etc.). Each schema belongs to a single database.
Joe Kokomo has a Snowflake account.
Joe has a car dealership in New York. Joe's database is named JOE_DB.
pronounded JODIE-B.
Joe Piscapo has a Snowflake account.
Joe has a car dealership in Nebraska. Joes' database is named JOE_DB.
pronounced JODIE-B.
These databases contain the exact same data.
3000 rows of data purchased from Car Dealers Consortium in Denver CO.
Recap:
Same name.
Same physical properties.
Same content.
Different accounts.
The question is 'can the same database exist in more than1 Snowflake account'.
100% of you say no.
The question is where the single database (instance) can exist across multiple accounts. Replication creates a separate instance and keeps it in sync with primary DB, but the DB instance can only belong to one account. Its a tricky question
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Sundarr
Highly Voted 2 years, 9 months agoRad1941
Most Recent 1 month, 3 weeks agoMallikharjuna452
4 months agoAnireddySaikiranReddy
8 months, 3 weeks ago_yyukta
8 months, 4 weeks agoFeb01
10 months, 1 week agoKHarish
11 months, 2 weeks agoShanvi_27
1 year, 1 month agoMultiCloudIronMan
1 year, 4 months agoRavi9292
1 year, 4 months agoinstride
1 year, 5 months agoMayuri917233
1 year, 6 months agoc0d3g
1 year, 6 months agoNiranjanData
1 year, 9 months agoTapasgup007
1 year, 11 months agoPercy2112
2 years, 3 months agograbc
2 years, 9 months agoDingDongSingSong
2 years, 6 months ago