Microsoft Fabric Error:
Table or View Already Exists
What does this error mean?
A CREATE TABLE or CREATE VIEW statement in a Fabric Lakehouse notebook or pipeline failed because an object with that name already exists in the catalog.
Common causes
- 1Running a notebook cell that contains a CREATE TABLE statement multiple times without dropping the table first
- 2A pipeline without IF NOT EXISTS guards re-runs after a partial failure and tries to recreate already-created tables
- 3A materialized view with the same name already exists in the workspace
How to fix it
- 1Use CREATE TABLE IF NOT EXISTS <name> instead of CREATE TABLE <name> to make the statement idempotent.
- 2Alternatively, drop the table first: DROP TABLE IF EXISTS <name>, then run the CREATE statement.
- 3For pipeline activities, add a check at the start that skips table creation if the table already exists.
Beyond the docs
Common practitioner solutions not covered in the official documentation.
- 1If the existing table has stale data, use INSERT OVERWRITE or a TRUNCATE + INSERT pattern instead of recreating the table