PS C:\Stellantis\DB2SNOWCOMP> &

C:/Users/2237687/AppData/Local/Programs/Python/Python313/[Link]
c:/Stellantis/DB2SNOWCOMP/DB2SnowComp73_Type_aware_warning_fix.py
Connection type for [Link]: <class '[Link]'>, is_snowflake:
False
DB2 columns found: 74
Connection type for SCM.DLR_SVWGEOI: <class
'[Link]'>, is_snowflake: True
Snowflake query with schema:
SELECT COLUMN_NAME, DATA_TYPE, IS_NULLABLE,
COLUMN_DEFAULT
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ?
ORDER BY ORDINAL_POSITION
with params (SCM, DLR_SVWGEOI)
Snowflake INFORMATION_SCHEMA query failed: not all arguments converted during
string formatting
Trying DESCRIBE TABLE: DESCRIBE TABLE SCM.DLR_SVWGEOI
Snowflake columns found: 75
Column type mapping created for 74 common columns
Using parallel processing for 118,718 rows
DEBUG: DataFrame sizes - DB1: 5000, DB2: 5000
DEBUG: Merge results - Only DB1: 5000, Only DB2: 5000, Both: 0
DEBUG: Processing 5000 rows missing in DB2
Error processing chunk 1:
DEBUG: DataFrame sizes - DB1: 5000, DB2: 5000
DEBUG: Merge results - Only DB1: 1499, Only DB2: 1499, Both: 3501
DEBUG: Processing 1499 rows missing in DB2
DEBUG: Processing 1499 rows missing in DB1
DEBUG: Processing 3501 rows for value differences
Column C_DISTR has too many differences, limiting to first 1000
Column C_DOM has too many differences, limiting to first 1000
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: Could not infer format, so each element will be parsed individually,
falling back to `dateutil`. To ensure parsing is consistent and as-expected, please
specify a format.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: Could not infer format, so each element will be parsed individually,
falling back to `dateutil`. To ensure parsing is consistent and as-expected, please
specify a format.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
Column C_DIST_PARTS has too many differences, limiting to first 1000
Column C_DIST_SERV has too many differences, limiting to first 1000
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: Could not infer format, so each element will be parsed individually,
falling back to `dateutil`. To ensure parsing is consistent and as-expected, please
specify a format.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: Could not infer format, so each element will be parsed individually,
falling back to `dateutil`. To ensure parsing is consistent and as-expected, please
specify a format.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
Column C_FRNCHZ_P has too many differences, limiting to first 1000
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
Column D_FRNCHZ_P_STRT has too many differences, limiting to first 1000
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
Column D_FRNCHZ_P_END has too many differences, limiting to first 1000
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: Could not infer format, so each element will be parsed individually,
falling back to `dateutil`. To ensure parsing is consistent and as-expected, please
specify a format.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: Could not infer format, so each element will be parsed individually,
falling back to `dateutil`. To ensure parsing is consistent and as-expected, please
specify a format.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: Could not infer format, so each element will be parsed individually,
falling back to `dateutil`. To ensure parsing is consistent and as-expected, please
specify a format.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: Could not infer format, so each element will be parsed individually,
falling back to `dateutil`. To ensure parsing is consistent and as-expected, please
specify a format.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: Could not infer format, so each element will be parsed individually,
falling back to `dateutil`. To ensure parsing is consistent and as-expected, please
specify a format.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: Could not infer format, so each element will be parsed individually,
falling back to `dateutil`. To ensure parsing is consistent and as-expected, please
specify a format.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
 dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
Column D_FRNCHZ_E_STRT has too many differences, limiting to first 1000
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
Column D_FRNCHZ_E_END has too many differences, limiting to first 1000
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: Could not infer format, so each element will be parsed individually,
falling back to `dateutil`. To ensure parsing is consistent and as-expected, please
specify a format.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: Could not infer format, so each element will be parsed individually,
falling back to `dateutil`. To ensure parsing is consistent and as-expected, please
specify a format.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: Could not infer format, so each element will be parsed individually,
falling back to `dateutil`. To ensure parsing is consistent and as-expected, please
specify a format.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
 dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: Could not infer format, so each element will be parsed individually,
falling back to `dateutil`. To ensure parsing is consistent and as-expected, please
specify a format.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: Could not infer format, so each element will be parsed individually,
falling back to `dateutil`. To ensure parsing is consistent and as-expected, please
specify a format.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: Could not infer format, so each element will be parsed individually,
falling back to `dateutil`. To ensure parsing is consistent and as-expected, please
specify a format.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: Could not infer format, so each element will be parsed individually,
falling back to `dateutil`. To ensure parsing is consistent and as-expected, please
specify a format.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: Could not infer format, so each element will be parsed individually,
falling back to `dateutil`. To ensure parsing is consistent and as-expected, please
specify a format.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: Could not infer format, so each element will be parsed individually,
falling back to `dateutil`. To ensure parsing is consistent and as-expected, please
specify a format.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: Could not infer format, so each element will be parsed individually,
falling back to `dateutil`. To ensure parsing is consistent and as-expected, please
specify a format.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
Column C_DIST_SBS has too many differences, limiting to first 1000
Column C_DIST_RAM has too many differences, limiting to first 1000
Column C_DIST_TECH_ADVSR has too many differences, limiting to first 1000
DEBUG: Value differences found: 17975
DEBUG: Total mismatches found in this chunk: 20973
Error processing chunk 2:
DEBUG: Processing 5000 rows missing in DB1
DEBUG: DataFrame sizes - DB1: 5000, DB2: 5000
DEBUG: Merge results - Only DB1: 2046, Only DB2: 2046, Both: 2954
DEBUG: Processing 2046 rows missing in DB2
DEBUG: Total mismatches found in this chunk: 10000
Warning: Chunk processing timeout after 300s, returning partial results
DEBUG: Processing 2046 rows missing in DB1
DEBUG: Processing 2954 rows for value differences
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: Could not infer format, so each element will be parsed individually,
falling back to `dateutil`. To ensure parsing is consistent and as-expected, please
specify a format.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: Could not infer format, so each element will be parsed individually,
falling back to `dateutil`. To ensure parsing is consistent and as-expected, please
specify a format.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
Column D_FRNCHZ_P_STRT has too many differences, limiting to first 1000
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
Column D_FRNCHZ_P_END has too many differences, limiting to first 1000
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
 dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
Column D_FRNCHZ_E_STRT has too many differences, limiting to first 1000
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
Column D_FRNCHZ_E_END has too many differences, limiting to first 1000
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3237:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt1 = pd.to_datetime(val1_str, errors='coerce', infer_datetime_format=False)
c:\Stellantis\DB2SNOWCOMP\DB2SnowComp73_Type_aware_warning_fix.py:3238:
UserWarning: The argument 'infer_datetime_format' is deprecated and will be removed
in a future version. A strict version of it is now the default, see
[Link] You can
safely remove this argument.
dt2 = pd.to_datetime(val2_str, errors='coerce', infer_datetime_format=False)
DEBUG: Value differences found: 4373
DEBUG: Total mismatches found in this chunk: 8465
Warning: Chunk processing timeout after 300s, returning partial results
DEBUG: Large dataset comparison completed. Total mismatches: 0
Comparison results stored:
- DB2 columns: 74
- Snowflake columns: 75
- DB2 count: 109675
- Snowflake count: 118718
- Mismatches: 0
DEBUG: No mismatches found - this might be the issue!
DEBUG EXPORT: Total mismatches to process: 0
DEBUG EXPORT: Missing rows: 0, Value mismatches: 0
DEBUG EXPORT: Old-style missing rows converted: 0