 Paul Trowbridge
|
babdd3c8a7
|
update progress on baseline
|
2020-11-08 22:30:15 -05:00 |
|
Paul Trowbridge
|
79d3a7751c
|
move script to generate sql statements
|
2020-11-08 22:20:15 -05:00 |
|
Paul Trowbridge
|
06488cae18
|
forecaste name, insert statement, delete statement , and orders cutuff
|
2020-11-08 22:16:40 -05:00 |
|
Paul Trowbridge
|
8da4a929e0
|
remove references to old files
|
2020-11-08 22:15:23 -05:00 |
|
Paul Trowbridge
|
25eea2ac13
|
create the final baselin
|
2020-11-08 21:04:50 -05:00 |
|
Paul Trowbridge
|
2610228c06
|
rename stuff, build shell script, include ignore file so routes sql is ignored for clones
|
2020-11-06 00:24:18 -05:00 |
|
Paul Trowbridge
|
73f7667ef7
|
get column list for plu to increment year
|
2020-11-06 00:12:05 -05:00 |
|
Paul Trowbridge
|
b6edc4006a
|
comments
|
2020-11-06 00:00:34 -05:00 |
|
Paul Trowbridge
|
15b515a5e1
|
begin unioning in the piece used to plug the remainder of the year to create a full baseline
|
2020-11-05 23:58:29 -05:00 |
|
Paul Trowbridge
|
fcac081823
|
add the notion of an appcolumn, and use it to push into variables to generate route sql
|
2020-11-05 23:50:02 -05:00 |
|
Paul Trowbridge
|
d9bfe43d2e
|
initial select with column list combined with body for ytd
|
2020-11-05 23:01:03 -05:00 |
|
Paul Trowbridge
|
4b55ab4394
|
put sql generating statemts into their own folder
|
2020-11-05 22:39:36 -05:00 |
|
Paul Trowbridge
|
9c9a345f0a
|
move setup sql into a different folder
|
2020-11-05 22:35:40 -05:00 |
|
Paul Trowbridge
|
d6dbf54ec6
|
only increment fields by an interval that are actually dates
|
2020-11-05 22:32:27 -05:00 |
|
Paul Trowbridge
|
9e53758fd9
|
include schema name in table name column
|
2020-11-05 22:31:55 -05:00 |
|
Paul Trowbridge
|
a15d807178
|
include a reference to corresponding column from the foreign table but that has a different name (like oseas = ssyr from table perd)
|
2020-11-05 22:31:27 -05:00 |
|
Paul Trowbridge
|
0452bde160
|
sort the columns normally except push the primary key(s) into the first positiong
|
2020-11-05 22:30:28 -05:00 |
|
Paul Trowbridge
|
55dcb65a17
|
new column list to increment date periods
|
2020-11-04 22:58:13 -05:00 |
|
Paul Trowbridge
|
a8419e9fd6
|
change target name, and exlude gld joins intended for snapping months, that should be done during data prep
|
2020-11-04 22:56:54 -05:00 |
|
Paul Trowbridge
|
5134b659c0
|
rename
|
2020-11-04 22:33:31 -05:00 |
|
Paul Trowbridge
|
0307fb6c6b
|
notes
|
2020-10-30 01:19:55 -04:00 |
|
Paul Trowbridge
|
df381ee313
|
push column list into a text variable for downstream use
|
2020-10-30 00:56:48 -04:00 |
|
Paul Trowbridge
|
270eb46123
|
initial work on column builder, driven by shell
|
2020-10-28 00:03:13 -04:00 |
|
Paul Trowbridge
|
1bc21d9940
|
notes on progress
|
2020-10-27 23:48:52 -04:00 |
|
Paul Trowbridge
|
11a8ff2c68
|
notes
|
2020-10-27 23:47:21 -04:00 |
|
Paul Trowbridge
|
975ea43b65
|
initial work on parameterizing baselining process
|
2020-10-27 23:44:14 -04:00 |
|
Paul Trowbridge
|
6d2cacb726
|
change the baseline version names
|
2020-10-27 23:12:10 -04:00 |
|
Paul Trowbridge
|
e12a96df2e
|
comments on work done
|
2020-10-23 00:19:39 -04:00 |
|
Paul Trowbridge
|
d3c9b627e2
|
start working on initial baseline rollout
|
2020-10-23 00:16:55 -04:00 |
|
Paul Trowbridge
|
7abf659939
|
basic tables setup
|
2020-10-22 23:56:45 -04:00 |
|
Paul Trowbridge
|
34af4abfac
|
format
|
2020-10-22 23:36:45 -04:00 |
|
Paul Trowbridge
|
dbee083970
|
update readme to reflect work done so far
|
2020-10-22 23:35:12 -04:00 |
|
Paul Trowbridge
|
fb76e42e42
|
update temp, it just mirrors build query for testing
|
2020-10-22 23:09:34 -04:00 |
|
Paul Trowbridge
|
0f698d5621
|
include foreign key setup
|
2020-10-22 23:08:11 -04:00 |
|
Paul Trowbridge
|
ba93b6b84e
|
replace hardcoded table name to derive from target meta
|
2020-10-22 23:07:17 -04:00 |
|
Paul Trowbridge
|
860b34fad8
|
format so its not so long
|
2020-10-22 22:28:23 -04:00 |
|
Paul Trowbridge
|
82f7a8fff2
|
format the column name as an identity (%I) and only build statements where any fkey for a func is not null (dont build a master table for funcs with no primary key identified)
|
2020-10-22 12:24:10 -04:00 |
|
Paul Trowbridge
|
ae1a32baa7
|
rename column
|
2020-10-22 11:50:15 -04:00 |
|
Paul Trowbridge
|
511a38faf9
|
prevent inserting null keys, and conflicting keys which is possible with disperate master data (maybe use max?)
|
2020-10-22 11:42:50 -04:00 |
|
Paul Trowbridge
|
ba3d9e682e
|
initial work on building schema, related tables
|
2020-10-22 01:22:40 -04:00 |