---
title: "finalize-schema-post-data-import reference"
url: "https://docs.yugabyte.com/stable/yugabyte-voyager/reference/schema-migration/finalize-schema-post-data-import/"
---

# finalize-schema-post-data-import reference

YugabyteDB Voyager finalize-schema-post-data-import reference

yb-voyager finalize-schema-post-data-import

[Finalize the schema](/stable/yugabyte-voyager/migrate/migrate-steps/#finalize-schema-post-data-import "Finalize the schema") post the import of data into YugabyteDB database.

Create [NOT VALID](https://www.postgresql.org/docs/current/sql-altertable.html#SQL-ALTERTABLE-DESC-ADD-TABLE-CONSTRAINT "NOT VALID") constraints in the target schema, and refresh materialized views on the target after [import data](/stable/yugabyte-voyager/migrate/migrate-steps/#import-data "import data") is complete.

## Syntax

```text
Usage: yb-voyager finalize-schema-post-data-import [ <arguments> ...]
```

### Arguments

The following table lists the valid CLI flags and parameters for `finalize-schema-post-data-import` command.

When run at the same time, flags take precedence over configuration flag settings.

CLI flag

Config file parameter Description 

--continue-on-error

```yaml
finalize-schema-post-data-import:
  continue-on-error:
```

Continue to import all the exported schema even if there are errors, and output all the erroneous DDLs to the `failed.sql` file in the `export-dir/schema` directory.  
Default: false  
Example: `yb-voyager finalize-schema-post-data-import ... --continue-on-error true`  
Accepted parameters: true, false, yes, no, 0, 1 

--ignore-exist

```yaml
finalize-schema-post-data-import:
  ignore-exist:
```

Ignore if an object already exists on the target database.  
Default: false  
Example: `yb-voyager finalize-schema-post-data-import ... --ignore-exist true`  
Accepted parameters: true, false, yes, no, 0, 1 

--refresh-mviews

```yaml
finalize-schema-post-data-import:
  refresh-mviews:
```

Refreshes the materialized views on target during the post-import-data phase.  
Default: false  
Accepted parameters: true, false, yes, no, 0, 1 

--target-db-type

```yaml
finalize-schema-post-data-import:
  target-db-type
```

Target database type to import into.  
Accepted values: yugabytedb (default), yugabytedb-amp (more details coming soon) 

--target-db-host

```yaml
target:
  db-host:
```

Domain name or IP address of the machine on which target database server is running.  
Default: 127.0.0.1 

--target-db-name

```yaml
target:
  db-name:
```

Target database name.  
Default: yugabyte 

--target-db-password

```yaml
target:
  db-password:
```

Target database password. Alternatively, you can also specify the password by setting the environment variable `TARGET_DB_PASSWORD`. If you don't provide a password via the CLI or environment variable during any migration phase, yb-voyager will prompt you at runtime for a password. If the password contains special characters that are interpreted by the shell (for example, # and $), enclose the password in single quotes. 

--target-db-port

```yaml
target:
  db-port:
```

Port number of the target database server.  
Default: 5433 

--target-db-schema

```yaml
target:
  db-schema:
```

Schema name of the target YugabyteDB database. MySQL and Oracle migrations only. 

--target-db-user

```yaml
target:
  db-user:
```

Username of the target YugabyteDB database. 

[--target-ssl-cert](/stable/yugabyte-voyager/reference/yb-voyager-cli/#yugabytedb-options "--target-ssl-cert")

```yaml
target:
  ssl-cert:
```

Path to a file containing the certificate which is part of the SSL `<cert,key>` pair. 

[--target-ssl-key](/stable/yugabyte-voyager/reference/yb-voyager-cli/#yugabytedb-options "--target-ssl-key")

```yaml
target:
  ssl-key:
```

Path to a file containing the key which is part of the SSL `<cert,key>` pair. 

[--target-ssl-crl](/stable/yugabyte-voyager/reference/yb-voyager-cli/#yugabytedb-options "--target-ssl-crl")

```yaml
target:
  ssl-crl:
```

Path to a file containing the SSL certificate revocation list (CRL). 

--target-ssl-mode

```yaml
target:
  ssl-mode:
```

Specify the SSL mode for the target database as one of `disable`, `allow`, `prefer` (default), `require`, `verify-ca`, or `verify-full`. 

[--target-ssl-root-cert](/stable/yugabyte-voyager/reference/yb-voyager-cli/#yugabytedb-options "--target-ssl-root-cert")

```yaml
target:
  ssl-root-cert:
```

Path to a file containing SSL certificate authority (CA) certificate(s). 

-e, --export-dir

```yaml
export-dir:
```

Path to the export directory. This directory is a workspace used to store exported schema DDL files, export data files, migration state, and a log file. 

--send-diagnostics

```yaml
send-diagnostics:
```

Enable or disable sending [diagnostics](/stable/yugabyte-voyager/reference/diagnostics-report/ "diagnostics") information to Yugabyte.  
Default: true  
Accepted parameters: true, false, yes, no, 0, 1 

-l, --log-level

```yaml
log-level:
```

Log level for yb-voyager.  
Accepted values: trace, debug, info, warn, error, fatal, panic  
Default: info 

--log-max-size-mb

```yaml
log-max-size-mb:
```

Maximum size in MB of a yb-voyager log file before it is rotated. Also applies to the Debezium log file during live migration.  
Default: 200 

--log-max-backups

```yaml
log-max-backups:
```

Maximum number of rotated log files to retain. Older files are deleted. Use -1 to retain all rotated log files.  
Default: 10 

-h, --help — Command line help. 

-y, --yes — Answer yes to all prompts during the export schema operation.  
Default: false 

-c, --config-file — Path to a [configuration file](/stable/yugabyte-voyager/reference/configuration-file "configuration file"). 

--run-guardrails-checks

```yaml
finalize-schema-post-data-import:
  run-guardrails-checks:
```

Run guardrails checks during migration.  
Default: true  
Accepted values: true, false, yes, no, 0, 1  
**Note**: Setting this flag to false is unsafe, as it skips critical pre-migration validations (such as source/target database permissions, binary dependencies, and version compatibility) and may lead to migration failures or data issues. Leave the default (true) unless you have a specific reason to disable checks.

### Example

Configuration file:

```yaml
yb-voyager finalize-schema-post-data-import --config-file <path-to-config-file>
```

CLI:

```sh
yb-voyager finalize-schema-post-data-import --export-dir /dir/export-dir \
        --target-db-host 127.0.0.1 \
        --target-db-user ybvoyager \
        --target-db-password 'password' \
        --target-db-name target_db \
        --target-db-schema target_schema \
        --refresh-mviews true
```