Configuring your Snowflake destination.
SHOW GRANTS TO USER <your_username>;
and review the role
column.)schema
By default, a new schema (with a name you provide) will be created in the target Snowflake database upon the initial connection. If instead you create the schema
ahead of time, you may remove the CREATE SCHEMA
permission, and instead grant ALL PRIVILEGES
on the target schema
for the designated role
.The script below can be used to complete this step:warehouse
or database
By default, this script creates a new warehouse and a new database. If you’d prefer to use an existing warehouse/database, change the warehouse_name
variable from TRANSFER_WAREHOUSE
to the name of the warehouse to be shared/database_name
variable from TRANSFER_DATABASE
to the name of the database to be shared.Statement executed successfully
in the query results.SHOW
query returns no results), you can skip to Step 3.CREATE NETWORK POLICY
command to specify the IP addresses that can access your Snowflake warehouse.ALLOWED_IP_LIST
will be blocked. Snowflake does not allow setting a network policy that blocks your current IP address. (An error message results while trying to create a network policy that blocks the current IP address.) But be careful when setting your first network policy.