Pipeline ETL umbrella absorbiendo cochid-economia. Datasets reales: ele7, ene.
Fuente original
https://www.ine.gob.cl7 archivos · 201.1MB total · click en una fila para ver metadata completa.
| Archivo | Tipo | Año | Tamaño | Fuente | Descargar |
|---|---|---|---|---|---|
| ene-2023-son.csv | CSV | — | 32.6MB | INE_Chile ↗ | ↓ descargar |
| ene-2023-mjj.csv | CSV | — | 32.4MB | INE_Chile ↗ | ↓ descargar |
| ene-2023-efm.csv | CSV | — | 30.4MB | INE_Chile ↗ | ↓ descargar |
| ene-2024-son.csv | CSV | — | 29.0MB | INE_Chile ↗ | ↓ descargar |
| ene-2024-mjj.csv | CSV | — | 33.9MB | INE_Chile ↗ | ↓ descargar |
| ene-2024-efm.csv | CSV | — | 32.5MB | INE_Chile ↗ | ↓ descargar |
| ele7-full.csv | CSV | — | 10.2MB | INE_Chile ↗ | ↓ descargar |
| Estado | Filas in/out | Duración | Inicio | Error |
|---|---|---|---|---|
| pass | 594.558 / 594.570 | 4.2m | 06-05-2026, 4:11:48 p. m. | — |
| pass | 297.465 / 297.473 | 2.2m | 06-05-2026, 4:09:25 p. m. | — |
| pass | 297.465 / 297.473 | 2.2m | 06-05-2026, 4:05:22 p. m. | — |
| failed | 0 / 0 | — | 06-05-2026, 4:04:47 p. m. | DBAPIError: (sqlalchemy.dialects.postgresql.asyncpg.Error) <class 'asyncpg.exceptions.DataError'>: invalid input for query argument $2: '8c4df1ce-77f5-4079-9fb0-ded6dac7884a' ('str' object cannot be interpreted as an integer) [SQL: INSERT INTO meta.raw_file_runs (file_id, run_id, relation) VALUES ($1, $2, $3) ON CONFLICT DO NOTHING] [parameters: (2654, '8c4df1ce-77f5-4079-9fb0-ded6dac7884a', 'input')] (Background on this error at: https://sqlalche.me/e/20/dbapi) |
| failed | 0 / 0 | — | 06-05-2026, 4:04:12 p. m. | IntegrityError: (sqlalchemy.dialects.postgresql.asyncpg.IntegrityError) <class 'asyncpg.exceptions.ForeignKeyViolationError'>: insert or update on table "raw_files" violates foreign key constraint "raw_files_dataset_id_fkey" DETAIL: Key (dataset_id)=(economia) is not present in table "datasets". [SQL: INSERT INTO meta.raw_files (dataset_id, sha256, filename, content_type, size_bytes, source_url, source_org, storage_path, http_headers, extraction_meta, valid_from, valid_until, license, notes) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, CAST($9 AS jsonb), CAST($10 AS jsonb), $11, $12, $13, $14) ON CONFLICT (dataset_id, sha256) DO UPDATE SET storage_path = EXCLUDED.storage_path, extraction_meta = EXCLUDED.extraction_meta, http_headers = COALESCE(EXCLUDED.http_headers, meta.raw_files.http_headers) RETURNING file_id] [parameters: ('economia', 'd8ef4d3b4dd9165dc2a7fc7b7637a720e155a7076033a978628f7e2cc2c904f9', 'ele7-full.csv', 'text/csv', 10708022, 'https://www.ine.gob.cl/estadisticas/economia/economia-encuestas-estructurales-empresariales/encuesta-longitudinal-de-empresas', 'INE_Chile', 'data/raw/economia_full/ele7-full.csv', '{}', '{"dataset": "ele7", "format": "csv_latin1_semicolon", "snapshot_id": "economia_1778097852"}', None, None, 'Datos abiertos INE (asumido)', 'ELE-7 microdata snapshot 2020-2022')] (Background on this error at: https://sqlalche.me/e/20/gkpj) |
Cadencia inferida desde la cadencia real de las filas (ventanas de 12 períodos). Útil para detectar shifts no documentados.