CODEWITHSUNDEEP
azure-data-explorerkql
Dhiraj
Dhiraj

Reputation: 3696

How to drop an external table in Kusto ONLY IF IT EXISTS

How to drop an external table without know if it exists or not? Basically we have optional ifexists clause for a normal table but not for an external table. Is there any workaround?

Upvotes: 1

Views: 1152

Answers (2)

Varun
Varun

Reputation: 496

Here is a link to Microsoft doc - External table general control commands

.drop external table tableName

Here is an extract from microsoft doc

Upvotes: 1

Yoni L.
Yoni L.

Reputation: 25995

i'd recommend voting for missing features/functionality you'd like to see implemented at the service's User Voice forum (https://aka.ms/adx.uservoice).

a 'workaround' for the time being is performing the operation in two steps - run a .show command to see if the external table exists, and if it does - run a .drop command

(update: you can expect the ifexists option to become available within the next 2 weeks)

Upvotes: 2

Related Questions