Setting Up a GBQ Data Source Connection in Databox

1.  Navigate to Data Manager on the left-hand toolbar. 



2.  Click New Data Source.



3.  Select GBQ.



4.  Click Add new Connection. 



5.  Configure the connection details as follows:

• • Data Source Name: Enter "APP GBQ MIGRATION"
  • Credentials file contents: Paste your JSON key code
  • Timezone: Select "America/Chicago"
  • 

JSON Key:

 {
"type": "service_account",
"project_id": "data-base-big-query-test",
"private_key_id": "6cc4e7d2e1188e5d56cc48d98ceef3911ebbd64a",
"private_key": "-----BEGIN PRIVATE KEY-----\nMIIEvAIBADANBgkqhkiG9w0BAQEFAASCBKYwggSiAgEAAoIBAQDBrerxbzmsFNm6\nVv9TQ2nW0u4V7s/7gw40ySr9coYAcm38HxOmI6iZI5HYjoWiqdH3Fk5vU9ilA0mW\n9IvDQiRARzLIcWSYIWz8KFTXQkFdopmvOTRsAOC92DKiQo6V3fKsulLf3h91mb/g\nogKCVHOkkABUxgJ9BnYoI8vwvYEN//hC7485D8jgJamBgbb979SfcUtceIUwVgbD\nXai6UsTsCB/oQ32W44buLsiGcVIzJsUQ3Z6JSAUDCiCZ+4WBA3/dn/0bxc4bb44d\nNJ61xBvZvzKkL5MHBvRxsBe++Eo2Ql5oZ1jy/aeFEEAZP1TtWAIuG++AgPYc8JQl\nKxXTJPMbAgMBAAECggEAGoanL2L0NfkdwCjVy6xnd1h96uYWzn6ADcMMOW3GeZLd\nNRMiiKDIoL9fjxZ8qgRyhnyjyG6Q349y3uhmU0X18LxvnEaffZB9EeS03fiBOwGf\n5SuYs5QZM8HDtDfDueCN3JH2SMVDb21b0Lhk+emhdFqT7l23jd0P22aFB4HvhiBE\nJGqmdb8DMNK57TSFTNY3oLDI0G5VIrniLK6epORODj4kG8wzeja4WypWGStVI2Bo\nzGgGE80EzvKQH4iQGdiVYyYWcgQnu58INuu/O9ZzsboUnrefPiNoj/OnVjPhoPRh\nQ3MtL/eiE6ZArohJ8E2ExWTEUXxvLBITzPjf2lGOOQKBgQDi/Sg4ZpjG3gbhv0C6\nIE6x2DCg8AcNGD1OFN+VKSp3pijtEZ3WIySYuAKzsGB+dod+2EbZctWCTEIZ4vMC\nXClAM0GIY1RfE+sWGi8EXA+1gk+OjvAE3s4xT4iHg2KtAoymXJbkGGDKAuuEEhWR\nbgvN4uOcfrV0ky5co0QaCoKJ0wKBgQDabug7b3WshWyFgaQWs0oa3cqd9pmD93o7\nnqoYFlezVr2/Zr7ZbtM3azmu4zrrjPeISl9Df3WAj8Xjz96omXNj9OZexnyhb+k/\nbqM4UQPF264mLsSGtxfwNctsOWuM5IQl3dD67V2eXnfzC+JbenvMi9yh8i1fFG9f\nJT8pScycmQKBgF0EML8sC98yjM9leDjNlHH8jbDlq34KONUOaLDPNb/iL1M2rN9b\nd1u9zB2mYWRxXgT0y9O/4w6KAWxqO/rzmVPdrTUevyxXFTbxc+LtduKCi+d3W5Qj\nWYuLc/9UL9OF/+0MdCj0dHVTzP9KCdyWo++y0mMG6YTj61O68+VX+TZRAoGALBeJ\nHz4/haSlJEnoAoEMa2Hr3XkCwgW5kcFUWmpgJ55RzQoDakaZsi0dxrStlxCsgsFo\ne2qGIH5lFrhGHMhk539u5SCx1bCOZ7SAlASee1j9zU1RdFQPK/jf6CerExSprC8b\nWRuC803kbpYuigKubLqqvbHyAKhSVuVg24e/GrkCgYBEeUFSfss76vylZndiBjAP\nvWnatHApTyfkDClPpqd2h6COTRj3U8yCt41wG8ODpGIMgPPn4r5Qb6JEAwZgXyoW\nFwJjgWKmWyHsg+OKW4Dff0lU6OaE6FDKTvKdSw25cy+6DN2Yo93Yp1JlnXTqT24B\n6r7H0wRe49ygIjLG01WptQ==\n-----END PRIVATE KEY-----\n",
"client_email": "databox-gbq@data-base-big-query-test.iam.gserviceaccount.com",
"client_id": "115870225913904397677",
"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/databox-gbq%40data-base-big-query-test.iam.gserviceaccount.com",
"universe_domain": "googleapis.com"
} 

KBA Author: Chad Alfred Salvador