The Data Studio

SQL Scripts To Create Data Quality Database Tables

You can use these as you choose. All the samples have been tested, but you use them entirely at your own risk. We take no reponsibility for what you do with them.

You can download a tar or zip archive of all the source files, or access them individually.

Compressed tar file, usually better for for UNIX and Mac compressed tar file
Zipped file, usually better for Windows zip file

Individual Files

Description Download link
Overall script: creates the tables in the right order, respecting dependencies create_tables.sql
Configurations for file locations, user interface, etc. create_configuration.sql
Connections for databases to be monitored create_connection.sql
Name of query script file, connection to be used for query, run frequency create_query.sql
Title, trend-or-zero-sum query, thresholds, main source measured create_factor.sql
Title of group of factors, sequence of group on summary page create_factor_group.sql
Which factors belong in which groups create_group_factor_map.sql
Factor, run date and value - complete history (unless purged manually), ignore for anomalous values (after they have been resolved) create_measure.sql
For data profiler: table-level profile create_table_profile.sql
For data profiler: column-level profile create_column_profile.sql
For data profiler: Most-common patterns of values in columns create_pattern.sql
For data profiler: Most-common and least-common frequency of values in columns create_frequency.sql