Overview Quickstart CLI Commands .sql Models .py Models profiles.yml sources.yml Execution Paths

SINGLESTORE

Distributed SQL database for real-time analytics and transactions. MySQL wire-protocol compatible with scale-out architecture.

PREREQUISITES

Driver: singlestoredb — installed automatically by:

dvt sync

CONFIGURATION FIELDS

FIELD	TYPE	REQUIRED	DEFAULT	DESCRIPTION
type	string	yes	—	Must be `singlestore`
host	string	yes	localhost	SingleStore server hostname
port	integer	no	3306	Server port
user	string	yes	—	Database username
password	string	yes	—	Database password
database	string	yes	—	Database name
threads	integer	no	4	Number of parallel threads

PROFILES.YML EXAMPLE

my_project:
  target: s2_dev
  outputs:
    s2_dev:
      type: singlestore
      host: singlestore.internal.com
      port: 3306
      user: admin
      password: "{{ env_var('S2_PASSWORD') }}"
      database: analytics

SOURCES.YML EXAMPLE

sources:
  - name: realtime_db
    connection: s2_dev
    database: operations
    tables:
      - name: transactions
      - name: inventory

INCREMENTAL STRATEGIES

✓ Append✓ Delete+Insert✓ Merge

KNOWN LIMITATIONS

⚠Uses MySQL wire protocol — connects via mysql:// URL internally