Task Export for Big Query endpoint

[MermaidMe]

Hello team,

Looking for an option to export the task with Google Big Query as one of the endpoints. I see the BQ is being recognized as one of the unknown endpoint type.

AEM Version:6.5

OS: Windows

Thanks in advance,

Maneesha Thekkutt

[Ola_Mayer · Accepted solution]

Since GBQ is a DW and not a transnational database like SQL Server, you cannot use  Replicate to capture changes.

You can connect to GBQ using ODBC driver to run periodic offloads.

[MermaidMe]

Hi Ola,

thanks much for the response. But in here the GBQ is to go as a target endpoint. The option to export task is shown as inactive.

Thank you,

Maneesha.

[Ola_Mayer]

In this case the only thing I can think is maybe you don't have license to BQ target?

[MermaidMe]

Hi Ola,

We do hold a licnese for BQ. We also have tasks which are designed to replicate to GBQ.

Thank You,

Maneesha Thekkutt

[Ola_Mayer]

Hello Maneesha,

I suggest you contact support to figure out the issue you are facing.

Regards,

Ola

[mic_lau]

Hi @MermaidMe ,
we recently had the same issue and solved it by upgrading Replicate node to version 6.6.406

I see it's an old question but maybe it can still be useful!

Michele