Query Interface

'channel' ?: ( + )
'loc' ?: ( + )
'fetch' ?: ( 'tables' | 'latency_sla'+ )
'table' ?: ( + )

chn *: { 
    'locs' : { 
        loc *: { 
            'capture' : 
            'integrate' : 
            'capture_tables' ?: 
            'integrate_tables' ?: 
            'cap_integ_tables' ?: 
            'latency_sla_current' ?: secs
            'tables' ?: { 
                tablename *: { 
                    'schema' ?: 
                    'base_name' ?: 
                    'capture' ?: 
                    'integrate' ?: 
                }
            }
        }
    }
}

'loc' ?: ( + )
'fetch' ?: ( 'tables' | 'latency_sla'+ )
'table' ?: ( + )

loc *: { 
    'capture' : 
    'integrate' : 
    'capture_tables' ?: 
    'integrate_tables' ?: 
    'cap_integ_tables' ?: 
    'latency_sla_current' ?: secs
    'tables' ?: { 
        tablename *: { 
            'schema' ?: 
            'base_name' ?: 
            'capture' ?: 
            'integrate' ?: 
        }
    }
}

'context' ?: ( * )

'schema' ?: 
'schema_type' ?: 'configured' | 'discovered'
'base_name' : 
'capture' : 
'integrate' : 
'key_mode' : 'explicit' | 'implicit' | 'duplicate_rows'
'available_contexts' ?: ( + )
'cols' : (
    { 
        'hvrcolname' : 
        'basecolname' ?: 
        'core' ?: { 
            'sequence' : 
            'key' ?: 
            'distrib_key' ?: 
            'data_type' : 
            'attributes' ?: { 
                'encoding' ?: 
                'nullable' ?: 
                'charlen' ?: 
                'bytelen' ?: 
                'prec' ?: 
                'scale' ?: 
                'timeprec' ?: 
                'dayprec' ?: 
                'yearprec' ?: 
                'bitlen' ?: 
            }
        }
        'with_col_props' ?: { 
            'sequence' : 
            'key' ?: 
            'distrib_key' ?: 
            'data_type' : 
            'attributes' ?: { 
                'encoding' ?: 
                'nullable' ?: 
                'charlen' ?: 
                'bytelen' ?: 
                'prec' ?: 
                'scale' ?: 
                'timeprec' ?: 
                'dayprec' ?: 
                'yearprec' ?: 
                'bitlen' ?: 
            }
            'localize_type_change' : 
            'sql_data_type' ?: 
            'other_props' : { 
                'BaseName' ?: 
                'SoftDelete' ?: 
                'Extra' ?: 
                'CaptureExpression' ?: 
                'IntegrateExpression' ?: 
                'TimeKey' ?: 
                'CaptureFromRowId' ?: 
                'DistributionKey' ?: 
                'SurrogateKey' ?: 
            }
        }
    }*
)

'table' ?: ( + )

table *: { 
    'schema_bases' ?: (
        { 
            'schema' ?: 
            'schema_type' ?: 'configured' | 'discovered'
            'base_name' : 
            'cap_locs' ?: ( * )
            'integ_locs' ?: ( * )
        }*
    )
    'packed_inside' ?: 
}

'hub_state' : 
'freeze_time' ?: 
'log_hvr_err_tstamp' ?: 
'log_hvr_schederr_tstamp' ?: 
'jobs_over_latency_sla' : ( jobname* )
'license' : 'NONE'
          | 'VALID'
          | 'EXPIRED'
          | 'HOST_MISMATCH'
          | 'EXCEEDED'
          | 'INVALID'
'licensing_expiry_warning' ?: 
'licensing_upload_error' ?: 
'licensing_acquire_error' ?: 
'perl_needed' ?: