feat: Onboard Fec dataset (#485)

GoogleCloudPlatform · Sep 27, 2022 · 2da413e · 2da413e
1 parent 65544a2
commit 2da413e
Show file tree

Hide file tree

Showing 67 changed files with 10,419 additions and 0 deletions.
diff --git a/datasets/fec/infra/candidate_2016_pipeline.tf b/datasets/fec/infra/candidate_2016_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" "fec_candidate_2016" {
+ project = var.project_id
+ dataset_id = "fec"
+ table_id = "candidate_2016"
+ description = "FEC table"
+ depends_on = [
+ google_bigquery_dataset.fec
+ ]
+}
+
+output "bigquery_table-fec_candidate_2016-table_id" {
+ value = google_bigquery_table.fec_candidate_2016.table_id
+}
+
+output "bigquery_table-fec_candidate_2016-id" {
+ value = google_bigquery_table.fec_candidate_2016.id
+}
diff --git a/datasets/fec/infra/candidate_2018_pipeline.tf b/datasets/fec/infra/candidate_2018_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" "fec_candidate_2018" {
+ project = var.project_id
+ dataset_id = "fec"
+ table_id = "candidate_2018"
+ description = "FEC table"
+ depends_on = [
+ google_bigquery_dataset.fec
+ ]
+}
+
+output "bigquery_table-fec_candidate_2018-table_id" {
+ value = google_bigquery_table.fec_candidate_2018.table_id
+}
+
+output "bigquery_table-fec_candidate_2018-id" {
+ value = google_bigquery_table.fec_candidate_2018.id
+}
diff --git a/datasets/fec/infra/candidate_2020_pipeline.tf b/datasets/fec/infra/candidate_2020_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" "fec_candidate_2020" {
+ project = var.project_id
+ dataset_id = "fec"
+ table_id = "candidate_2020"
+ description = "FEC table"
+ depends_on = [
+ google_bigquery_dataset.fec
+ ]
+}
+
+output "bigquery_table-fec_candidate_2020-table_id" {
+ value = google_bigquery_table.fec_candidate_2020.table_id
+}
+
+output "bigquery_table-fec_candidate_2020-id" {
+ value = google_bigquery_table.fec_candidate_2020.id
+}
diff --git a/datasets/fec/infra/candidate_committee_2016_pipeline.tf b/datasets/fec/infra/candidate_committee_2016_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" "fec_candidate_committee_2016" {
+ project = var.project_id
+ dataset_id = "fec"
+ table_id = "candidate_committee_2016"
+ description = "FEC table"
+ depends_on = [
+ google_bigquery_dataset.fec
+ ]
+}
+
+output "bigquery_table-fec_candidate_committee_2016-table_id" {
+ value = google_bigquery_table.fec_candidate_committee_2016.table_id
+}
+
+output "bigquery_table-fec_candidate_committee_2016-id" {
+ value = google_bigquery_table.fec_candidate_committee_2016.id
+}
diff --git a/datasets/fec/infra/candidate_committee_2018_pipeline.tf b/datasets/fec/infra/candidate_committee_2018_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" "fec_candidate_committee_2018" {
+ project = var.project_id
+ dataset_id = "fec"
+ table_id = "candidate_committee_2018"
+ description = "FEC table"
+ depends_on = [
+ google_bigquery_dataset.fec
+ ]
+}
+
+output "bigquery_table-fec_candidate_committee_2018-table_id" {
+ value = google_bigquery_table.fec_candidate_committee_2018.table_id
+}
+
+output "bigquery_table-fec_candidate_committee_2018-id" {
+ value = google_bigquery_table.fec_candidate_committee_2018.id
+}
diff --git a/datasets/fec/infra/candidate_committee_2020_pipeline.tf b/datasets/fec/infra/candidate_committee_2020_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" "fec_candidate_committee_2020" {
+ project = var.project_id
+ dataset_id = "fec"
+ table_id = "candidate_committee_2020"
+ description = "FEC table"
+ depends_on = [
+ google_bigquery_dataset.fec
+ ]
+}
+
+output "bigquery_table-fec_candidate_committee_2020-table_id" {
+ value = google_bigquery_table.fec_candidate_committee_2020.table_id
+}
+
+output "bigquery_table-fec_candidate_committee_2020-id" {
+ value = google_bigquery_table.fec_candidate_committee_2020.id
+}
diff --git a/datasets/fec/infra/committee_2016_pipeline.tf b/datasets/fec/infra/committee_2016_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" "fec_committee_2016" {
+ project = var.project_id
+ dataset_id = "fec"
+ table_id = "committee_2016"
+ description = "FEC table"
+ depends_on = [
+ google_bigquery_dataset.fec
+ ]
+}
+
+output "bigquery_table-fec_committee_2016-table_id" {
+ value = google_bigquery_table.fec_committee_2016.table_id
+}
+
+output "bigquery_table-fec_committee_2016-id" {
+ value = google_bigquery_table.fec_committee_2016.id
+}
diff --git a/datasets/fec/infra/committee_2018_pipeline.tf b/datasets/fec/infra/committee_2018_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" "fec_committee_2018" {
+ project = var.project_id
+ dataset_id = "fec"
+ table_id = "committee_2018"
+ description = "FEC table"
+ depends_on = [
+ google_bigquery_dataset.fec
+ ]
+}
+
+output "bigquery_table-fec_committee_2018-table_id" {
+ value = google_bigquery_table.fec_committee_2018.table_id
+}
+
+output "bigquery_table-fec_committee_2018-id" {
+ value = google_bigquery_table.fec_committee_2018.id
+}
diff --git a/datasets/fec/infra/committee_2020_pipeline.tf b/datasets/fec/infra/committee_2020_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" "fec_committee_2020" {
+ project = var.project_id
+ dataset_id = "fec"
+ table_id = "committee_2020"
+ description = "FEC table"
+ depends_on = [
+ google_bigquery_dataset.fec
+ ]
+}
+
+output "bigquery_table-fec_committee_2020-table_id" {
+ value = google_bigquery_table.fec_committee_2020.table_id
+}
+
+output "bigquery_table-fec_committee_2020-id" {
+ value = google_bigquery_table.fec_committee_2020.id
+}
diff --git a/datasets/fec/infra/committee_contributions_2016_pipeline.tf b/datasets/fec/infra/committee_contributions_2016_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" "fec_committee_contributions_2016" {
+ project = var.project_id
+ dataset_id = "fec"
+ table_id = "committee_contributions_2016"
+ description = "FEC table"
+ depends_on = [
+ google_bigquery_dataset.fec
+ ]
+}
+
+output "bigquery_table-fec_committee_contributions_2016-table_id" {
+ value = google_bigquery_table.fec_committee_contributions_2016.table_id
+}
+
+output "bigquery_table-fec_committee_contributions_2016-id" {
+ value = google_bigquery_table.fec_committee_contributions_2016.id
+}
diff --git a/datasets/fec/infra/committee_contributions_2018_pipeline.tf b/datasets/fec/infra/committee_contributions_2018_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" "fec_committee_contributions_2018" {
+ project = var.project_id
+ dataset_id = "fec"
+ table_id = "committee_contributions_2018"
+ description = "FEC table"
+ depends_on = [
+ google_bigquery_dataset.fec
+ ]
+}
+
+output "bigquery_table-fec_committee_contributions_2018-table_id" {
+ value = google_bigquery_table.fec_committee_contributions_2018.table_id
+}
+
+output "bigquery_table-fec_committee_contributions_2018-id" {
+ value = google_bigquery_table.fec_committee_contributions_2018.id
+}