Skip to content

Commit

Permalink
feat!: Reorganize pipelines and infra files into their respective fol…
Browse files Browse the repository at this point in the history
…ders (#292)

* feat: Revise `generate_terraform` and tests

* feat: Revise `generate_dag` and tests

* feat: Revise `deploy_dag` and tests

* feat: Revise tests for DAG conventions and integrity

* add machine types guide to GKE cluster creation

* revised README for new folder organization

* Moved files into `pipelines` and `infra` folders
  • Loading branch information
adlersantos committed Feb 10, 2022
1 parent 92153a4 commit 7408d44
Show file tree
Hide file tree
Showing 943 changed files with 2,920 additions and 1,773 deletions.
2 changes: 2 additions & 0 deletions .gitignore
Original file line number Diff line number Diff line change
Expand Up @@ -33,3 +33,5 @@ tmp

# ignore temp folders
.tmp

.DS_Store
151 changes: 82 additions & 69 deletions README.md

Large diffs are not rendered by default.

Original file line number Diff line number Diff line change
Expand Up @@ -24,14 +24,3 @@ resource "google_bigquery_dataset" "america_health_rankings" {
output "bigquery_dataset-america_health_rankings-dataset_id" {
value = google_bigquery_dataset.america_health_rankings.dataset_id
}

resource "google_storage_bucket" "america-health-rankings" {
name = "${var.bucket_name_prefix}-america-health-rankings"
force_destroy = true
location = "US"
uniform_bucket_level_access = true
}

output "storage_bucket-america-health-rankings-name" {
value = google_storage_bucket.america-health-rankings.name
}
Original file line number Diff line number Diff line change
Expand Up @@ -13,9 +13,9 @@
# limitations under the License.

dataset:
name: cms_medicare
friendly_name: cms_medicare
description: CMS Medicare
name: america_health_rankings
friendly_name: America Health Rankings
description: America Health Rankings
dataset_sources: ~
terms_of_use: ~

Expand Down
File renamed without changes.
File renamed without changes.
File renamed without changes.
File renamed without changes.
File renamed without changes.
File renamed without changes.
File renamed without changes.
File renamed without changes.
File renamed without changes.
File renamed without changes.
File renamed without changes.
File renamed without changes.
File renamed without changes.
File renamed without changes.
File renamed without changes.
File renamed without changes.
File renamed without changes.
File renamed without changes.
File renamed without changes.
File renamed without changes.
File renamed without changes.
File renamed without changes.
File renamed without changes.
File renamed without changes.
File renamed without changes.
File renamed without changes.
File renamed without changes.
File renamed without changes.
File renamed without changes.
File renamed without changes.
File renamed without changes.
File renamed without changes.
File renamed without changes.
Original file line number Diff line number Diff line change
Expand Up @@ -15,7 +15,7 @@
*/


resource "google_bigquery_table" "cbsa_2019_1yr" {
resource "google_bigquery_table" "census_bureau_acs_cbsa_2019_1yr" {
project = var.project_id
dataset_id = "census_bureau_acs"
table_id = "cbsa_2019_1yr"
Expand All @@ -30,10 +30,10 @@ resource "google_bigquery_table" "cbsa_2019_1yr" {
]
}

output "bigquery_table-cbsa_2019_1yr-table_id" {
value = google_bigquery_table.cbsa_2019_1yr.table_id
output "bigquery_table-census_bureau_acs_cbsa_2019_1yr-table_id" {
value = google_bigquery_table.census_bureau_acs_cbsa_2019_1yr.table_id
}

output "bigquery_table-cbsa_2019_1yr-id" {
value = google_bigquery_table.cbsa_2019_1yr.id
output "bigquery_table-census_bureau_acs_cbsa_2019_1yr-id" {
value = google_bigquery_table.census_bureau_acs_cbsa_2019_1yr.id
}
Original file line number Diff line number Diff line change
Expand Up @@ -15,7 +15,7 @@
*/


resource "google_bigquery_table" "cbsa_2019_5yr" {
resource "google_bigquery_table" "census_bureau_acs_cbsa_2019_5yr" {
project = var.project_id
dataset_id = "census_bureau_acs"
table_id = "cbsa_2019_5yr"
Expand All @@ -30,10 +30,10 @@ resource "google_bigquery_table" "cbsa_2019_5yr" {
]
}

output "bigquery_table-cbsa_2019_5yr-table_id" {
value = google_bigquery_table.cbsa_2019_5yr.table_id
output "bigquery_table-census_bureau_acs_cbsa_2019_5yr-table_id" {
value = google_bigquery_table.census_bureau_acs_cbsa_2019_5yr.table_id
}

output "bigquery_table-cbsa_2019_5yr-id" {
value = google_bigquery_table.cbsa_2019_5yr.id
output "bigquery_table-census_bureau_acs_cbsa_2019_5yr-id" {
value = google_bigquery_table.census_bureau_acs_cbsa_2019_5yr.id
}
Original file line number Diff line number Diff line change
Expand Up @@ -30,6 +30,11 @@ resource "google_storage_bucket" "census-bureau-acs" {
force_destroy = true
location = "US"
uniform_bucket_level_access = true
lifecycle {
ignore_changes = [
logging,
]
}
}

output "storage_bucket-census-bureau-acs-name" {
Expand Down
Original file line number Diff line number Diff line change
Expand Up @@ -15,7 +15,7 @@
*/


resource "google_bigquery_table" "congressionaldistrict_2019_1yr" {
resource "google_bigquery_table" "census_bureau_acs_congressionaldistrict_2019_1yr" {
project = var.project_id
dataset_id = "census_bureau_acs"
table_id = "congressionaldistrict_2019_1yr"
Expand All @@ -30,10 +30,10 @@ resource "google_bigquery_table" "congressionaldistrict_2019_1yr" {
]
}

output "bigquery_table-congressionaldistrict_2019_1yr-table_id" {
value = google_bigquery_table.congressionaldistrict_2019_1yr.table_id
output "bigquery_table-census_bureau_acs_congressionaldistrict_2019_1yr-table_id" {
value = google_bigquery_table.census_bureau_acs_congressionaldistrict_2019_1yr.table_id
}

output "bigquery_table-congressionaldistrict_2019_1yr-id" {
value = google_bigquery_table.congressionaldistrict_2019_1yr.id
output "bigquery_table-census_bureau_acs_congressionaldistrict_2019_1yr-id" {
value = google_bigquery_table.census_bureau_acs_congressionaldistrict_2019_1yr.id
}
Original file line number Diff line number Diff line change
Expand Up @@ -15,7 +15,7 @@
*/


resource "google_bigquery_table" "congressionaldistrict_2019_5yr" {
resource "google_bigquery_table" "census_bureau_acs_congressionaldistrict_2019_5yr" {
project = var.project_id
dataset_id = "census_bureau_acs"
table_id = "congressionaldistrict_2019_5yr"
Expand All @@ -30,10 +30,10 @@ resource "google_bigquery_table" "congressionaldistrict_2019_5yr" {
]
}

output "bigquery_table-congressionaldistrict_2019_5yr-table_id" {
value = google_bigquery_table.congressionaldistrict_2019_5yr.table_id
output "bigquery_table-census_bureau_acs_congressionaldistrict_2019_5yr-table_id" {
value = google_bigquery_table.census_bureau_acs_congressionaldistrict_2019_5yr.table_id
}

output "bigquery_table-congressionaldistrict_2019_5yr-id" {
value = google_bigquery_table.congressionaldistrict_2019_5yr.id
output "bigquery_table-census_bureau_acs_congressionaldistrict_2019_5yr-id" {
value = google_bigquery_table.census_bureau_acs_congressionaldistrict_2019_5yr.id
}
Original file line number Diff line number Diff line change
Expand Up @@ -15,7 +15,7 @@
*/


resource "google_bigquery_table" "county_2019_1yr" {
resource "google_bigquery_table" "census_bureau_acs_county_2019_1yr" {
project = var.project_id
dataset_id = "census_bureau_acs"
table_id = "county_2019_1yr"
Expand All @@ -30,10 +30,10 @@ resource "google_bigquery_table" "county_2019_1yr" {
]
}

output "bigquery_table-county_2019_1yr-table_id" {
value = google_bigquery_table.county_2019_1yr.table_id
output "bigquery_table-census_bureau_acs_county_2019_1yr-table_id" {
value = google_bigquery_table.census_bureau_acs_county_2019_1yr.table_id
}

output "bigquery_table-county_2019_1yr-id" {
value = google_bigquery_table.county_2019_1yr.id
output "bigquery_table-census_bureau_acs_county_2019_1yr-id" {
value = google_bigquery_table.census_bureau_acs_county_2019_1yr.id
}
Original file line number Diff line number Diff line change
Expand Up @@ -15,7 +15,7 @@
*/


resource "google_bigquery_table" "county_2019_5yr" {
resource "google_bigquery_table" "census_bureau_acs_county_2019_5yr" {
project = var.project_id
dataset_id = "census_bureau_acs"
table_id = "county_2019_5yr"
Expand All @@ -30,10 +30,10 @@ resource "google_bigquery_table" "county_2019_5yr" {
]
}

output "bigquery_table-county_2019_5yr-table_id" {
value = google_bigquery_table.county_2019_5yr.table_id
output "bigquery_table-census_bureau_acs_county_2019_5yr-table_id" {
value = google_bigquery_table.census_bureau_acs_county_2019_5yr.table_id
}

output "bigquery_table-county_2019_5yr-id" {
value = google_bigquery_table.county_2019_5yr.id
output "bigquery_table-census_bureau_acs_county_2019_5yr-id" {
value = google_bigquery_table.census_bureau_acs_county_2019_5yr.id
}
Original file line number Diff line number Diff line change
Expand Up @@ -15,7 +15,7 @@
*/


resource "google_bigquery_table" "place_2019_1yr" {
resource "google_bigquery_table" "census_bureau_acs_place_2019_1yr" {
project = var.project_id
dataset_id = "census_bureau_acs"
table_id = "place_2019_1yr"
Expand All @@ -30,10 +30,10 @@ resource "google_bigquery_table" "place_2019_1yr" {
]
}

output "bigquery_table-place_2019_1yr-table_id" {
value = google_bigquery_table.place_2019_1yr.table_id
output "bigquery_table-census_bureau_acs_place_2019_1yr-table_id" {
value = google_bigquery_table.census_bureau_acs_place_2019_1yr.table_id
}

output "bigquery_table-place_2019_1yr-id" {
value = google_bigquery_table.place_2019_1yr.id
output "bigquery_table-census_bureau_acs_place_2019_1yr-id" {
value = google_bigquery_table.census_bureau_acs_place_2019_1yr.id
}
Original file line number Diff line number Diff line change
Expand Up @@ -15,7 +15,7 @@
*/


resource "google_bigquery_table" "place_2019_5yr" {
resource "google_bigquery_table" "census_bureau_acs_place_2019_5yr" {
project = var.project_id
dataset_id = "census_bureau_acs"
table_id = "place_2019_5yr"
Expand All @@ -30,10 +30,10 @@ resource "google_bigquery_table" "place_2019_5yr" {
]
}

output "bigquery_table-place_2019_5yr-table_id" {
value = google_bigquery_table.place_2019_5yr.table_id
output "bigquery_table-census_bureau_acs_place_2019_5yr-table_id" {
value = google_bigquery_table.census_bureau_acs_place_2019_5yr.table_id
}

output "bigquery_table-place_2019_5yr-id" {
value = google_bigquery_table.place_2019_5yr.id
output "bigquery_table-census_bureau_acs_place_2019_5yr-id" {
value = google_bigquery_table.census_bureau_acs_place_2019_5yr.id
}
Original file line number Diff line number Diff line change
Expand Up @@ -15,7 +15,7 @@
*/


resource "google_bigquery_table" "puma_2019_1yr" {
resource "google_bigquery_table" "census_bureau_acs_puma_2019_1yr" {
project = var.project_id
dataset_id = "census_bureau_acs"
table_id = "puma_2019_1yr"
Expand All @@ -30,10 +30,10 @@ resource "google_bigquery_table" "puma_2019_1yr" {
]
}

output "bigquery_table-puma_2019_1yr-table_id" {
value = google_bigquery_table.puma_2019_1yr.table_id
output "bigquery_table-census_bureau_acs_puma_2019_1yr-table_id" {
value = google_bigquery_table.census_bureau_acs_puma_2019_1yr.table_id
}

output "bigquery_table-puma_2019_1yr-id" {
value = google_bigquery_table.puma_2019_1yr.id
output "bigquery_table-census_bureau_acs_puma_2019_1yr-id" {
value = google_bigquery_table.census_bureau_acs_puma_2019_1yr.id
}
Original file line number Diff line number Diff line change
Expand Up @@ -15,7 +15,7 @@
*/


resource "google_bigquery_table" "puma_2019_5yr" {
resource "google_bigquery_table" "census_bureau_acs_puma_2019_5yr" {
project = var.project_id
dataset_id = "census_bureau_acs"
table_id = "puma_2019_5yr"
Expand All @@ -30,10 +30,10 @@ resource "google_bigquery_table" "puma_2019_5yr" {
]
}

output "bigquery_table-puma_2019_5yr-table_id" {
value = google_bigquery_table.puma_2019_5yr.table_id
output "bigquery_table-census_bureau_acs_puma_2019_5yr-table_id" {
value = google_bigquery_table.census_bureau_acs_puma_2019_5yr.table_id
}

output "bigquery_table-puma_2019_5yr-id" {
value = google_bigquery_table.puma_2019_5yr.id
output "bigquery_table-census_bureau_acs_puma_2019_5yr-id" {
value = google_bigquery_table.census_bureau_acs_puma_2019_5yr.id
}
Original file line number Diff line number Diff line change
Expand Up @@ -15,7 +15,7 @@
*/


resource "google_bigquery_table" "schooldistrictelementary_2019_1yr" {
resource "google_bigquery_table" "census_bureau_acs_schooldistrictelementary_2019_1yr" {
project = var.project_id
dataset_id = "census_bureau_acs"
table_id = "schooldistrictelementary_2019_1yr"
Expand All @@ -30,10 +30,10 @@ resource "google_bigquery_table" "schooldistrictelementary_2019_1yr" {
]
}

output "bigquery_table-schooldistrictelementary_2019_1yr-table_id" {
value = google_bigquery_table.schooldistrictelementary_2019_1yr.table_id
output "bigquery_table-census_bureau_acs_schooldistrictelementary_2019_1yr-table_id" {
value = google_bigquery_table.census_bureau_acs_schooldistrictelementary_2019_1yr.table_id
}

output "bigquery_table-schooldistrictelementary_2019_1yr-id" {
value = google_bigquery_table.schooldistrictelementary_2019_1yr.id
output "bigquery_table-census_bureau_acs_schooldistrictelementary_2019_1yr-id" {
value = google_bigquery_table.census_bureau_acs_schooldistrictelementary_2019_1yr.id
}
Original file line number Diff line number Diff line change
Expand Up @@ -15,7 +15,7 @@
*/


resource "google_bigquery_table" "schooldistrictelementary_2019_5yr" {
resource "google_bigquery_table" "census_bureau_acs_schooldistrictelementary_2019_5yr" {
project = var.project_id
dataset_id = "census_bureau_acs"
table_id = "schooldistrictelementary_2019_5yr"
Expand All @@ -30,10 +30,10 @@ resource "google_bigquery_table" "schooldistrictelementary_2019_5yr" {
]
}

output "bigquery_table-schooldistrictelementary_2019_5yr-table_id" {
value = google_bigquery_table.schooldistrictelementary_2019_5yr.table_id
output "bigquery_table-census_bureau_acs_schooldistrictelementary_2019_5yr-table_id" {
value = google_bigquery_table.census_bureau_acs_schooldistrictelementary_2019_5yr.table_id
}

output "bigquery_table-schooldistrictelementary_2019_5yr-id" {
value = google_bigquery_table.schooldistrictelementary_2019_5yr.id
output "bigquery_table-census_bureau_acs_schooldistrictelementary_2019_5yr-id" {
value = google_bigquery_table.census_bureau_acs_schooldistrictelementary_2019_5yr.id
}
Original file line number Diff line number Diff line change
Expand Up @@ -15,7 +15,7 @@
*/


resource "google_bigquery_table" "schooldistrictsecondary_2019_1yr" {
resource "google_bigquery_table" "census_bureau_acs_schooldistrictsecondary_2019_1yr" {
project = var.project_id
dataset_id = "census_bureau_acs"
table_id = "schooldistrictsecondary_2019_1yr"
Expand All @@ -30,10 +30,10 @@ resource "google_bigquery_table" "schooldistrictsecondary_2019_1yr" {
]
}

output "bigquery_table-schooldistrictsecondary_2019_1yr-table_id" {
value = google_bigquery_table.schooldistrictsecondary_2019_1yr.table_id
output "bigquery_table-census_bureau_acs_schooldistrictsecondary_2019_1yr-table_id" {
value = google_bigquery_table.census_bureau_acs_schooldistrictsecondary_2019_1yr.table_id
}

output "bigquery_table-schooldistrictsecondary_2019_1yr-id" {
value = google_bigquery_table.schooldistrictsecondary_2019_1yr.id
output "bigquery_table-census_bureau_acs_schooldistrictsecondary_2019_1yr-id" {
value = google_bigquery_table.census_bureau_acs_schooldistrictsecondary_2019_1yr.id
}
Original file line number Diff line number Diff line change
Expand Up @@ -15,7 +15,7 @@
*/


resource "google_bigquery_table" "schooldistrictsecondary_2019_5yr" {
resource "google_bigquery_table" "census_bureau_acs_schooldistrictsecondary_2019_5yr" {
project = var.project_id
dataset_id = "census_bureau_acs"
table_id = "schooldistrictsecondary_2019_5yr"
Expand All @@ -30,10 +30,10 @@ resource "google_bigquery_table" "schooldistrictsecondary_2019_5yr" {
]
}

output "bigquery_table-schooldistrictsecondary_2019_5yr-table_id" {
value = google_bigquery_table.schooldistrictsecondary_2019_5yr.table_id
output "bigquery_table-census_bureau_acs_schooldistrictsecondary_2019_5yr-table_id" {
value = google_bigquery_table.census_bureau_acs_schooldistrictsecondary_2019_5yr.table_id
}

output "bigquery_table-schooldistrictsecondary_2019_5yr-id" {
value = google_bigquery_table.schooldistrictsecondary_2019_5yr.id
output "bigquery_table-census_bureau_acs_schooldistrictsecondary_2019_5yr-id" {
value = google_bigquery_table.census_bureau_acs_schooldistrictsecondary_2019_5yr.id
}

0 comments on commit 7408d44

Please sign in to comment.