SQLite

Parameters

Required parameters are in red and Optional parameters are in blue.

---

• database_path, the full path to a sqlite database
  this filepath may not yet exist, but it must end in .db

---

• pragma_speedy_inserts, whether or not to set PRAGMAs to improve INSERT performance
  default: False ( allowed: True, False )

---

• load_strategy, how to write new data into existing tables
  default: APPEND ( allowed: APPEND, TRUNCATE, UPSERT )

How do I use the Syncer in commands?

CS Tools accepts syncer definitions in either declarative or configuration file form.

_{Find the copy button to the right of the code block.}

  Declarative   Configuration File

Simply write the parameters out alongside the command.

cs_tools tools searchable metadata --syncer "sqlite://database_path=thoughtspot.db" --config dogfood

^{* when declaring multiple parameters inline, you should wrap the enter value in quotes.}

1. Create a file with the .toml extension.

   syncer-overwrite.toml

   [configuration]
   database_path = "thoughtspot.db"
   pragma_speedy_inserts = true
   load_strategy = "TRUNCATE"
   

   ^{* this is a complete example, not all parameters are required.}

2. Write the filename in your command in place of the parameters.

   cs_tools tools searchable metadata --syncer sqlite://syncer-overwrite.toml --config dogfood