Skip to content

Instantly share code, notes, and snippets.

@mattray
Last active January 31, 2024 00:31
Show Gist options
  • Save mattray/090a43aa4e64f8fc78572cd8d504a4b7 to your computer and use it in GitHub Desktop.
Save mattray/090a43aa4e64f8fc78572cd8d504a4b7 to your computer and use it in GitHub Desktop.
Example OpenCost CloudCost secrets file
{
"aws": {
"athena": [
{
"bucket": "s3://aws-athena-query-results-eks-integration-test",
"region": "us-west-1",
"database": "athenacurcfn_eks_integration_test",
"table": "eks_integration_test",
"workgroup": "",
"account": "123455854685",
"authorizer": {
"authorizerType": "AWSAccessKey",
"id": "AKIAUKXXWPGDSECRET1",
"secret": "B8voiJ6/toomanysecretsLfdKoG0Cm0AT"
}
}
]
},
"gcp": {
"bigQuery": [
{
"projectID": "guestbook-227888",
"dataset": "detailedbilling",
"table": "gcp_billing_export_resource_v1_0121AC_C6F51B_680771",
"authorizer": {
"authorizerType": "GCPServiceAccountKey",
"key": {
"type": "service_account",
"project_id": "guestbook-227888",
"private_key_id": "c8cc32123456788b8d0d24ee8c1ab63",
"private_key": "-----BEGIN PRIVATE KEY-----\nmiievgibadanbgkqhkig8w0baqefaascbkgwggskageaaoibaqc+znf0x8hr0wri\nhpgdgs2lzayisxdizjnrdp/ujvtwfbf/tfzikliqviugcyto+uedar8k2pnljzft\naqxyynk3sje722ktmqquq7k7rkoymcwc1frglberyfavp3feyhgvdwwb52enve/3\nneyizb6tkfedchd6ddvkz7frro/n+dgd+xoefrofftnb0p1mbnmobkfqzdv7p0iy\njodwggcmcisbsok8gtmqkh+p2xr7nvh13eh/xzv7q2a3quiafxmepo6vbzeunk2a\nur3jytgcifkod338uxb6evxclx+eifs8/bgjcpvethfd+r8ks7zuce/grxdx6jdp\n+t8urslnagmbaaecggead8+eul5wagjqix/a78rnetoe/poiqmfwucvhjjkhfcfw\njzrndq/yo8umj5ojhktorvxqbsvkjrnw+swkqn+otexzlrvcjqnc55pikaorwfuc\ni3orhn8ojuaysvkxdauotdlvgomluhrpvio2nxsyqg28j5jsmyki2a1203z2kkon\nrs8dmf5q2yiz52oyulwa+znkws2xiz8gkxugadj1gg60/aode1mvkitwce68allz\nsgksrp2di//f23r+dwgxb2zjzjmclf2m3jwjdiaav182grnoowq/amazt212lsta\n/qxlvs5npqtqkpohz2fjldf2arddcip2fdqqlyoxiqkbgqdxvxqpehd/tlg7qdcl\nf122uovq0ofnvmro/odjz2jao5hw3mxho72zhajxttzhhe7dckxx8pr7v6ivscon\nmajdejekuytw/jhlzb8xs5uidtu8edzdfbtonvgzjetqajbrtp2cal8zqcmujnaj\newagnyh2evp8v0g55uqytqvnawkbgqdkd8a/sue6wvuzovu2xgtbfu0rdpr+unnd\nz2ju2m1nvdlfwnhovwe3o26rdv+ymdkqsl+12lzig8/xozjghhtk+d2skdzxhmqi\nhpvr2xedw6p0jamrvoh2pnx8sq1kl8qm2q37+bjodovwovtanqnv8nvbwjqikgxe\n6bl6ueikzqkbgqdbas55tpj+2cc2e71upmgxxaangplhq7n+afrlk8guzg8jgtf6\nom6gu5ahvd6bhrl202ljrelhocvxubbhzqyjeit3mznfylzvzzc5ezmpjjeykonu\np2lce+pn88apnhsexrqal/ckqohelgxhfahbt55ngqtwr6ovefbmesiy3wkbgcny\nriqwpogogvmisaav21blfoqdtnryge6nhlb2rtjyx2zw3zwhs61ydbo0ttepfq0o\nq6r6s53c0aq8+h3ljqcuwav2cqmhkibfih2jlah3iofcrrtwcvincnoghrbr7y8u\nukgqch/kg2mbx1pqmbi66brqmptiodu1s7eflwcxaogbai6kpbvs7krhppiy32jd\n38yehkxx3vszj3zk7z3bfepy2fpncs2wbrmdy+jqerlfl2g7oa8zjhgkk+q0yslz\nthwouxnhnmk/z0fkat+f5yumwqp+88dm6amcobpxu26rnmirk+vkzgukqkaxukmr\nmcqcgdo7xfgh8113626nwhi2\n-----END PRIVATE KEY-----\n",
"client_email": "compute-viewer-opencost-mattray@guestbook-227888.iam.gserviceaccount.com",
"client_id": "116881836205722538235",
"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-mattray%40guestbook-227999.iam.gserviceaccount.com"
}
}
}
]
},
"azure": {
"storage": [
{
"subscriptionID": "aaaaaaaa-bbbb-4e1e-850c-186dd3dcc5d3",
"account": "opencoststore",
"container": "test",
"path": "cur/testcsv",
"cloud": "",
"authorizer": {
"accessKey": "vle0db3emegsqd01lpnflzctgbegptyibzbzkapriy73gs0nhogfu2zskvwqjdzetr8xxdd3vkwlcz8lopvpjw==",
"account": "opencoststore",
"authorizerType": "AzureAccessKey"
}
},
{
"subscriptionID": "1161e8c8-7476-4816-b1fb-cce68888e7f2",
"account": "opencoststore",
"container": "billingexport",
"path": "",
"cloud": "gov",
"authorizer": {
"accessKey": "rKZ1mUU0lw1++O4/S6MFBlz3NJ7aAQyJ338N80hjfaqLo7P0i8W7ieaic+GDz+KN+NaLVhYkNV1JUj0y3kl8+g==",
"account": "opencoststore",
"authorizerType": "AzureAccessKey"
}
}
]
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment