Keshav helped me construct a clever command to create drop index statements for all commands:
select array_agg("drop index `" || keyspace_id || "`.`" || name || ";") as dropidx from system:indexes;
This works well when going through cbq, but presents an error in the workbench;
[
{
"code": 1065,
"msg": "Unrecognized parameter in request: \") as dropidx from system:indexes) cbq_query_workbench_limit limit 500",
"query_from_user": "select array_agg(\"drop index `\" || keyspace_id || \"`.`\" || name || \";\") as dropidx from system:indexes;",
"query_with_limit": "select cbq_query_workbench_limit.* from (select array_agg(\"drop index `\" || keyspace_id || \"`.`\" || name || \";\") as dropidx from system:indexes) cbq_query_workbench_limit limit 500;"
}
]
When I run the "wrapped" command via cbq I get an error as well.
Major