Devin
07/28/2023, 3:08 PMMarvin
07/28/2023, 3:09 PMflow_run_id
column in the artifact
table and the flow_id
column in the flow_run
table. However, the error message suggests that these columns don't have the same data type, which is a requirement for creating a foreign key relationship.
Before you proceed, I would recommend checking the data types of both columns. You can use the following SQL commands:
sql
SELECT data_type
FROM information_schema.columns
WHERE table_name = 'artifact' AND column_name = 'flow_run_id';
SELECT data_type
FROM information_schema.columns
WHERE table_name = 'flow_run' AND column_name = 'flow_id';
If the data types are indeed different, you'll need to alter one or both of the columns to make them the same. If they're the same, then there might be another issue at play.
If you're still stuck after that, I'd suggest posting this issue on the Prefect community forum or opening a GitHub issue. The developers and community members there are usually quite helpful, even if they are human.