Snowflake End Points

Summary

Following are the list of APIs provided by Account Credential service specific to Snowflake Vendor.

End Points

POST api/v1/credentials/snowflake/user

This API is used for creating a new Snowflake credential

Example Request

{
"organization_id": "12345",
"account_id": "123456789012",
"provider_info": {
"region": "us-west-2",
"cost_report_spec": {
"org": "apptio",
"account": "prod1",
"db": "cldy_poc_db",
"schema": "cldy_poc_db.public",
"user": "cldy_poc_user"
}
}
}         

Example Response

UUID:
b07e9611-12cf-4c37-b30b-1ccb35b89299

PUT api/v1/credentials/snowflake/user/{id}

This API is used for updating the credential with the given ID

Example Request

{
"organization_id": "12345",
"account_id": "123456789012",
"provider_info": {
"region": "us-west-2",
"cost_report_spec": {
"org": "apptio",
"account": "prod1",
"db": "cldy_poc_db",
"schema": "cldy_poc_db.public",
"user": "cldy_poc_user"
}
}
}

GET api/v1/credentials/snowflake/user/{id}

This API is used for getting credential details.

GET api/v1/credentials/snowflake/user/template/{id}

This API is used for getting template details.

POST api/v1/credentials/{id}/verification

This API is used for verification purposes.

DELETE api/v1/credentials/vendors/Snowflake/organizations/<org_id>/accounts/<account_id>

This API is used for deleting an account.

GET api/v1/credentials/accounts/trees?organizationId=<org_id>&vendorId=137

This API is used for getting all account detail (Tree API).

GET api/v1/credentials/accounts/trees?organizationId=<org_id>&vendorId=137

This API is used for getting permissions list.

POST api/v1/credentials/vendors/Snowflake/organizations/<org_id>/accounts/<account_id>/archive

This API is used for archiving a Snowflake account.