2026-04-11 10:32:50 - __main__ - INFO - ============================================================
2026-04-11 10:32:50 - __main__ - INFO - ImdbUpdate v2 - Avvio (DuckDB pipeline)
2026-04-11 10:32:50 - __main__ - INFO - ============================================================
2026-04-11 10:32:50 - __main__ - INFO - Base directory: C:\PYTHON\ImdbUpdate
2026-04-11 10:32:50 - __main__ - INFO - Temp directory: C:\PYTHON\ImdbUpdate\Temp
2026-04-11 10:32:50 - __main__ - INFO - Parquet output: C:\PYTHON\ImdbUpdate\parquet\imdb.parquet
2026-04-11 10:32:50 - __main__ - WARNING - Download saltato - uso file esistenti in Temp/
2026-04-11 10:32:50 - __main__ - INFO - ============================================================
2026-04-11 10:32:50 - __main__ - INFO - FASE 3: Transform DuckDB → imdb.parquet
2026-04-11 10:32:50 - __main__ - INFO - ============================================================
2026-04-11 10:32:54 - src.transformer - INFO - Caricamento title_basics: title_basics.txt
2026-04-11 10:32:57 - src.transformer - INFO -   title_basics: 1,264,057 righe (filtrate per titleType)
2026-04-11 10:32:57 - src.transformer - INFO - Caricamento title_akas: title_akas.txt
2026-04-11 10:33:04 - src.transformer - INFO -   title_akas: 5,321,724 righe (solo region=IT)
2026-04-11 10:33:04 - src.transformer - INFO - Caricamento title_ratings: title_ratings.txt
2026-04-11 10:33:05 - src.transformer - INFO -   title_ratings: 1,658,155 righe
2026-04-11 10:33:05 - src.transformer - INFO - Caricamento title_principals: title_principals.txt
2026-04-11 10:33:23 - src.transformer - INFO -   title_principals: 31,768,337 righe (director+actor)
2026-04-11 10:33:23 - src.transformer - INFO - Caricamento name_basics: name_basics.txt
2026-04-11 10:33:29 - src.transformer - INFO -   name_basics: 15,225,343 righe
2026-04-11 10:33:29 - src.transformer - INFO - Caricamento OTT da: I:\SOFTWARE\ProcedureICR\ICRmonitor\MonitorLinker\db_split_OTT.accdb
2026-04-11 10:34:04 - src.transformer - INFO -   OTT caricata: 326,017 righe
2026-04-11 10:34:04 - src.transformer - INFO - Costruzione new_imdb via CTE DuckDB...
2026-04-11 10:34:11 - __main__ - ERROR - Errore fatale: IO Error: Failed to create directory "\\.tmp": Percorso specificato non valido.

Traceback (most recent call last):
  File "C:\PYTHON\ImdbUpdate\main.py", line 255, in main
    if not transform_and_export_parquet(files):
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\PYTHON\ImdbUpdate\main.py", line 86, in transform_and_export_parquet
    row_count = transformer.transform(files)
                ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\PYTHON\ImdbUpdate\src\transformer.py", line 61, in transform
    self._build_new_imdb()
  File "C:\PYTHON\ImdbUpdate\src\transformer.py", line 198, in _build_new_imdb
    self._con.execute(f"""
_duckdb.IOException: IO Error: Failed to create directory "\\.tmp": Percorso specificato non valido.