Back
Getting issue while migrating from supabase to appwrite
TypeScript
{
"$id": "67c6XXXXXXXXXXXXXXX",
"$createdAt": "2025-03-04T00:09:07.676+00:00",
"$updatedAt": "2025-03-04T00:09:17.931+00:00",
"status": "failed",
"stage": "finished",
"source": "Supabase",
"destination": "Appwrite",
"resources": [
"user",
"database",
"collection",
"attribute",
"index",
"document",
"bucket",
"file"
],
"statusCounters": {
"user": {
"pending": 0,
"success": 0,
"error": 0,
"skip": 4,
"processing": 0,
"warning": 0
},
"database": {
"pending": 0,
"success": 1,
"error": 0,
"skip": 0,
"processing": 0,
"warning": 0
},
"collection": {
"pending": 0,
"success": 1,
"error": 0,
"skip": 0,
"processing": 0,
"warning": 0
},
"attribute": {
"pending": 0,
"success": 4,
"error": 0,
"skip": 0,
"processing": 0,
"warning": 0
},
"index": {
"pending": 0,
"success": 1,
"error": 0,
"skip": 0,
"processing": 0,
"warning": 0
},
"document": {
"pending": 1,
"success": 0,
"error": 0,
"skip": 0,
"processing": 0,
"warning": 0
},
"bucket": {
"pending": 0,
"success": 2,
"error": 0,
"skip": 0,
"processing": 0,
"warning": 0
},
"file": {
"pending": 1,
"success": 0,
"error": 0,
"skip": 0,
"processing": 0,
"warning": 0
}
},
"resourceData": [],
"errors": [
"Error occurred while fetching 'bucket:' from source with message: '{\"statusCode\":\"404\",\"error\":\"not_found\",\"message\":\"Object not found\"}' Message: {\"statusCode\":\"404\",\"error\":\"not_found\",\"message\":\"Object not found\"} File: /usr/src/code/vendor/utopia-php/migration/src/Migration/Target.php Line: 154"
]
}
TL;DR
Issue: Having trouble migrating from Supabase to Appwrite, specifically with accessing tables from the "demo-chat" database and importing files.
Solution: As of now, the migration seems to only support the public database. Access restrictions might be causing the inability to import files from the "demo-chat" database, along with the error message mentioning objects not being found. The user is also unable to see tables in different databases that are not part of the public database. 
Maybe access issue to the file?
And one more thing, I am unable to see other tables in different database which is not part of "public" database from supabase.
Any idea?
I have two database in one project (org). "public" & "demo-chat"
I can only able to import "public" database table not the "demo-chat" database
There is no any restrictions for file.
and both databases have data for your app?
Yes
seems like we only support migrating the public database right now 😕
And any idea about file?
what's your project id?
is the file publicly available?
TypeScript
https://fktrlnohgbmayszikpid.supabase.co/storage/v1/object/sign/chats_assets/2/67ddb7d0-f884-11ef-9898-59a30e1b354b-scaled_1000038497.jpg?token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1cmwiOiJjaGF0c19hc3NldHMvMi82N2RkYjdkMC1mODg0LTExZWYtOTg5OC01OWEzMGUxYjM1NGItc2NhbGVkXzEwMDAwMzg0OTcuanBnIiwiaWF0IjoxNzQxMDQ5ODE0LCJleHAiOjE3NzI1ODU4MTR9.L90Qp0Rkfml5S-RmnZOdB1sYbd1zUhlrb6IjQ_YC-Lk
