def del_duplicados(**kwargs):
try:
query = 'EXEC [dbo].[Remover_Duplicados] @NOMBRE_TABLA = "Unificado"'
odbc_hook = OdbcHook(odbc_conn_id='con_ej_pi_mssql',
database='Testing_ETL',
driver='{ODBC Driver 17 for SQL Server}')
odbc_hook.run(query)
except Exception as e:
logging.error(f'Ejercucion de Query: {query} - {e}')
def load_to_db(query, i):
try:
odbc_hook = OdbcHook(odbc_conn_id='con_ej_pi_mssql',
database='Testing_ETL',
driver='{ODBC Driver 17 for SQL Server}')
odbc_hook.run(query)
return i + 1
except Exception as e:
logging.error(f'Ejercucion de Query: {query} - {e}')
return i