anyone can help me about this pls?
On Thu, 31 Dec 2020 at 10.25 tkg_cangkul <[email protected]> wrote:
> Hi,
>
> I'm trying to compare about Postgresql table with BigQuery table using
> jdbc.
> i was able to connect to postgres, but i've a problem when connect to
> BigQuery.
>
> this is my connector config :
>
> {
> "name": "source",
> "baseline": true,
> "connector": {
> "type": "jdbc",
> "config": {
> "tablename": "dataset_name.table_name",
> "where": "DATE(partition_time) = '2020-01-29'",
> "url":"jdbc:bigquery://
> https://www.googleapis.com/bigquery/v2:443;ProjectId=data-engineering;OAuthType=0;OAuthServiceAcctEmail=t...@data-engineering.iam.gserviceaccount.com;OAuthPvtKeyPath=/home/griffin/json/key.json;";,
>
>
> "driver": "com.simba.googlebigquery.jdbc42.Driver"
> }
> }
> },
>
> I've a warning message if the data source is null.
>
> is there anyone can help me to solve this?
>
