feat: onboard irs 990 ein dataset (#481)

GoogleCloudPlatform · Sep 27, 2022 · 65544a2 · 65544a2
1 parent 59f1e61
commit 65544a2
Show file tree

Hide file tree

Showing 17 changed files with 508 additions and 102 deletions.
diff --git a/datasets/irs_990/infra/irs_990_2014_pipeline.tf b/datasets/irs_990/infra/irs_990_2014_pipeline.tf
@@ -1,5 +1,5 @@
 /**
- * Copyright 2021 Google LLC
+ * Copyright 2022 Google LLC
  *
  * Licensed under the Apache License, Version 2.0 (the "License");
  * you may not use this file except in compliance with the License.
@@ -16,15 +16,10 @@
 
 
 resource "google_bigquery_table" "irs_990_irs_990_2014" {
- project = var.project_id
- dataset_id = "irs_990"
- table_id = "irs_990_2014"
-
+ project = var.project_id
+ dataset_id = "irs_990"
+ table_id = "irs_990_2014"
  description = "IRS 990 2014 dataset"
-
-
-
-
  depends_on = [
  google_bigquery_dataset.irs_990
  ]

diff --git a/datasets/irs_990/infra/irs_990_2015_pipeline.tf b/datasets/irs_990/infra/irs_990_2015_pipeline.tf
@@ -1,5 +1,5 @@
 /**
- * Copyright 2021 Google LLC
+ * Copyright 2022 Google LLC
  *
  * Licensed under the Apache License, Version 2.0 (the "License");
  * you may not use this file except in compliance with the License.
@@ -16,15 +16,10 @@
 
 
 resource "google_bigquery_table" "irs_990_irs_990_2015" {
- project = var.project_id
- dataset_id = "irs_990"
- table_id = "irs_990_2015"
-
+ project = var.project_id
+ dataset_id = "irs_990"
+ table_id = "irs_990_2015"
  description = "IRS 990 2015 dataset"
-
-
-
-
  depends_on = [
  google_bigquery_dataset.irs_990
  ]

diff --git a/datasets/irs_990/infra/irs_990_2016_pipeline.tf b/datasets/irs_990/infra/irs_990_2016_pipeline.tf
@@ -1,5 +1,5 @@
 /**
- * Copyright 2021 Google LLC
+ * Copyright 2022 Google LLC
  *
  * Licensed under the Apache License, Version 2.0 (the "License");
  * you may not use this file except in compliance with the License.
@@ -16,15 +16,10 @@
 
 
 resource "google_bigquery_table" "irs_990_irs_990_2016" {
- project = var.project_id
- dataset_id = "irs_990"
- table_id = "irs_990_2016"
-
+ project = var.project_id
+ dataset_id = "irs_990"
+ table_id = "irs_990_2016"
  description = "IRS 990 2016 dataset"
-
-
-
-
  depends_on = [
  google_bigquery_dataset.irs_990
  ]

diff --git a/datasets/irs_990/infra/irs_990_2017_pipeline.tf b/datasets/irs_990/infra/irs_990_2017_pipeline.tf
@@ -1,5 +1,5 @@
 /**
- * Copyright 2021 Google LLC
+ * Copyright 2022 Google LLC
  *
  * Licensed under the Apache License, Version 2.0 (the "License");
  * you may not use this file except in compliance with the License.
@@ -16,15 +16,10 @@
 
 
 resource "google_bigquery_table" "irs_990_irs_990_2017" {
- project = var.project_id
- dataset_id = "irs_990"
- table_id = "irs_990_2017"
-
+ project = var.project_id
+ dataset_id = "irs_990"
+ table_id = "irs_990_2017"
  description = "IRS 990 2017 dataset"
-
-
-
-
  depends_on = [
  google_bigquery_dataset.irs_990
  ]

diff --git a/datasets/irs_990/infra/irs_990_dataset.tf b/datasets/irs_990/infra/irs_990_dataset.tf
@@ -1,5 +1,5 @@
 /**
- * Copyright 2021 Google LLC
+ * Copyright 2022 Google LLC
  *
  * Licensed under the Apache License, Version 2.0 (the "License");
  * you may not use this file except in compliance with the License.

diff --git a/datasets/irs_990/infra/irs_990_ein_pipeline.tf b/datasets/irs_990/infra/irs_990_ein_pipeline.tf
@@ -0,0 +1,34 @@
+/**
+ * Copyright 2022 Google LLC
+ *
+ * Licensed under the Apache License, Version 2.0 (the "License");
+ * you may not use this file except in compliance with the License.
+ * You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+
+resource "google_bigquery_table" "irs_990_irs_990_ein" {
+ project = var.project_id
+ dataset_id = "irs_990"
+ table_id = "irs_990_ein"
+ description = "IRS 990 EIN dataset"
+ depends_on = [
+ google_bigquery_dataset.irs_990
+ ]
+}
+
+output "bigquery_table-irs_990_irs_990_ein-table_id" {
+ value = google_bigquery_table.irs_990_irs_990_ein.table_id
+}
+
+output "bigquery_table-irs_990_irs_990_ein-id" {
+ value = google_bigquery_table.irs_990_irs_990_ein.id
+}
diff --git a/datasets/irs_990/infra/irs_990_ez_2014_pipeline.tf b/datasets/irs_990/infra/irs_990_ez_2014_pipeline.tf
@@ -1,5 +1,5 @@
 /**
- * Copyright 2021 Google LLC
+ * Copyright 2022 Google LLC
  *
  * Licensed under the Apache License, Version 2.0 (the "License");
  * you may not use this file except in compliance with the License.
@@ -16,15 +16,10 @@
 
 
 resource "google_bigquery_table" "irs_990_irs_990_ez_2014" {
- project = var.project_id
- dataset_id = "irs_990"
- table_id = "irs_990_ez_2014"
-
+ project = var.project_id
+ dataset_id = "irs_990"
+ table_id = "irs_990_ez_2014"
  description = "IRS 990 EZ 2014 dataset"
-
-
-
-
  depends_on = [
  google_bigquery_dataset.irs_990
  ]

diff --git a/datasets/irs_990/infra/irs_990_ez_2015_pipeline.tf b/datasets/irs_990/infra/irs_990_ez_2015_pipeline.tf
@@ -1,5 +1,5 @@
 /**
- * Copyright 2021 Google LLC
+ * Copyright 2022 Google LLC
  *
  * Licensed under the Apache License, Version 2.0 (the "License");
  * you may not use this file except in compliance with the License.
@@ -16,15 +16,10 @@
 
 
 resource "google_bigquery_table" "irs_990_irs_990_ez_2015" {
- project = var.project_id
- dataset_id = "irs_990"
- table_id = "irs_990_ez_2015"
-
+ project = var.project_id
+ dataset_id = "irs_990"
+ table_id = "irs_990_ez_2015"
  description = "IRS 990 EZ 2015 dataset"
-
-
-
-
  depends_on = [
  google_bigquery_dataset.irs_990
  ]

diff --git a/datasets/irs_990/infra/irs_990_ez_2016_pipeline.tf b/datasets/irs_990/infra/irs_990_ez_2016_pipeline.tf
@@ -1,5 +1,5 @@
 /**
- * Copyright 2021 Google LLC
+ * Copyright 2022 Google LLC
  *
  * Licensed under the Apache License, Version 2.0 (the "License");
  * you may not use this file except in compliance with the License.
@@ -16,15 +16,10 @@
 
 
 resource "google_bigquery_table" "irs_990_irs_990_ez_2016" {
- project = var.project_id
- dataset_id = "irs_990"
- table_id = "irs_990_ez_2016"
-
+ project = var.project_id
+ dataset_id = "irs_990"
+ table_id = "irs_990_ez_2016"
  description = "IRS 990 EZ 2016 dataset"
-
-
-
-
  depends_on = [
  google_bigquery_dataset.irs_990
  ]

diff --git a/datasets/irs_990/infra/irs_990_ez_2017_pipeline.tf b/datasets/irs_990/infra/irs_990_ez_2017_pipeline.tf
@@ -1,5 +1,5 @@
 /**
- * Copyright 2021 Google LLC
+ * Copyright 2022 Google LLC
  *
  * Licensed under the Apache License, Version 2.0 (the "License");
  * you may not use this file except in compliance with the License.
@@ -16,15 +16,10 @@
 
 
 resource "google_bigquery_table" "irs_990_irs_990_ez_2017" {
- project = var.project_id
- dataset_id = "irs_990"
- table_id = "irs_990_ez_2017"
-
+ project = var.project_id
+ dataset_id = "irs_990"
+ table_id = "irs_990_ez_2017"
  description = "IRS 990 EZ 2017 dataset"
-
-
-
-
  depends_on = [
  google_bigquery_dataset.irs_990
  ]

diff --git a/datasets/irs_990/infra/irs_990_pf_2014_pipeline.tf b/datasets/irs_990/infra/irs_990_pf_2014_pipeline.tf
@@ -1,5 +1,5 @@
 /**
- * Copyright 2021 Google LLC
+ * Copyright 2022 Google LLC
  *
  * Licensed under the Apache License, Version 2.0 (the "License");
  * you may not use this file except in compliance with the License.
@@ -16,15 +16,10 @@
 
 
 resource "google_bigquery_table" "irs_990_irs_990_pf_2014" {
- project = var.project_id
- dataset_id = "irs_990"
- table_id = "irs_990_pf_2014"
-
+ project = var.project_id
+ dataset_id = "irs_990"
+ table_id = "irs_990_pf_2014"
  description = "IRS 990 PF 2014 dataset"
-
-
-
-
  depends_on = [
  google_bigquery_dataset.irs_990
  ]

diff --git a/datasets/irs_990/infra/irs_990_pf_2015_pipeline.tf b/datasets/irs_990/infra/irs_990_pf_2015_pipeline.tf
@@ -1,5 +1,5 @@
 /**
- * Copyright 2021 Google LLC
+ * Copyright 2022 Google LLC
  *
  * Licensed under the Apache License, Version 2.0 (the "License");
  * you may not use this file except in compliance with the License.
@@ -16,15 +16,10 @@
 
 
 resource "google_bigquery_table" "irs_990_irs_990_pf_2015" {
- project = var.project_id
- dataset_id = "irs_990"
- table_id = "irs_990_pf_2015"
-
+ project = var.project_id
+ dataset_id = "irs_990"
+ table_id = "irs_990_pf_2015"
  description = "IRS 990 PF 2015 dataset"
-
-
-
-
  depends_on = [
  google_bigquery_dataset.irs_990
  ]

diff --git a/datasets/irs_990/infra/irs_990_pf_2016_pipeline.tf b/datasets/irs_990/infra/irs_990_pf_2016_pipeline.tf
@@ -1,5 +1,5 @@
 /**
- * Copyright 2021 Google LLC
+ * Copyright 2022 Google LLC
  *
  * Licensed under the Apache License, Version 2.0 (the "License");
  * you may not use this file except in compliance with the License.
@@ -16,15 +16,10 @@
 
 
 resource "google_bigquery_table" "irs_990_irs_990_pf_2016" {
- project = var.project_id
- dataset_id = "irs_990"
- table_id = "irs_990_pf_2016"
-
+ project = var.project_id
+ dataset_id = "irs_990"
+ table_id = "irs_990_pf_2016"
  description = "IRS 990 PF 2016 dataset"
-
-
-
-
  depends_on = [
  google_bigquery_dataset.irs_990
  ]

diff --git a/datasets/irs_990/infra/provider.tf b/datasets/irs_990/infra/provider.tf
@@ -1,5 +1,5 @@
 /**
- * Copyright 2021 Google LLC
+ * Copyright 2022 Google LLC
  *
  * Licensed under the Apache License, Version 2.0 (the "License");
  * you may not use this file except in compliance with the License.

diff --git a/datasets/irs_990/infra/variables.tf b/datasets/irs_990/infra/variables.tf
@@ -1,5 +1,5 @@
 /**
- * Copyright 2021 Google LLC
+ * Copyright 2022 Google LLC
  *
  * Licensed under the Apache License, Version 2.0 (the "License");
  * you may not use this file except in compliance with the License.
@@ -20,4 +20,7 @@ variable "bucket_name_prefix" {}
 variable "impersonating_acct" {}
 variable "region" {}
 variable "env" {}
+variable "iam_policies" {
+ default = {}
+}