topic Profile fields from BigQuery in Data Quality

Profile fields from BigQuery

Anonymous — Sat, 16 Nov 2024 04:32:58 GMT

Hi, I am trying to use Talend to assess my data's quality in BigQuery. Currently, I am using the tBigQuerySQLRow component to access my BigQuery data.

When I am in Profiling view (wanting to set-up a Column Analysis job), it seems like I must connect to databases via the Metadata Connection drop-down. However, BigQuery is not an option in that drop-down.

How can I run standard profiling jobs on BigQuery data?

Thank you!

Re: Profile fields from BigQuery

Anonymous — Tue, 01 Oct 2019 03:05:14 GMT

Hello,

Here exists a work item jira issue:https://jira.talendforge.org/browse/TDQ-16218.

This issue is fixed in V 7.2.1. Let us know if it is possible to create JDBC type connection for BigQuery with JDBC Driver and then test profiling.

Best regards

Sabrina

Re: Profile fields from BigQuery

msjian — Wed, 08 Jan 2020 07:56:03 GMT

yes, you can create JDBC type connection

more info can refer to https://jira.talendforge.org/browse/TDQ-15039

Regards
Jian
----------------------------------------------------------
Talend | Data Quality