sql-runner icon indicating copy to clipboard operation
sql-runner copied to clipboard

New playbook format which separates database target from SQL

Open alexanderdean opened this issue 5 years ago • 2 comments

This would be a better abstraction as really the SQL scripts are an intrinsic part of the job-to-be-done (the WHAT) but the target properties/credentials (the WHERE) are orthogonal to this.

alexanderdean avatar Jul 17 '20 11:07 alexanderdean

I like this. A good example of it done well in great_expectations

colmsnowplow avatar Jul 17 '20 11:07 colmsnowplow

Right - that's perfect...

Once we break these out, it becomes safe to come up with a .jar style format which creates a zipped bundle containing all the files (but not the database creds!).

alexanderdean avatar Jul 17 '20 11:07 alexanderdean