SQL Exploration and QA Template

sql_exploration_qa_template.sql

/* INTRODUCTION
--------------------------------------------------
Enter primary exploration reason here
Enter additional comments here, if needed

DB Table(s) Explored:
db.table_one
db.table_two
db.table_three

Researcher: Name(s)
Date: Date
*/

/* EXPLORATION + QA */
--------------------------------------------------

-- 1. Enter QA Question/Comment here

-- QUERY
-- Documentation here, or in-line (if necessary)
QUERY HERE

-- FINDINGS
-- Answer / Data Discrepancy Found / etc.

--2. Enter QA Question/Comment here

-- QUERY
-- Documentation here, or in-line (if necessary)
QUERY HERE

-- FINDINGS
-- Answer / Data Discrepancy Found / etc.

-- 3. Enter QA Question/Comment here

-- QUERY
-- Documentation here, or in-line (if necessary)
QUERY HERE

-- FINDINGS
-- Answer / Data Discrepancy Found / etc.

/* ACTION ITEMS
--------------------------------------------------
1.
2.
3.
*/