page242
329
Similar information is available using the
SHOW
command.
SHOW MANAGED ACCOUNTS;
Please make a note of the JSON
accountLocator
or
locator
attribute, which you will
use to import the share. In this example, this value is
HR83528
.
You will also require the
accountLocatorURL
or
account_locator_url
value to
create a user, as shown next. In this example, the value is
https://hr83528.eu-west-2.
aws.snowflakecomputing.com/
.
You can find more information on managed accounts at
https://docs.snowflake.
com/en/user-guide/data-sharing-reader-create
.
Creating Share Containers
You will extend your
tpc
database by creating new containers. Figure 9-7 shows both
existing and new containers you will create within this section.
Figure 9-7.
Container creation
First create a share called
share_poc
where
poc
represents “proof of concept”:
USE ROLE accountadmin;
CREATE SHARE IF NOT EXISTS share_poc;
To display all shares within your account, use this:
SHOW SHARES IN ACCOUNT;
Chapter 9
Client expeCtations