Skip to content

Instantly share code, notes, and snippets.

@mattray
Created February 22, 2024 00:38
Show Gist options
  • Save mattray/8a0b9d7cb238bbedaa8cffc8fbf9d33b to your computer and use it in GitHub Desktop.
Save mattray/8a0b9d7cb238bbedaa8cffc8fbf9d33b to your computer and use it in GitHub Desktop.
Example GCP cloud-integration.json
{
"gcp": {
"bigQuery": [
{
"projectID": "guestbook-234502",
"dataset": "detailedbilling",
"table": "gcp_billing_export_resource_v1_1231CB_A6B51B_456771",
"authorizer": {
"authorizerType": "GCPServiceAccountKey",
"key": {
"type": "service_account",
"project_id": "guestbook-234502",
"private_key_id": "a8aa32490fb2a38a81f4aaa4bcd0d14ee8a2ab63",
"private_key": "-----BEGIN PRIVATE KEY-----\nMIIEvgIBABEDGgkqhkiG9w0AAQEFAASCBKbzn1SkAgEAAoIBAQC+znF0x8hr0wri\nhpgdGs4LZAYISxdiZjnrdP/UJvTwFBf/TFzIKlIQVIUgCYTO+uEdar8K4pNLJZFT\naqxYYnk3sje744KTmqquQ7K7RKOYMcwc1fRgLBeRyfavp3FEYHGVdwwB52enVe/3\nneYizb6TKFEDchd6DDVkZ7frro/n+dgD+xOEFRofftnB0P1MbNMOBkfQzdV7P0iy\nJOdWggCmciSbSok8GTmQKh+p2XR7nVH13Eh/Xzv7Q2A3qUiafXmepo6vBZeUnK2A\nUr3jyTGCiFkoD338uxb6EVxclx+Eifs8/BgJcpVEThFD+r9Ks7zuce/GRxdX6Jdp\n+t8UrslnAgMBAAECggEAD9+EuL5WAgJQiX/A78rnETOE/POiQmFWuCvHjJKhFcfW\nJzrnDQ/YO9uMJ5ojHkTorVXQBsvKjRnW+SWKqN+oTeXZlRvcJQNc55piKAoRwfuC\ni3ORHN8OJuaySvKXDaUoTdLVgOMLUHRpviO4nXSYQg28j5jSMykI2A1403Z2KkoN\nrs8DMf5q4YiZ52OyulWA+znKwS2xIz8GkXuGadJ1GG60/AoDE1mvKItWce69AlLZ\nSGKsrP2di//f43r+DwGXb4zjZJmCLf4M3jwjDiaaV182grnOowQ/AMAZT214LSTa\n/qxLvs5npqtQkpOhZ4fjldF2aRddCip4FdQqLYoxIQKBgQDxvXqPEHd/tLG7qDCl\nF144uOvq0OfnVMrO/OdJz4JAO5hw3MXHO72ZHAJXtTZhHE7DCkXX8Pr7v6IVscOn\nMAjdeJEKUYTW/jhlZB8XS5UIdtu9EdZDFbTONVgzjEtqajBRTp4CAL8ZQCMuJnaj\nEwagNYh4evp9v0G55uqYtQvNAwKBgQDKD9A/SUe6WVuzOvu2xgtBFU0rdpR+unND\nZ2Ju4m1NVdLfwNHOVWe3o46RDV+ymDkqSL+14LzIg9/XOzJghhTk+D2SkdzXhmqI\nhPVr4xEDw6p0jamrvoH2pNX8sq1kl8Qm2q37+BJoDovWoVtanQnv8NVbwJqiKgxe\n6Bl6UeiKzQKBgQDbAs55tPJ+2cc4e71upMgxXaAngpLHq7N+afRlk8Guzg9jGTF6\nOm6gu5aHvd6BhrL402LJrELHOCvxubbHzqYJeIT3MznFylZvzZC5ezmPjJeyKOnU\np2LCe+Pn99APnhseXrqal/CKQOhelGxhfAhBt55ngQtWR6OVeFbMeSIy3wKBgCnY\nRIQWpOgOgVMIsAAV21bLFoQdtnrYGe6nhlb4RTJyx4zW3ZwhS61YDbo0TtEpfQ0o\nq6r6s53C0aQ8+h3LJqCUWAv2cQmhKIbFIh4JlAh3iOFCRRTwCvINCNOgHRBr7Y8u\nUkGQCh/Kg2MbX1PQmbI66bRqmptiodU1s7EFLWcxAoGBAI6KpBvS7kRhpPiY32jd\n39YeHKXX3vszj3zk7Z3bFEpy4FPnCS4wBrMdy+JQERlFL4G7OA8zJHgkK+Q0yslZ\nThwoUxnhNMK/Z0fKat+F5YumwQp+89dm6AmCoBpxu26rnMIRk+vkZGUKQkAXukmR\nmCQcGdo7Xfgh8113626NWhi4\n-----END PRIVATE KEY-----\n",
"client_email": "compute-viewer-opencost-matt@guestbook-234502.iam.gserviceaccount.com",
"client_id": "126891116425724639485",
"auth_uri": "https://accounts.google.com/o/oauth2/auth",
"token_uri": "https://oauth2.googleapis.com/token",
"auth_provider_x509_cert_url": "https://www.googleapis.com/oauth2/v1/certs",
"client_x509_cert_url": "https://www.googleapis.com/robot/v1/metadata/x509/compute-viewer-opencost-matt%40guestbook-234502.iam.gserviceaccount.com"
}
}
}
]
},
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment