fix(gcp-resources): Add project_id and name as PKs of gcp_run_services (#6549)

erezrokah · pull[bot] · commit 952995679c5b · 2023-08-10T13:23:10.000Z
#### Summary

`gcp_run_services` was missing PKs. This should fix it

&lt;!--
diff --git a/plugins/source/gcp/docs/tables/gcp_run_services.md b/plugins/source/gcp/docs/tables/gcp_run_services.md
@@ -2,7 +2,7 @@
 
 https://cloud.google.com/run/docs/reference/rest/v2/projects.locations.services#Service
 
-The primary key for this table is **_cq_id**.
+The composite primary key for this table is (**project_id**, **name**).
 
 ## Relations
 
@@ -14,10 +14,10 @@ This table depends on [gcp_run_locations](gcp_run_locations.md).
 | ------------- | ------------- |
 |_cq_source_name|String|
 |_cq_sync_time|Timestamp|
-|_cq_id (PK)|UUID|
+|_cq_id|UUID|
 |_cq_parent_id|UUID|
-|project_id|String|
-|name|String|
+|project_id (PK)|String|
+|name (PK)|String|
 |description|String|
 |uid|String|
 |generation|Int|
diff --git a/plugins/source/gcp/resources/services/run/services.go b/plugins/source/gcp/resources/services/run/services.go
@@ -19,6 +19,17 @@ func Services() *schema.Table {
 				Name:     "project_id",
 				Type:     schema.TypeString,
 				Resolver: client.ResolveProject,
+				CreationOptions: schema.ColumnCreationOptions{
+					PrimaryKey: true,
+				},
+			},
+			{
+				Name:     "name",
+				Type:     schema.TypeString,
+				Resolver: schema.PathResolver("Name"),
+				CreationOptions: schema.ColumnCreationOptions{
+					PrimaryKey: true,
+				},
 			},
 		},
 	}
