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:

repcli remove database=target dbtype=snowflake \
account=account region=region warehouse=warehouse \
user=username password=password \
dbname=databaseName

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.