[ Nifi ] Firebase Bigquery Nifi 연결

파이어베이스 BigQuery 설정

 https://spiralmoon.tistory.com/entry/Firebase-Firebase%EC%97%90-BigQuery-%EC%97%B0%EA%B2%B0%ED%95%98%EA%B8%B0

서비스계정만들기 

https://cloud.google.com/docs/authentication/getting-started?hl=ko

Bigquery jdbc driver jar 다운로드

https://dbschema.com/jdbc-driver/GoogleBigQuery.html

• Required File(s): googlebigqueryjdbc42.jar
• Java Driver Class: com.simba.googlebigquery.jdbc42.Driver
• URL: jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId={DB};OAuthType=1;
• Website: Google Big Query

심바 JDBC PDF

file:///C:/Program%20Files/Simba%20ODBC%20Driver%20for%20Google%20BigQuery/Simba%20ODBC%20Driver%20for%20Google%20BigQuery%20Install%20and%20Configuration%20Guide.pdf

각 나이파이 lib디렉토리에

google-http-client-jackson2-1.28.0.jar

google-api-client-1.28.0.jar

GoogleBigQueryJDBC42.jar 

추가

구글클라우드콘솔

https://console.cloud.google.com/bigquery?project=zeliter-1337

Bigquery에 연결하는 7가지 방법

https://hevodata.com/learn/bigquery-etl-tools/#b7