Venkatesh Sarangan

86 papers A* 2A 5B 10C 4Misc 5Journal 21Unranked 38
YearRankTypeTitle / Venue / Authors
2025 J jnl
IEEE Control. Syst. Lett.
Nilanjan Roy Chowdhury, Venkatesh Sarangan
2025 J jnl
Eur. J. Control
Nilanjan Roy Chowdhury, Anuj Kumar Rao, Yogesh Bichpuriya, Venkatesh Sarangan, Shreevardhan A. Soman
2024 conf
BuildSys
Anshu Kumar, Prasant Misra, Vishnu P. Menon, Yogesh Bichpuriya, Venkatesh Sarangan
2023 conf
e-Energy
Vishnu P. Menon, Yogesh Bichpuriya, Venkatesh Sarangan, Narayanan Rajagopal
2023 conf
ISGT EUROPE
Smita Lokhande, Yogesh Bichpuriya, Venkatesh Sarangan, Narayanan Rajagopal
2022 J jnl
IEEE Intell. Transp. Syst. Mag.
Ajay Narayanan, Aakash Krishna, Prasant Misra, Arunchandar Vasan, Venkatesh Sarangan
2022 conf
e-Energy
Smita Lokhande, Venkatesh Sarangan, Vishnu P. Menon, Ashutosh Prajapati, Yogesh Bichpuriya, Narayanan Rajagopal, Nidhisha Mahilong
2022 conf
ISGT Asia
Nidhisha Mahilong, Venkatesh Sarangan, Yogesh Bichpuriya, Ashutosh Prajapati, Narayanan Rajagopal
2021 conf
ISGT-Europe
Yogesh Bichpuriya, Neha Nandagaoli, Nidhisha Mahilong, Venkatesh Sarangan, Narayanan Rajagopal
2021 conf
ISGT-Europe
Vishnu P. Menon, Yogesh Bichpuriya, Smita Lokhande, Venkatesh Sarangan
2021 J jnl
ACM Trans. Cyber Phys. Syst.
Srinarayana Nagarathinam, Arunchandar Vasan, Venkatesh Sarangan, Rajesh Jayaprakash, Anand Sivasubramaniam
2020 conf
BuildSys
Bala Suraj Pedasingu, Easwar Subramanian, Yogesh Bichpuriya, Venkatesh Sarangan, Nidhisha Mahilong
2020 conf
BuildSys
Yogesh Bichpuriya, Nidhisha Mahilong, Neha Nandagaoli, Venkatesh Sarangan, Narayanan Rajagopal
2020 conf
e-Energy
Aakash Krishna, Ajay Narayanan, Sunil Krishnakumar, Prasant Misra, Arunchandar Vasan, Venkatesh Sarangan, Anand Sivasubramaniam
2019 conf
BuildSys
Srinarayana Nagarathinam, Harihara Subrahmaniam Muralidharan, Arunchandar Vasan, Venkatesh Sarangan, Sermisha Narayana, Anand Sivasubramaniam
2019 Misc conf
COMSNETS
Kundan Kandhway, Depak Sudarsanam, Arunchandar Vasan, Venkatesh Sarangan
2019 conf
e-Energy
Easwar Subramanian, Yogesh Bichpuriya, Avinash Achar, Sanjay P. Bhat, Abhay Pratap Singh, Venkatesh Sarangan, Akshaya Natarajan
2019 conf
ISGT
Venkata Ramakrishna Padullaparthi, Venkatesh Sarangan, Anand Sivasubramaniam
2018 conf
BuildSys
Srinarayana Nagarathinam, Arunchandar Vasan, Venkatesh Sarangan, Rajesh Jayaprakash, Anand Sivasubramaniam
2018 A* conf
AAAI
Avinash Achar, Venkatesh Sarangan, Rohith Regikumar, Anand Sivasubramaniam
2017 A* conf
AAAI
Gollakota Kaushik, Abinaya Manimaran, Arunchandar Vasan, Venkatesh Sarangan, Anand Sivasubramaniam
2017 conf
BuildSys
Kundan Kandhway, Arunchandar Vasan, Srinarayana Nagarathinam, Venkatesh Sarangan, Anand Sivasubramaniam
2017 J jnl
CoRR
Avinash Achar, Venkatesh Sarangan, Rohith Regikumar, Anand Sivasubramaniam
2017 conf
e-Energy
Arvind Ramanujam, Pandeeswari Sankaranarayanan, Arun Vasan, Rajesh Jayaprakash, Venkatesh Sarangan, Anand Sivasubramaniam
2016 conf
e-Energy (Posters)
Leena Markose, Venkatesh Sarangan, Arunchandar Vasan, Ramasubramanian Suriyanarayanan, Anand Sivasubramaniam
2016 J jnl
Ad Hoc Networks
Chandrika J. Satyavolu, Sridhar Radhakrishnan, Venkatesh Sarangan, Thomas L. Landers, Mahendran Veeramani
2015 conf
e-Energy
Shravan Srinivasan, Arunchandar Vasan, Venkatesh Sarangan, Anand Sivasubramaniam
2015 conf
BuildSys
Srinarayana Nagarathinam, Arunchandar Vasan, Venkata Ramakrishna P., Shiva R. Iyer, Venkatesh Sarangan, Anand Sivasubramaniam
2015 conf
EUMAS/AT
Rahul Agrawal, Anirban Chakraborti, Karamjit Singh, Gautam Shroff, Venkatesh Sarangan
2015 conf
e-Energy
Srinarayana Nagarathinam, Shiva R. Iyer, Arunchandar Vasan, Venkata Ramakrishna P., Venkatesh Sarangan, Anand Sivasubramaniam
2014 conf
IEEE ANTS
Mahendran Veeramani, Chandrika J. Satyavolu, Sridhar Radhakrishnan, Venkatesh Sarangan
2014 conf
e-Energy
Maathangi Sankar, Venkata Ramakrishna P., Shiva R. Iyer, Venkatesh Sarangan, Arunchandar Vasan, Anand Sivasubramaniam
2014 J jnl
CoRR
Nipun Batra, Amarjeet Singh, Pushpendra Singh, Haimonti Dutta, Venkatesh Sarangan, Mani B. Srivastava
2014 conf
VTC Fall
Jayashree Badarinath, Sridhar Radhakrishnan, Venkatesh Sarangan, Mahendran Veeramani
2014 J jnl
IEEE Trans. Emerg. Top. Comput.
Iyswarya Narayanan, Arunchandar Vasan, Venkatesh Sarangan, Jamsheeda Kadengal, Anand Sivasubramaniam
2014 conf
IPSN
Iyswarya Narayanan, Arunchandar Vasan, Venkatesh Sarangan, Anand Sivasubramaniam
2014 conf
e-Energy
Sagar Kurandwad, Chandrasekar Subramanian, Venkata Ramakrishna P., Arunchandar Vasan, Venkatesh Sarangan, Vijaysekhar Chellaboina, Anand Sivasubramaniam
2013 conf
IEEE ANTS
Chandrika J. Satyavolu, Sridhar Radhakrishnan, Venkatesh Sarangan, Thomas L. Landers
2013 conf
BuildSys@SenSys
Jamsheeda Kadengal, Sivabalan Thirunavukkarasu, Arunchandar Vasan, Venkatesh Sarangan, Anand Sivasubramaniam
2013 conf
BuildSys@SenSys
Shiva R. Iyer, Venkatesh Sarangan, Arunchandar Vasan, Anand Sivasubramaniam
2012 J jnl
Sensors
Akkarapol Sangasoongsong, Jakkrit Kunthong, Venkatesh Sarangan, Xinwei Cai, Satish T. S. Bukkapatnam
2012 conf
ICC
Tao Zheng, Sridhar Radhakrishnan, Venkatesh Sarangan
2012 conf
IGCC
Iyswarya Narayanan, Venkatesh Sarangan, Arunchandar Vasan, Aravind Srinivasan, Anand Sivasubramaniam, B. S. Murt, Shankar Narasimhan
2012 Misc conf
ICNC
Chandrika J. Satyavolu, Sridhar Radhakrishnan, Venkatesh Sarangan, Thomas L. Landers
2012 Misc conf
COMSNETS
Iyswarya Narayanan, Venkatesh Sarangan, Arunchandar Vasan, Aravind Srinivasan, Anand Sivasubramaniam
2011 J jnl
Computer
Geetha Thiagarajan, Venkatesh Sarangan, Ramasubramanian Suriyanarayanan, Pragathichitra Sethuraman, Anand Sivasubramaniam, Avinash Yegyanarayanan
2011 J jnl
IEEE Trans. Parallel Distributed Syst.
Sridhar Radhakrishnan, Shankar M. Banik, Venkatesh Sarangan, Chandra N. Sekharan
2011 A conf
MSWiM
Tao Zheng, Sridhar Radhakrishnan, Venkatesh Sarangan
2010 conf
CrownCom
Jongwon Shim, Qi Cheng, Venkatesh Sarangan
2010 J jnl
Int. J. Ad Hoc Ubiquitous Comput.
Pavan K. Pothuri, Divya L. Ranganathan, Venkatesh Sarangan, Sridhar Radhakrishnan
2010 B conf
GLOBECOM
Aravind M. Canthadai, Sridhar Radhakrishnan, Venkatesh Sarangan
2010 B conf
LCN
Sejin Choi, Venkatesh Sarangan, Johnson P. Thomas, Sridhar Radhakrishnan
2009 conf
CCNC
Aravind B. Mohanoor, Sridhar Radhakrishnan, Venkatesh Sarangan
2009 B conf
SECON
Venkatesh Sarangan, Jakkrit Kunthong, Xinwei Cai, Satish T. S. Bukkapatnam, Ranga Komanduri, John L. Volakis
2009 J jnl
IEEE Trans. Mob. Comput.
Aravindhan Venkateswaran, Venkatesh Sarangan, Thomas F. La Porta, Raj Acharya
2009 C conf
BROADNETS
Tao Zheng, Sridhar Radhakrishnan, Venkatesh Sarangan
2009 J jnl
Ad Hoc Networks
Aravind B. Mohanoor, Sridhar Radhakrishnan, Venkatesh Sarangan
2009 conf
CASE
Satish T. S. Bukkapatnam, Srinivas Mukkamala, Jakkrit Kunthong, Venkatesh Sarangan, Ranga Komanduri
2008 J jnl
Comput. Networks
Venkatesh Sarangan, Malla Reddy Devarapalli, Sridhar Radhakrishnan
2008 C conf
AICCSA
Shariful Hasan Shaikot, Venkatesh Sarangan
2008 J jnl
IEEE Trans. Parallel Distributed Syst.
Shankar M. Banik, Sridhar Radhakrishnan, Venkatesh Sarangan, Chandra N. Sekharan
2008 B conf
MASS
Aravind B. Mohanoor, Sridhar Radhakrishnan, Venkatesh Sarangan
2008 B conf
LCN
Sejin Choi, Venkatesh Sarangan, Steve Trost
2008 ch.
Encyclopedia of Wireless and Mobile Communications
Raj Acharya, Sridhar Radhakrishnan, Venkatesh Sarangan, Aravindhan Venkateswaran
2008 A conf
GECCO
Sanjoy Das, Praveen Koduru, Xinye Cai, Stephen M. Welch, Venkatesh Sarangan
2007 A conf
MSWiM
Aravindhan Venkateswaran, Venkatesh Sarangan, Thomas F. La Porta, Raj Acharya
2007 C conf
QSHINE
Malla Reddy Devarapalli, Venkatesh Sarangan, Sridhar Radhakrishnan
2007 C conf
BROADNETS
Aravind B. Mohanoor, Sridhar Radhakrishnan, Venkatesh Sarangan
2006 J jnl
IEEE Trans. Multim.
Venkatesh Sarangan, Donna Ghosh, Raj Acharya
2006 J jnl
IEEE Commun. Mag.
Venkatesh Sarangan, Jyh-Cheng Chen
2006 J jnl
Comput. Commun.
Jyh-Cheng Chen, Venkatesh Sarangan, Anthony J. McAuley, Shinichi Baba, Yoshihiro Ohba, Zong-Hua Liu
2006 conf
ICDCS Workshops
Eashwar R. Chittimalla, Aravindhan Venkateswaran, Venkatesh Sarangan, Raj Acharya
2006 B conf
WCNC
Sudheer K. Chimbli, Johnson P. Thomas, Venkatesh Sarangan, Ruiyi Zhang
2005 conf
PE-WASUN
Aravindhan Venkateswaran, Venkatesh Sarangan, Natarajan Gautam, Raj Acharya
2005 A conf
IPDPS
Tao Zheng, Sridhar Radhakrishnan, Venkatesh Sarangan
2005 J jnl
IEEE Commun. Lett.
Venkatesh Sarangan, Donna Ghosh, Natarajan Gautam, Raj Acharya
2004 B conf
GLOBECOM
Venkatesh Sarangan, Donna Ghosh, Raj Acharya
2004 Misc conf
PDPTA
H. K. Dai, A. Raju, Venkatesh Sarangan
2002 conf
ICC
Jyh-Cheng Chen, Anthony J. McAuley, Venkatesh Sarangan, Shinichi Baba, Yoshihiro Ohba
2002 B conf
GLOBECOM
Venkatesh Sarangan, Donna Ghosh, Raj Acharya
2001 B conf
GLOBECOM
Venkatesh Sarangan, Raj Acharya
2001 J jnl
IEEE Trans. Multim.
Donna Ghosh, Venkatesh Sarangan, Raj Acharya
2001 conf
ICON
Venkatesh Sarangan, Raj Acharya
2000 A conf
IEEE International Conference on Multimedia and Expo (III)
Venkatesh Sarangan, Donna Ghosh, Raj Acharya
2000 B conf
GLOBECOM
Venkatesh Sarangan, Donna Ghosh, Raj Acharya
2000 Misc conf
HiPC
Donna Ghosh, Venkatesh Sarangan, Raj Acharya
redb/extractors/capa.py
← Index redb/extractors/capa.py python
from dataclasses import asdict
import inspect
import json
import subprocess
import magic
from magika import Magika
from typing import Any, Dict, List, Tuple
from datetime import datetime, timezone

from redb.extractors.enum import Tag
from redb.models.dataclasses import CAPA
from redb.extractors.extractor import Extractor
from dotenv import load_dotenv
import os

load_dotenv(override=True)

class CAPAExtractor(Extractor):

    def __init__(
        self,
        filepath,
        log,
        exporters=None,
        index_prefix=None,
        elastic_index=None,
        known_benign=False,
        known_malicious=False,
    ):
        super().__init__(
            filepath, 
            log, 
            exporters,
            index_prefix, 
            elastic_index, 
            known_benign, 
            known_malicious
        )
        self.capa = None
        self.elastic_index = self.index_prefix + "-capa"

    def _replace_empty_keys(self, dictionary, replacement="default_empty_key"):
        """
        Replace empty keys in a dictionary with a specified replacement.

        Args:
        dictionary (dict): The input dictionary
        replacement (str): The replacement for empty keys (default: 'empty_key')

        Returns:
        dict: A new dictionary with empty keys replaced
        """
        # tmp_dict = {}
        # for k, v in dictionary.items():
        #     if k == '':
        #         tmp_dict[replacement] = dictionary[k]
        #     else:
        #         tmp_dict[k] = dictionary[k]
        # return tmp_dict
        return {(replacement if k == "" else k): v for k, v in dictionary.items()}

    def _extract_capa(self):
        self.log.debug(inspect.currentframe().f_code.co_name)
        TIMEOUT = int(os.getenv("CAPA_TIMEOUT")) # 5 minutes in seconds
        capa_command = [os.getenv("CAPA_PATH"), "-j", self.filepath] # COMMENT FOR TESTING ON MAC

        import signal

        # try:
        #     result = subprocess.run(
        #         capa_command, capture_output=True, text=True, check=True, timeout=TIMEOUT
        #     )
        # except subprocess.TimeoutExpired:
        #     self.log.error(f"The capa command timed out after {TIMEOUT} seconds")
        #     return {}
        # except subprocess.CalledProcessError as e:
        #     self.log.error(f"Error running capa: {e}")
        #     return {}

        # try:
        #     capa_output = json.loads(result.stdout)
        # except json.JSONDecodeError as e:
        #     self.log.error("Error parsing capa output: {e}")
        #     return {}

        # Create a process group for easier termination of all child processes
        try:
            # Start the process in a new process group
            process = subprocess.Popen(
                capa_command,
                stdout=subprocess.PIPE,
                stderr=subprocess.PIPE,
                text=True,
                preexec_fn=os.setsid  # Use os.setsid() to create a new process group
            )
            
            # Implement timeout handling manually
            try:
                stdout, stderr = process.communicate(timeout=TIMEOUT)
                # Process completed within timeout
                if process.returncode != 0:
                    self.log.error(f"Error running capa, return code: {process.returncode}, stderr: {stderr}")
                    return {}
            except subprocess.TimeoutExpired:
                # Kill the entire process group on timeout
                self.log.warning(f"The capa command timed out after {TIMEOUT} seconds, terminating process group")
                
                try:
                    # Send SIGTERM to the entire process group
                    os.killpg(process.pid, signal.SIGTERM)
                    
                    # Give it a moment to terminate gracefully
                    try:
                        process.wait(timeout=3)
                    except subprocess.TimeoutExpired:
                        # If it's still running after 3 seconds, send SIGKILL
                        self.log.warning("Process didn't terminate with SIGTERM, sending SIGKILL")
                        os.killpg(process.pid, signal.SIGKILL)
                        
                    process.wait()  # Make sure process resources are fully cleaned up
                except (ProcessLookupError, OSError) as e:
                    self.log.warning(f"Error while killing process: {e}")
                    
                return {}
                
            try:
                capa_output = json.loads(stdout)
            except json.JSONDecodeError as e:
                self.log.error(f"Error parsing capa output: {e}")
                return {}

            capa_dump = {}  # dictionalry of capabilities
            capabilities = set()  # list of capabilities
            namespaces = set()  # list of namespaces
            attack_dump = {}  # dictionary of tuples [tactic](technique, technique_id)
            tactics = set()  # list of tactics
            techniques = set()  # list of techniques
            techniques_id = set()  # list of techniques_id
            mbc_dump = {}  # dictionary of tuples [objective](behavior, behavior_id)
            mbc_objectives = set()  # list of objectives
            mbc_behaviors = set()  # list of behaviors
            mbc_behaviors_id = set()  # list of behaviors_id

            if isinstance(capa_output, dict) and "rules" in capa_output:
                rules = capa_output["rules"]
                if isinstance(rules, dict):
                    for rule_name, rule_data in rules.items():
                        if isinstance(rule_data, dict) and "meta" in rule_data:
                            meta = rule_data["meta"]
                            if isinstance(meta, dict):
                                # Process capabilities
                                namespace = meta.get("namespace", "").lower()
                                # if namespace != 'lib':
                                if namespace not in capa_dump:
                                    capa_dump[namespace] = []
                                    namespaces.add(namespace)
                                capa_dump[namespace].append(rule_name)
                                capabilities.add(rule_name)

                                # Process ATTACK information
                                if "attack" in meta:
                                    for attack_entry in meta["attack"]:
                                        tactic = attack_entry.get("tactic", "")
                                        technique = attack_entry.get("technique", "")
                                        id = attack_entry.get("id", "")
                                        if tactic and technique:
                                            if tactic in attack_dump:
                                                attack_dump[tactic].append((technique, id))
                                            else:
                                                attack_dump[tactic] = [(technique, id)]
                                            tactics.add(tactic)
                                            techniques.add(technique)
                                            techniques_id.add(id)

                                # Process MBC information
                                if "mbc" in meta:
                                    for mbc_entry in meta["mbc"]:
                                        objective = mbc_entry.get("objective", "")
                                        behavior = mbc_entry.get("behavior", "")
                                        id = mbc_entry.get("id", "")
                                        if objective and behavior:
                                            if objective in mbc_dump:
                                                mbc_dump[objective].append((behavior, id))
                                            else:
                                                mbc_dump[objective] = [(behavior, id)]
                                            mbc_objectives.add(objective)
                                            mbc_behaviors.add(behavior)
                                            mbc_behaviors_id.add(id)

            # return {
            #     'capabilities_all': json.dumps(capabilities_all, indent=2),
            #     'capabilities': list(capabilities),
            #     'namespaces': list(namespaces),
            #     'attack': json.dumps(attack, indent=2),
            #     'tactics': list(tactics),
            #     'techniques': list(techniques),
            #     'techniques_id': list(techniques_id),
            #     'mbc': json.dumps(mbc, indent=2),
            #     'mbc_objectives': list(mbc_objectives),
            #     'mbc_behaviors': list(mbc_behaviors),
            #     'mbc_behaviors_id': list(mbc_behaviors_id)
            # }

            capa_dump = self._replace_empty_keys(capa_dump)
            attack_dump = self._replace_empty_keys(attack_dump)
            mbc_dump = self._replace_empty_keys(mbc_dump)
            self.capa = CAPA(
                json.dumps(capa_dump, indent=2),
                list(capabilities),
                list(namespaces),
                json.dumps(attack_dump, indent=2),
                list(tactics),
                list(techniques),
                list(techniques_id),
                json.dumps(mbc_dump, indent=2),
                list(mbc_objectives),
                list(mbc_behaviors),
                list(mbc_behaviors_id),
            )
            self.log.debug(f"CAPA dump: {self.capa})")
            
        except Exception as e:
            self.log.error(f"Unexpected error in CAPA extraction: {str(e)}")
            # Try to clean up any process if possible
            if 'process' in locals() and process.poll() is None:
                try:
                    os.killpg(process.pid, signal.SIGKILL)
                    process.wait()
                except:
                    pass
            return {}

    def prepare_export_data(self, exporter_type: str) -> Any:
        if exporter_type == "ElasticsearchExporter":
            return self.capa
        elif exporter_type == "ClickHouseExporter":
            current_time = datetime.now(timezone.utc)
            
            # Prepare data for multiple tables
            tables_data = {
                'multi_table': True,  # Flag for multi-table export
                
                # Raw data table
                'raw': {
                    'table': 'redb_capa',
                    'data': [[
                        self.sha256,
                        self.md5,
                        self.sha1,
                        current_time,
                        self.capa.capa_dump,  # capa_dump
                        self.capa.attack_dump,            # attack_dump
                        self.capa.mbc_dump                # mbc_dump
                    ]],
                    'column_names': [
                        'sha256', 'md5', 'sha1', 'analysis_date',
                        'capa_dump', 'attack_dump', 'mbc_dump'
                    ],
                    'column_type_names': [
                        'FixedString(64)', 'FixedString(32)', 'FixedString(40)',
                        'DateTime64(3, \'UTC\')',
                        'JSON', 'JSON', 'JSON'
                    ]
                },
                
                # Capabilities table
                'capabilities': {
                    'table': 'redb_capa_capabilities',
                    'data': [
                        [self.sha256, self.md5, self.sha1, current_time, namespace, capability]
                        for namespace, capabilities in json.loads(self.capa.capa_dump).items()
                        for capability in capabilities
                    ],
                    'column_names': [
                        'sha256', 'md5', 'sha1', 'analysis_date',
                        'namespace', 'capability'
                    ],
                    'column_type_names': [
                        'FixedString(64)', 'FixedString(32)', 'FixedString(40)',
                        'DateTime64(3, \'UTC\')',
                        'LowCardinality(String)', 'LowCardinality(String)'
                    ]
                },
                
                # MITRE ATT&CK table
                'attack': {
                    'table': 'redb_capa_attack',
                    'data': [
                        [self.sha256, self.md5, self.sha1, current_time, 
                         tactic, technique[0], technique[1]]  # technique[0] is the name, technique[1] is the ID
                        for tactic, techniques in json.loads(self.capa.attack_dump).items()
                        for technique in techniques
                    ],
                    'column_names': [
                        'sha256', 'md5', 'sha1', 'analysis_date',
                        'tactic', 'technique', 'technique_id'
                    ],
                    'column_type_names': [
                        'FixedString(64)', 'FixedString(32)', 'FixedString(40)',
                        'DateTime64(3, \'UTC\')',
                        'LowCardinality(String)', 'LowCardinality(String)', 
                        'LowCardinality(String)'
                    ]
                },
                
                # MBC table
                'mbc': {
                    'table': 'redb_capa_mbc',
                    'data': [
                        [self.sha256, self.md5, self.sha1, current_time,
                         objective, behavior[0], behavior[1]]  # behavior[0] is the name, behavior[1] is the ID
                        for objective, behaviors in json.loads(self.capa.mbc_dump).items()
                        for behavior in behaviors
                    ],
                    'column_names': [
                        'sha256', 'md5', 'sha1', 'analysis_date',
                        'objective', 'behavior', 'behavior_id'
                    ],
                    'column_type_names': [
                        'FixedString(64)', 'FixedString(32)', 'FixedString(40)',
                        'DateTime64(3, \'UTC\')',
                        'LowCardinality(String)', 'LowCardinality(String)',
                        'LowCardinality(String)'
                    ]
                }
            }
            
            return tables_data

    def get_clickhouse_table(self) -> str:
        return "redb_capa"  # Return the main table name

    def extract(self):
        self.log.debug(inspect.currentframe().f_code.co_name)
        try:
            self._extract_capa()
            return self.capa  # Return the extracted data instead of exporting directly
        except Exception as e:
            self.log.error(f"Error extracting CAPA: {e}")
            return None

    def tag(self):
        return Tag.CAPA.value