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": ""
}

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

peer

object

required

Configuration of the peer to be created.

Show peer

name

string

required

The name of the peer to be created.

type

required

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

snowflake_config

object

required

Configuration for the Snowflake peer

Show snowflake_config

account_id

string

required

The account ID of the Snowflake server.

username

string

required

The username to connect to the Snowflake server.

private_key

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).

database

string

required

The database to connect to.

warehouse

string

required

The warehouse to connect to.

role

boolean

required

The Snowflake role to connect to.

query_timeout

number

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

password

string

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

allow_update

boolean

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

Response Fields

status

CREATED|FAILED

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

message

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": ""
}

Create a Kafka peer Create mirror

⌘I

​Request Fields

​Response Fields

Request Fields

Response Fields