Create a Snowflake peer - PeerDB Docs: Setup your ETL in minutes with SQL.

curl --request POST \
  --url http://localhost:3000/api/v1/peers/create \
  --header 'Authorization: Basic OmJsXPNrU3dhbjEyMw==' \
  --header 'Content-Type: application/json' \
  --data '{
	"peer": {
		"name": "snowflake_peer_via_api",
		"type": 1,
		"snowflake_config": {
            "account_id": "account_id",
            "username": "username",
            "private_key":"***",
            "database": "database",
            "warehouse": "warehouse",
            "role": "role",
            "query_timeout": 30,
            "password": "password"
		}
	},
	"allow_update":false
}'

{
	"status": "CREATED",
	"message": ""
}

curl --request POST \
  --url http://localhost:3000/api/v1/peers/create \
  --header 'Authorization: Basic OmJsXPNrU3dhbjEyMw==' \
  --header 'Content-Type: application/json' \
  --data '{
	"peer": {
		"name": "snowflake_peer_via_api",
		"type": 1,
		"snowflake_config": {
            "account_id": "account_id",
            "username": "username",
            "private_key":"***",
            "database": "database",
            "warehouse": "warehouse",
            "role": "role",
            "query_timeout": 30,
            "password": "password"
		}
	},
	"allow_update":false
}'

{
	"status": "CREATED",
	"message": ""
}

POST api/v1/peers/create

You can create a Snowflake peer using this endpoint. Here is the request and response format for creating a Snowflake peer.

Request Fields

object

required

Configuration of the peer to be created.

Show peer

string

required

The name of the peer to be created.

required

The type of peer to be created. The value for Snowflake is 1.

object

required

Configuration for the Snowflake peer

Show snowflake_config

string

required

The account ID of the Snowflake server.

string

required

The username to connect to the Snowflake server.

string

required

The private key in PEM or pk8 format to connect to the Snowflake server.If you are providing an encrypted key, please provide the password as a separate field (listed below).

string

required

The database to connect to.

string

required

The warehouse to connect to.

boolean

required

The Snowflake role to connect to.

number

The query timeout in seconds. The default is 30 seconds.

string

This is optional, if the private key provided is encrypted.

boolean

Whether you wish to update a peer with this name if it already exists. Default is false.

Response Fields

CREATED|FAILED

Whether the creation/update was successful. If yes, the value will be CREATED. Else it will be FAILED.

string

Error message if any

curl --request POST \
  --url http://localhost:3000/api/v1/peers/create \
  --header 'Authorization: Basic OmJsXPNrU3dhbjEyMw==' \
  --header 'Content-Type: application/json' \
  --data '{
	"peer": {
		"name": "snowflake_peer_via_api",
		"type": 1,
		"snowflake_config": {
            "account_id": "account_id",
            "username": "username",
            "private_key":"***",
            "database": "database",
            "warehouse": "warehouse",
            "role": "role",
            "query_timeout": 30,
            "password": "password"
		}
	},
	"allow_update":false
}'

{
	"status": "CREATED",
	"message": ""
}

​Request Fields

​Response Fields

Request Fields

Response Fields