Deploy error : same table to deploy in diffirent schema

[Pooja Sahu]

Hi All,

I have a table demoone which I have successfully deployed in Database DEV, schema - CUST.

Now I am trying to deploy the same error in Database TEST, schema CUST however this is not getting deploy and throwing an error.

See details below:

Deploying changes to db:snowflake://??@??.eu-west-2.aws.snowflakecomputing.com/test?Driver=Snowflake;warehouse=compute_wh;PWD=??;UID=??

  + demotableone .... ok

  + devtableintest .. 002002 (42710): SQL compilation error:

Object 'DEMOONE' already exists.

not ok

"snowsql" unexpectedly returned exit value 5

Reverting all changes

  - demotableone .... ok

Deploy failed

Sqitch Log  below:

Revert 4a1dbd93509d87de3c9e5605f9d62252cadf3eb3

Name:      demotableone

Committer: root <root@79034062ae94>

Date:      2021-08-10 12:11:12 +0000

    Add demotableone in dev schema.

Fail 3056e955424a836be92672b031dcdda563f3326e

Name:      devtableintest

Committer: root <root@79034062ae94>

Date:      2021-08-10 12:11:08 +0000

    Add new table in test database.

Deploy 4a1dbd93509d87de3c9e5605f9d62252cadf3eb3

Name:      demotableone

Committer: root <root@79034062ae94>

Date:      2021-08-10 12:11:05 +0000

    Add demotableone in dev schema.

Revert 4a1dbd93509d87de3c9e5605f9d62252cadf3eb3

Name:      demotableone

Committer: root <root@79034062ae94>

Date:      2021-08-10 12:07:54 +0000

    Add demotableone in dev schema.

Fail 3056e955424a836be92672b031dcdda563f3326e

Name:      devtableintest

Committer: root <root@79034062ae94>

Date:      2021-08-10 12:07:49 +0000

    Add new table in test database.

Deploy 4a1dbd93509d87de3c9e5605f9d62252cadf3eb3

Name:      demotableone

Committer: root <root@79034062ae94>

Date:      2021-08-10 12:07:45 +0000

    Add demotableone in dev schema.

(END)

snowflake environment:

attached the screenshot in document, please check.

Could you please help me resolving the issue.

Thanks

PS