Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- (Background on this error at: https://sqlalche.me/e/14/f405)
- [2025-04-06T17:10:40.322+0000] {taskinstance.py:1400} INFO - Marking task as FAILED. dag_id=alt_churn, task_id=create_table, execution_date=20250406T171036, start_date=20250406T171040, end_date=20250406T171040
- [2025-04-06T17:10:40.340+0000] {standard_task_runner.py:104} ERROR - Failed to execute job 53 for task create_table ((psycopg2.errors.DuplicateTable) relation "uq_customer_id" already exists
- [SQL:
- CREATE TABLE alt_users_churn (
- id SERIAL NOT NULL,
- customer_id VARCHAR,
- begin_date TIMESTAMP WITHOUT TIME ZONE,
- end_date TIMESTAMP WITHOUT TIME ZONE,
- type VARCHAR,
- paperless_billing VARCHAR,
- payment_method VARCHAR,
- monthly_charges FLOAT,
- total_charges FLOAT,
- internet_service VARCHAR,
- online_security VARCHAR,
- online_backup VARCHAR,
- device_protection VARCHAR,
- tech_support VARCHAR,
- streaming_tv VARCHAR,
- streaming_movies VARCHAR,
- gender VARCHAR,
- senior_citizen INTEGER,
- partner VARCHAR,
- dependents VARCHAR,
- multiple_lines VARCHAR,
- target INTEGER,
- PRIMARY KEY (id),
- CONSTRAINT uq_customer_id UNIQUE (customer_id)
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement