Body
application/json
the warehouse credentials to create
curl --request POST \
--url http://api/v1/org/warehouse-credentials \
--header 'Content-Type: application/json' \
--data '
{
"credentials": {
"sshTunnelPrivateKey": "<string>",
"sshTunnelPublicKey": "<string>",
"sshTunnelUser": "<string>",
"sshTunnelPort": 123,
"sshTunnelHost": "<string>",
"useSshTunnel": true,
"timeoutSeconds": 123,
"startOfWeek": 0,
"ra3Node": true,
"sslmode": "<string>",
"keepalivesIdle": 123,
"threads": 123,
"schema": "<string>",
"dbname": "<string>",
"port": 123,
"requireUserCredentials": true,
"password": "<string>",
"user": "<string>",
"host": "<string>",
"type": "redshift"
},
"description": "<string>",
"name": "<string>"
}
'{
"results": {
"credentials": {
"type": "snowflake",
"account": "<string>",
"requireUserCredentials": true,
"authenticationType": "password",
"role": "<string>",
"database": "<string>",
"warehouse": "<string>",
"schema": "<string>",
"threads": 123,
"clientSessionKeepAlive": true,
"queryTag": "<string>",
"accessUrl": "<string>",
"startOfWeek": 0,
"quotedIdentifiersIgnoreCase": true,
"override": true,
"organizationWarehouseCredentialsUuid": "<string>"
},
"createdByUserUuid": "<string>",
"createdAt": "2023-11-07T05:31:56Z",
"warehouseType": "bigquery",
"description": "<string>",
"name": "<string>",
"organizationUuid": "<string>",
"organizationWarehouseCredentialsUuid": "<string>"
},
"status": "ok"
}Create new warehouse credentials for the organization
curl --request POST \
--url http://api/v1/org/warehouse-credentials \
--header 'Content-Type: application/json' \
--data '
{
"credentials": {
"sshTunnelPrivateKey": "<string>",
"sshTunnelPublicKey": "<string>",
"sshTunnelUser": "<string>",
"sshTunnelPort": 123,
"sshTunnelHost": "<string>",
"useSshTunnel": true,
"timeoutSeconds": 123,
"startOfWeek": 0,
"ra3Node": true,
"sslmode": "<string>",
"keepalivesIdle": 123,
"threads": 123,
"schema": "<string>",
"dbname": "<string>",
"port": 123,
"requireUserCredentials": true,
"password": "<string>",
"user": "<string>",
"host": "<string>",
"type": "redshift"
},
"description": "<string>",
"name": "<string>"
}
'{
"results": {
"credentials": {
"type": "snowflake",
"account": "<string>",
"requireUserCredentials": true,
"authenticationType": "password",
"role": "<string>",
"database": "<string>",
"warehouse": "<string>",
"schema": "<string>",
"threads": 123,
"clientSessionKeepAlive": true,
"queryTag": "<string>",
"accessUrl": "<string>",
"startOfWeek": 0,
"quotedIdentifiersIgnoreCase": true,
"override": true,
"organizationWarehouseCredentialsUuid": "<string>"
},
"createdByUserUuid": "<string>",
"createdAt": "2023-11-07T05:31:56Z",
"warehouseType": "bigquery",
"description": "<string>",
"name": "<string>",
"organizationUuid": "<string>",
"organizationWarehouseCredentialsUuid": "<string>"
},
"status": "ok"
}the warehouse credentials to create
Was this page helpful?