page247
334
Importing a Share
Once your share has been populated and entitled for a consuming account, you must
log in to your new managed account. In this example, the URL is
https://hr83528.eu-
west-2.aws.snowflakecomputing.com
; yours will differ.
Using the managed account credentials repeated next, log in to your managed
account.
ADMIN_NAME = 'poc_admin'
ADMIN_PASSWORD = 'POC_admin_123'
Importing shares is performed by the
ACCOUNTADMIN
role:
USE ROLE accountadmin;
SHOW SHARES IN ACCOUNT;
You should see two inbound shares. Note that
SNOWFLAKE
is provided by Snowflake
Inc. You should also see
database_name
is unpopulated for the new share. You create a
database (see Figure 9-9).
Figure 9-9.
Inbound share listing
You now create a database from the inbound share. Note that the owner account and
share name will differ from yours.
CREATE DATABASE share_poc_database
FROM SHARE ACXELCQ.ZI95050.share_poc;
Now check that the
database_name
attribute is populated for your share.
SHOW SHARES IN ACCOUNT;
You should also see the new database listed in the database browser when refreshed,
as shown in Figure 9-10.
Chapter 9
Client expeCtations