If an extract fails with the error “Error running extract: schema does not exist or not authorized,” it usually points to a problem with the destination it’s trying to load into.
Common causes
- A typo in one of the objects referenced in the extract’s destination (the database, schema, or table name).
- The database or schema referenced in the destination hasn’t been created yet.
What to do
Check the destination settings on the extract for typos and confirm that the database and schema it references actually exist.
If the database or schema doesn’t exist yet, create it from the SQL Console with a CREATE statement, for example:
CREATE SCHEMA PROD.MY_SCHEMATables don’t need to be created manually — Kleene creates them as needed when extracts and transforms run. Once the referenced database and schema exist, re-run the extract.
If this hasn’t resolved your issue, raise a ticket with Kleene Support for further assistance.