7.2.5 Remove Repstance Database Objects in Snowflake Database

Note – In order to use the “remove” database command the database user must have sufficient privileges.

REST API:

• Endpoint: https://repstance_url/configure/database
• Method: POST
• Header:
  • Content-Type: application/json
  • X-Token: token
• Body:
  {    
    "command":"remove",
    "parameters":[
       ["database","target"],
       ["dbtype","snowflake"],
       ["account","account"],
       ["region","region"],
       ["warehouse","warehouse"],
       ["user","username"],
       ["password","password"],
       ["dbname","databaseName"]
     ]
  }

Server response:

• HTTP Status – status of the command, possible codes are:
  • 200 – if no error occurs
  • 422 – if error occurs
• Body:
  {
    "Status":"{Completed|Failed}",
    "Message":"The command execution details"
  }

CLI Syntax:

The input parameters are:

• database – Database role, the possible value is target – to remove Apply Process Objects
• dbtype – Type of RDBMS, the possible value is snowflake
• account – Snowflake Account name
• region – Snowflake Region name
• warehouse – Warehouse name
• user – Database User name
• password – Database User password
• dbname – Database name

How to find “Snowflake Account” and “Snowflake Region” is described in chapter 7.1.7 Prepare Snowflake as Target Database.