Profile fields from BigQuery

Highlighted
One Star

Profile fields from BigQuery

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!

Highlighted
Moderator

Re: Profile fields from BigQuery

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

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Highlighted
Employee

Re: Profile fields from BigQuery

Hi

yes, you can create JDBC type connection

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

 

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

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Introduction to Talend Open Studio for Data Quality

Find out about Talend Open Studio for Data Quality

Watch Now

Best Practices for Using Context Variables with Talend – Part 3

Read about some useful Context Variable ideas

Blog