1. Home
  2. Docs
  3. Basics
  4. Bigquery

Bigquery

Page Content

dbauth.yml

  • type: bigquery
  • host: Google-Cloud Project
  • db: Dataset
  • bigQueryCredentials: Encrypted JSON key file (see below how to get it)

Leave port, user and pass empty.

1
2
3
4
5
6
7
type: "bigquery"
host: "bigquery-lesql"
port: ""
user: ""
pass: ""
db: "zzzexamplebigquery"
bigQueryCredentials: JJdLrc5BQa89Wl2j530BQK27JaBh2sM80pDrTOEtF1ZDYYUmJ4LOI6JlAQ1wgcK965vqkkRV6jqE/e71jWX/tabdj/0IKuh5TigLCfGiAL+TJ/wYJ9K5+HPr0kfQbSZG5qmK6/Zspz+Vy2kqpCGb+/A+6+3zh8G8P7GlF3FQNGXSXP0KMiBNTx2OY5g5ASGNNO9RACHKs8b8n855D65Vlvz0SsgXSwsDUWGyXditwfTibyFQQ95nfnl1P9SLB87Oc4XlN1gllAuTAytJb30RIks4MhwJ9fLtVsX2+8romrsuqQEbPavZayRA/k23ZaT/6UgvR7MoRbLLCunstcsAuN2QbdepwiD/tbtCjXv9m+QAQPsLJ0BgyfIXix4VaiCqO5ZoOBiROYNtriu+IXEQ2WVc1IzUh/0PRuBpzxpOtDBsgvdQa9CYZzMby1FJXmoMl+MbKxd8hX/TTeNWJ4M+O4fhUZ5ogZ0c+HWLJiaxs/cLUAJNVHJ09Ebzitr5jNYwIin8GvMRO4yJny039UqlvpEiewUlbcXREJMqAglC1MS3/78MiVJu6WCtIAtteNPaOGE4bCGg7g/ejy95U34VVYXnTovb8n8wV3QnUwceEd3M0pREzMSKM7WXuspkKjKEYR+lACr28ulH6RZlFxANsbZ2V2JyJMWg+kB+bwilt0JeQ7mhB3uIThNDvY+ynLb1O4BfGBwgHDVk6wMcXf3xLime6c9it4O4icVj1rRTnEvkq5ZJ7Y36S3shzcuDHOSij82gv8d/eejy/4agujGnj2UN/vr9u8LHKpkiySfg6uR1Yjpi+xcFNP2uBx4CnJe2PQ27+hoGEOozYtxKuMa7Oe3ieugy6VTsme33y67lCxqgCQ8FBnhUHichwL74uYob4O34Jei1zfWnPb3FCKGr8uSr589Smusz6jLgF178aEhRTlOBMr8H7Bw530RxL/uF2+2SFSs3X4HC+ogOq0Rdl6XUV/r/7oUDMmsI4LUZN119TgiSbZhhLzAjJ91Y+TzKacnhm6a8TQtP9qpwN3gBcD+x/iKAsIw/jTob5yXLZGFx8U83CWpegKEjWw0WX7wAgRS1suvlhdTc9UmnuSiq7QbglRyR8pjVCRuT00v9P9O6kGuhFbaYFfl+3HqY6FNMWAdVLLckLeQoB5mq6YOPyLxUM+nvuje8u7mq5IxQK4WoB+m3X+PpEBlWVlQ1baZq7Dkk4nvO//BIhz+bchBbxQgQpitExIgmFmVI+4loRfhoerhJYw1Al+PS3vg6SFYSlQinuBTcu1N+mPxa8D4qx4AEXUWY95yJSAykks9gPX8i1O++OLgDIvGerQuvBaiN8qz6OXM3xeE8e3cynnWCKJOvZFqAMadAH5wwFK5RcnQvAfurLivkFBVW1+37QFMxrhMQB9lFMF8HmGy1pRIbOvsPxgv6lbHpwCvmZ86poXTF2HmyCkkvuafIagegdliO5ZnQYghEnZBHHWkREZkenlpdbmVFIrPPkQw8mZCYy6anfQt3RwAS7E98pQ/GrtwXKjzhJn8mybIp8GfL3p5yY+b9bvebcQ04KTpDgUJM0kNYIsFmJaAGVvw2OTh0R40y8AxXXVnhyRlAePFa4GcTTumckrmG/0B0U7fN79zn1S2Kx3B7OBbaw3pCqGwbj9dD3kmB5baRM+PMqbhxfG0CfMXl0q2fIapwUVb6bmeoBlpZXCm2S4zPxg0xed6rmlXiAIGcJJVsAME6V2DWD7kZQnubquQishnCtFMT1NlURg5Y0A5TCp8aJ5TBOQyQH2YXiK31sugUxom406mJi2+7uE2eLA1PJq/G12g1eVuWdBLLWxSPF9sZCkl/sTI4SifqP2bH/sq1Q9moiijOCkf1pvdSzaQyTu4wWy/AWjDaNH61cOPdlhlUWHcb8nZPZKJPbOu/xZtEAXekro71RSabzlWB1pEb+AAEB4xuVF8Ir33ttmUhnWwiEgL1RQkIFGv3KBUUJU3KlxHCLMRxgEB37HGpMf2zaQIuhiBZXR6xQ5wE28dSxb9UHjbwpODgxUGIdUho0plB9UPscKMNd9zl9n6UaMlM29fQP2qo9n0MCylAhVR+sO0ODH6hIwLTw+/NkqGuP+qREsUqmFyZuImYwXWHZa/Qn/h8MwS/2ZTWLZOacBsxl6/Y7JHENxnKmEaLU2P0d33V+VKrUg9jET2E+rdwLuC3jjJH/ifvI98FOkd8uhCJ6REhgNgVxgGYuya2RHre+N+GzT/BBQg1Ty0/yeu6Dtwk1JlNtJymzgObeoaYM4dq12HD8cmX2USHCSglD859pfHcEJCggSU0I7ZgvN+9YxNFqiByDRh9zo3jZYxJwwDEkQ2m9/DXjTkQFBKsciWTIwx/ryUihTC4As7sGhJ8IBEprz7QiXELMiUy3VKsnaasXku1LluIExu62usCE5uv0HrI7PjiAy8/IAF7BREIWiln0hAma7XACFtJoCzg3yAjbegGxqJici8Fw5CTcWe1Zr2LWvrXHY+g/xY2N3xrHGHhJH52JuvePsqKzhxq5992fnbGUlWFgtmOP3ZDe2RzUOgQXyrqTU7PhP8xX9PHii0WfVNn0lQ8/eDYdsjECpw0F7LL2XjiMKV3aqnaDjJQEIWSeeYkWvCHMbKR3JSuuNowQceUTdAY7g7qnEhM2SmMaLutn4BwnaTzCgB1ZrH/G2gyuksQqXiO2CYmlb64jA9T7Vo43uu+mZxoZ+JroEMaaibI8+3g/EwnGYGEhklfVXz3ApsjOwvHMk5XhMLKaHWLyyt+Gsznuz7rVImtV9EAeIdnMAg0pw4XPIB1VS9Tbl+lJehwgYOsZf9R1Hk1o3m8/7JR7/2kenJ5ZRbUjJ5pr8h+d6u+ubAmrNCRrudsuq/CtTUGVi9K2NBZ+zEKVnyDcewKu4gxYRwPOJ0g7Iet/3z2nhSrVec3Ekn6RYrHFzQdM8l3ATwJ7GSItcjz83LKOD1AzT9tYxmisgNx1MjgIBb8S2MxmG0FSxMw5TsBMEde9AkY+eFqRHcXJ8bxbA1bVcnx1QkD

In Google Cloud Console:

  • Go to IAM & Admin
  • Go to Service Accounts
  • CREATE SERVICE ACCOUNT
  • After you created an account with enough rights, click on the three dots behind the Service Account and click Create key
  • Choose JSON
  • Save this file to your local system. It will be named something like bigquery-lesql-ea3842a7ceb8.json
  • Now run lesql encrypt - < bigquery-lesql-ea3842a7ceb8.json
  • Add the encrypted string to bigQueryCredentials in dbauth.yml