# queries

keyname: get_data_columns
valuename:
  select column_name from information_schema.columns where table_schema = 'r_impacted_tables.SCHEM' AND table_name = 'r_impacted_tables.TBL' and column_name not in (exclude_list);


keyname: get_all_columns
valuename:
  select column_name from information_schema.columns where table_schema = 'r_impacted_tables.SCHEM' AND table_name = 'r_impacted_tables.TBL';


keyname: get_data
valuename:
  SELECT v_column_list FROM sfenv.r_impacted_tables.SCHEM.r_impacted_tables.TBL WHERE ODS_EFF_ROW_DT = 'startdate';


keyname: get_daterange
valuename:
  SELECT v_column_list FROM sfenv.r_impacted_tables.SCHEM.r_impacted_tables.TBL WHERE ODS_EFF_ROW_DT >= 'startdate' AND ODS_EFF_ROW_DT <= 'enddate';


keyname: minus_query
valuename:
  SELECT v_column_list FROM fromsfenv.r_impacted_tables.SCHEM.r_impacted_tables.TBL EXCEPT SELECT v_column_list FROM tosfenv.r_impacted_tables.SCHEM.r_impacted_tables.TBL;


keyname: local_minus_query
valuename:
  SELECT v_column_list FROM fromsfenv.r_impacted_tables.SCHEM.r_impacted_tables.TBL MINUS SELECT v_column_list FROM tosfenv.r_impacted_tables.SCHEM.r_impacted_tables.TBL;


keyname: populate_recoverytable
valuename:
  SELECT v_column_list FROM fromsfenv.r_impacted_tables.SCHEM.r_impacted_tables.TBL A, minustable B WHERE columnlist;


# settings

keyname: full_qlik_columns
valuename:
  HEADER_CHANGE_SEQ,HEADER_CHANGE_OPER,HEADER_CHANGE_MASK,HEADER_STREAM_POSITION,HEADER_OPERATION,HEADER_TRANSACTION_ID,HEADER_TIMESTAMP


keyname: qlik_columns
valuename:
  HEADER_CHANGE_SEQ,HEADER_CHANGE_OPER,HEADER_STREAM_POSITION,HEADER_OPERATION,HEADER_TRANSACTION_ID,HEADER_TIMESTAMP


keyname: gg_columns
valuename:
  GG_PRC_OWNER, GG_SRC_SERVER, GG_CSN, GG_RSN, GG_REPLICAT, GG_EXTRACT, GG_XID, GG_CORRELATION_ID, GG_USER_ID, GG_FILESEQNO, GG_FILERBA


keyname: mssql_gg_columns
valuename:
  ODS_CDC_TRANS_TYPE,ODS_EFF_ROW_DTM,ODS_CREATE_ROW_DTM,ODS_CREATE_ROW_DT,ODS_ROW_PROCESS_DTM,ODS_EFF_ROW_DT,GG_XID,GG_CORRELATION_ID,GG_USER_ID,GG_FILESEQNO,GG_FILERBA,ODS_EXP_ROW_DTM,ODS_SID,ODS_AUDIT_ID,ODS_EXP_ROW_DT


