Use Cargo on Snowflake
✅ What Cargo can do
Read data from schemas and tables, even if they are spread across multiple databases,
Writes them into new schemas and tables
❌ What Cargo will never do
Overwrite existing schemas and tables
(instead it always creates its own schemas and tables when needed)
To achieve all of this, some setup is required to ensure that Cargo has the necessary permissions in Snowflake
Create a dedicated DB for Cargo needs
Create a dedicated DB for Cargo needs (all data managed by Cargo will be stored here)
Create a user for Cargo
Grant the necessary permissions for Cargo to run commands as an authenticated user on the database you just created above
Make sure the Cargo user has access to the following permissions on cargo_db
:
OWNERSHIP
MODIFY
MONITOR
USAGE
CREATE SCHEMA
You can use the following command to check the granted privileges of the database
For Snowflake accounts hosted on GCP and Azure
Make sure you provide an RSA private key while creating your account
This key is linked to your user. It will automatically ingest data in your Snowflake instance
To start, open a terminal window and generate a private key
Then generate a public key
Execute an ALTER USER
command to assign the public key to your Snowflake user.
And copy-paste the private key in your workspace configuration
Allowed IP Addresses
If you're using Snowflake's Allowed IPs network policy, you'll need to add the Cargo IP addresses to your list. Please contact aurelien@getcargo.io to have this configured for you.
Setup completed 🎉
You are ready to use Cargo!
Last updated