Qlik Replicate and Google Big Query Issue Identified

[Jamie_Gregory]

Hello Qlik Users!

An issue has been identified for Qlik Replicate users when using Google Big Query as the Target Endpoint. The load may fail if the dataset is outside the US and the region is not set for the INFORMATION_SCHEMA.

The current workaround is as follows:

1. Open the Big Query endpoint definition
2. Click on the Advanced tab Internal Parameters
3. In the search box for the parameter name type (case sensitive):

$info.query_syntax.check_schema_exist

For its vale enter - select count(*) from region-eu.INFORMATION_SCHEMA.SCHEMATA where SCHEMA_NAME = '${TABLE_OWNER}'​

          4. Save and restart the task.

Note: The above script will force Qlik Replicate to query with the syntax of ‘region-eu’. Please use the relevant region value.

For more information, please see Unqualified INFORMATION_SCHEMA queries views will default to returning metadata from outside the US.

If you have any questions, please let us know in the comments below. If you found this information useful, give the post a ‘like’! Make sure you’re subscribed to the Qlik Support Updates Blog to get the latest information from Qlik Support.

Thank you for choosing Qlik!

Kind regards,

Qlik Global Support

[YEL]

Hi @Jamie_Gregory 

Thank you for your post, but its not working  for me. 

Thank you for your help. 

[Sonja_Bauernfeind]

Hello @YEL 

Please post about your issue in detail (including setup information, Qlik Replicate versions, and any possible errors and mitigation steps you have tried) in our Qlik Replicate forum.

All the best,
Sonja