[DBeaver] Bigquery 연동

JaeIn Kim
Jul 31, 2020
  1. DBeaver 설치
  2. Edit Driver ‘Google Bigquery’에서 URL Template 변경
    as-is: jdbc:bigquery://{host}:{port};ProjectId={database};OAuthType=0;OAuthServiceAcctEmail={user};OAuthPvtKeyPath={server};
    to-be: jdbc:bigquery://https://www.googleapis.com/bigquery/v2:433;ProjectId=dmp-bigquery;OAuthType=0;OAuthServiceAcctEmail={~~}@dmp-bigquery.iam.gserviceaccount.com;OAuthPvtKeyPath=C:\JaeIn_Kim\임시\키파일.json;

3. Connection Setting에서 프로젝트 명, 서비스 어카운트, 키 패스를 등록함

Timeout 발생 시

아래 참조

마이크로초까지 나오게 해야 할 경우

아래 use native data/time format에 체크 표시할 것

sql문 제안하는 기능 해제할 경우 아래 참조

BigQuery와 DBeaver의 타임존이 맞지 않을 경우

아래 timezone 부분 변경하고 재실행

Sign up to discover human stories that deepen your understanding of the world.

Free

Distraction-free reading. No ads.

Organize your knowledge with lists and highlights.

Tell your story. Find your audience.

Membership

Read member-only stories

Support writers you read most

Earn money for your writing

Listen to audio narrations

Read offline with the Medium app

JaeIn Kim
JaeIn Kim

No responses yet

Write a response