page248
335
Figure 9-10.
Imported database listing
Now create a warehouse.
CREATE OR REPLACE WAREHOUSE poc_wh WITH
WAREHOUSE_SIZE = 'X-SMALL'
AUTO_SUSPEND = 60
AUTO_RESUME = TRUE
MIN_CLUSTER_COUNT = 1
MAX_CLUSTER_COUNT = 4
SCALING_POLICY = 'STANDARD'
INITIALLY_SUSPENDED = TRUE;
Set your session context to use your newly created warehouse.
USE WAREHOUSE poc_wh;
And later test your imported database once
v_region
has been provisioned (next) to
ensure you can
SELECT
data.
SELECT r_name,
r_comment
FROM share_poc_database.share_owner.v_region;
Imported databases are owned by the
ACCOUNTADMIN
role by default. Your client must
create their own roles and grant entitlements for their internal use.
Chapter 9
Client expeCtations