dtookey
|
189dfdad3f
|
Added some statements to deduplicate project descriptions
|
4 years ago |
|
dtookey
|
361da98ad2
|
added email addresses to the engineering contribution table
|
4 years ago |
|
dtookey
|
7d702c9719
|
cleaning up MORE typos from refactoring
|
4 years ago |
|
dtookey
|
f9ce3b899f
|
cleaning up typos from refactoring
|
4 years ago |
|
dtookey
|
01cf9697d2
|
tweaked column names. hope this doesn't bite me
|
4 years ago |
|
dtookey
|
221ddd411b
|
Fixed a typo in a query for contributions.sql
|
4 years ago |
|
dtookey
|
40b2a32418
|
tidied up some sanitize stuff.
modifiend rdu_soil contributions to only pull rdu soil projects
|
4 years ago |
|
dtookey
|
5512550dc2
|
wait, did i break everything with a bad variable name?
|
4 years ago |
|
dtookey
|
4b5344f321
|
Revert "removed the where statement for @soil_techs in contributions.sql. I have a script on the company directory that updates a Google sheet with all the dept/division info in it. I think we'll do a join on the data in order to constrain it inside Datastudio."
This reverts commit 4db0e8dd14.
|
4 years ago |
|
dtookey
|
50b49e0657
|
Revert "removed begin/end block that was throwing errors"
This reverts commit 21b3bf3aa4.
# Conflicts:
# src/sql/0-run-first/contributions.sql
|
4 years ago |
|
dtookey
|
5453cc0c31
|
Revert "removed technician classification since we can get that table from google sheets"
This reverts commit e3a13374db.
|
4 years ago |
|
dtookey
|
48dc463cd4
|
Revert "cleaned up 1-sanitize_init.sql"
This reverts commit 8c011587
|
4 years ago |
|
dtookey
|
8c0115871b
|
cleaned up 1-sanitize_init.sql
|
4 years ago |
|
dtookey
|
e3a13374db
|
removed technician classification since we can get that table from google sheets
|
4 years ago |
|
dtookey
|
21b3bf3aa4
|
removed begin/end block that was throwing errors
|
4 years ago |
|
dtookey
|
8846cb4287
|
removed list of field tech emails.
|
4 years ago |
|
dtookey
|
4db0e8dd14
|
removed the where statement for @soil_techs in contributions.sql. I have a script on the company directory that updates a Google sheet with all the dept/division info in it. I think we'll do a join on the data in order to constrain it inside Datastudio.
|
4 years ago |
|
dtookey
|
3df0ed1ab9
|
added table for rdu_soil_contributions.
|
4 years ago |
|
dtookey
|
8ac07dea51
|
Yep, sure was a syntax error.
|
4 years ago |
|
dtookey
|
8d42c8d3af
|
Yep, sure was a syntax error.
|
4 years ago |
|
dtookey
|
61fe941d68
|
Import isn't going well. There's an issue with the CREATE TABLE syntax in contributions.sql
|
4 years ago |
|
dtookey
|
25128ae538
|
removed debug select from contributions.sql
|
4 years ago |
|
dtookey
|
874c349eb2
|
Deduplication complete!
|
4 years ago |
|
dtookey
|
7b94b13f61
|
Deduplication complete!
|
4 years ago |
|
dtookey
|
34400dacc3
|
I think I have the engineering contributions report deduplicated.
|
4 years ago |
|
dtookey
|
7de71948c3
|
corrected a bunch of timestamps in order to improve local-time accuracy.
|
4 years ago |
|
dtookey
|
3ec8ffbef2
|
Tweaked timestamps in project_lifecycle in order to shift it down 4 hours to local time from UTC. I guess this project officially doesn't recognize Standard Time.
|
4 years ago |
|
dtookey
|
194cbd64af
|
first attempt at speeding up execution time of 1-sanitize_init.sql
|
4 years ago |
|
dtookey
|
cb15790501
|
simplified sanitizing created project events in project_lifecycles.
|
4 years ago |
|
dtookey
|
78bbd9a706
|
The finalization pass was a dumb idea. We'll just put the per-table/concept sanitization in their file. We need these to happen before the other scripts run because we denormalize the data for performance.
|
4 years ago |
|
dtookey
|
efbe425e35
|
Accidentally included a debug select in here with no terminating delimiter.
|
4 years ago |
|
dtookey
|
77bb9b9d6a
|
introduced a sanitization pass at the very end of the import.
|
4 years ago |
|
dtookey
|
65423f0207
|
tweak to contributions.sql to use table alias
|
4 years ago |
|
dtookey
|
8cfc26b68b
|
added work type descriptions
|
4 years ago |
|
dtookey
|
ed6bb0ace1
|
tweaked the import script a little to make the output more clear
|
4 years ago |
|
dtookey
|
eb456449d2
|
first attempt at contribution metrics
|
4 years ago |
|
dtookey
|
d6048d4f45
|
Added todo to all_projects.sql
|
4 years ago |
|
dtookey
|
9d6e346f67
|
added created to lifecycle times
|
4 years ago |
|
dtookey
|
0cdc75925a
|
first stab at durations.sql
|
4 years ago |
|
dtookey
|
d46852cd9a
|
added client name to billing report
|
4 years ago |
|
dtookey
|
3ffa03f765
|
added clients into billing report info
|
4 years ago |
|
dtookey
|
b85f83bb6a
|
added prefix to event_counts in order to concat the division info later.
|
4 years ago |
|
dtookey
|
217e833756
|
The issue appears to be the division prettification in lifecycle.sql.
Changed it to simply grab the project type, we can grok the division info in datastudio
|
4 years ago |
|
dtookey
|
b8b74efca2
|
changing import script to have a bit better resolution into what's running
|
4 years ago |
|
dtookey
|
6b1fc9bcc8
|
changing import script to have a bit better resolution into what's running
|
4 years ago |
|
dtookey
|
2e84d53a05
|
we're up to the hail mary portion of the initial setup.
|
4 years ago |
|
dtookey
|
6173e8e774
|
added index to billing for reference numbers to hopefully speed up query times.
|
4 years ago |
|
dtookey
|
022e7bbee6
|
removed data-reformatting in billing.sql
|
4 years ago |
|
dtookey
|
2d6a190cff
|
trying to add an index to billing_report to see if that alleviates any long-query issues.
|
4 years ago |
|
dtookey
|
ab8defde4d
|
Found the bug. there was no delimiter at the end of billing.sql
|
4 years ago |