Import a schema

Start an import

A script import runs against an existing schema. You can import into an empty schema or one that already has content; objects that already exist are skipped.

In the app: Data Model › Schemas › your schema › Info tab › ACTIONS › Import Database Objects From Script

[screenshot]
The Import Database Objects From Script dialog with a file selected and Start Import enabled.

Before you start

  • You need Read/Write access to the schema, and the organization must not be in read-only mode.
  • Have the script ready: a .sql, .yaml, .yml, .json or .txt file, or text to paste, up to 5 MB. See Supported import file formats.
  • Only one script import can run per schema at a time. A second one is refused with An import is already in progress for this schema. Please wait for it to complete.

Tip: Creating a new schema from a script? Use the Create Schema wizard’s Create from a script card, which creates the schema and starts the import in one go. See Create a schema.

Steps

  1. Open the schema and go to the Info tab.
  2. In the ACTIONS card, click Import Database Objects From Script.
  3. Choose the source:
    • Upload file: drag a file onto the drop zone, or click it to browse. Check the file name and size that appear.
    • Paste script: paste into the Paste Script box. A counter shows how much of the 5 MB you’ve used.
  4. Click Start Import.

Nothing is written until you click Start Import. Click Cancel to back out.

What happens next

  • The import runs in the background. You can leave the page or close the browser; it keeps going.
  • Kenseme takes you to Organization Settings › Schema Imports, which lists imports with their status and progress. Click the open icon on a row to see the full import detail page.
  • The schema stays usable while the import runs. Objects appear on their tabs as each stage finishes.
  • Imports also appear on the Activity page.

Note: Organization Settings is only open to organization admins. If you aren’t an admin, you’ll see the import’s results on the schema’s tabs as they arrive, but you won’t be able to open the import detail page. Ask an admin to check failed items for you.

When the import finishes