def METHOD_NAME(self, connection, table_name, schema):
    query = f"""
        SELECT 
            col."COLUMN_NAME", 
            col."TYPE_NAME",
            col."COMMENT"
        from 
            "COLUMNS_V2" col 
            join "CDS" cds ON col."CD_ID" = cds."CD_ID" 
            join "SDS" sds ON sds."CD_ID" = cds."CD_ID" 
            join "TBLS" tbsl on sds."SD_ID" = tbsl."SD_ID" 
            and tbsl."TBL_NAME" = '{table_name}'
    """
    if schema:
        query += f""" join "DBS" db on tbsl."DB_ID" = db."DB_ID"
        and db."NAME" = '{schema}'"""
    return connection.execute(query).fetchall()