How to manually edit metabase deployed on SQLite

This article’s objective is to describe how to manually modify contents of Querona’s metabase stored in SQLite.

Warning

Direct modification of Querona’s metabase from Querona’s GUI is not supported and should be done only when instructed by support personnel.

Prerequisites

  1. Ensure that you have administrative privileges on the Windows Server that hosts Querona.
  2. Obtain the path of Querona’s metabase location. The default metabase storage location is %ProgramData%\Querona\qmeta.db.
  3. Navigate to SQLite tools. From section “Precompiled Binaries for Windows” download the file sqlite-tools-win32-x86-3290000.zip (or similar depending on the available version).
  4. Unpack and copy SQLite tools files into a folder on the Windows machine hosting Querona.
  5. Prepare a backup of a file %ProgramData%\Querona\qmeta.db by copying it to a separate folder.

Note

The SQLite command line tools documentation can be found at https://sqlite.org/cli.html.

Manually edit metabase deployed on SQLite

  1. Log-in to the Windows machine hosting Querona using Remote Desktop or log-in interactively.
  2. Open Windows Command Prompt by Windows Start ‣ Run, type cmd an press Enter. The command line appears.
  3. In command prompt change the current directory to the folder %ProgramData%\Querona.
  4. Run command sqlite3.exe c:\programdata\Querona\qmeta.db where the path to a database file needs to be an absolute path without environment variables. A SQLite command prompt appears.
  5. Verify that the proper database was open by running command .tables. A list of Querona metabase tables should appear. If the list is empty, it means that the database file was not found. In such a case, please check the path to a database file or contact support.
  6. Run command .header on.
  7. Run command .mode column.
  8. Execute SQL commands as instructed by Querona’s support.