About Checkpoint SQL

Checkpoint SQL is a collection of SQL statements that can be used to check the status of your implementation along the way and is used to verify that the proper tables have been loaded with the appropriate data.

Within the Checkpoint SQL file, sample SQL code is organized by section number and title, to help you coordinate between the place in the documentation and the relevant SQL statement

Each statement should be run in some type of SQL query tool that is specific to the type of database in your implementation. The Checkpoint SQL file is provided in the Workbench project, in the \SQL folder, in a file called checkpoint_sql.txt.

Checkpoint SQL contains the following items:
  • Member Count
  • Entity Count
  • Bucket Count
  • Comp String Count
  • Member Task Count
  • Entity Task Count
  • Wgt Tables
  • Member Rules Count
  • Entity Rules Count
  • String Frequency Count
  • Segment Count
  • Count of Sources
  • Count of Attributes
  • Thresholds
  • Member & Entity Types
  • Active Composite View