hi , we are trying to extract information from query executer , we want to know all tables names
Roger Bijos [SLC] [DevOps Advocate] Answered question 26th March 2021
Hi Edgar,
First of all, it will be interesting to know the use case that you would like to achieve by requesting all table names. If possible, please could you elaborate?
In case the DMA is running Cassandra as local database, you could use the following query:
SELECT table_name FROM system_schema.tables WHERE keyspace_name = 'SLDMADB';
In case the DMA is running MySQL as local database, you could use the following query:
SHOW TABLES;
Edgar Roca Posted new comment 22nd March 2021
thanks for the information Miguel , yes we are trying to find out the best way to extract information from our DMA cluster from multiple devices and all of their interfaces , and we noticed that query executer can export this information in csv, we need this to do some statistics required for the organization