Class - jobs.job_snapshot.JobSnapshotConfig

JSON Schema

JobSnapshotConfig

Configuration parameters for the snapshot job. The job creates a snapshot for an existing database table.

Example with all options:

{
   dbo: postgresql://localhost/analytics
   tables: [
      {
         snapshot_schema: snapshots
         snapshot_table: films
         source_schema: public
         source_table: films
      }
   ]
}

type

object

properties

  • dbo

Dbo

The database dbo to use when executing an SQL query to create a snapshot.

type

string

  • tables

Tables

The list of dicts containing info about source/snapshot schemas and table names to be used.

type

array

items

type

object

  • kwargs

Kwargs

Options for the SQLAlchemy create_engine() function

type

object

default

  • transaction

Transaction

By default, DB’s snapshot creation runs as transaction. Read more: https://docs.sqlalchemy.org/en/14/core/connections.html#using-transactions

type

boolean

default

True