Bigquery

  • 69Views
  • Last Post 26 July 2022
0
votes
Growth Team posted this 18 July 2022

Hello,

I am trying to add BigQuery as a connector. When I add all the info required, and i test it it works, but when I check on the Query part of Skyvia there are no tables present for a Bigquery connector.

Moreover, when I try to connect Bigquery to Amazon RDS I cannot find Bigquery info at all, the target side is empty so I cannot connect them. 

Thank you in advance for any tips/help

Order By: Standard | Newest | Votes
0
votes
Yevheniia Bilotserkovska posted this 19 July 2022

Hello.

Thank you for contacting us.

Could you please check and make sure that tables you need are exist in BigQuery? If they were created in BigQuery but did not reflected in Skyvia, could you please refresh the Query and check if they appeared.

Regarding connection between BigQuery to Amazon RDS we would ask you to to specify type of the package you are trying to create (Import, Sync, etc.)

We are looking forward to hearing from you.

Best regards,

Yevheniia Bilotserkovska

0
votes
Growth Team posted this 22 July 2022

Hello!

I cannot create anything in Bigquery because when I try to push data from Hubspot or Amazon RDS to Bigquery, via Import, I cannot find any information in the ADD TASKS --> Target Definition to continue the process. For the source definition part I can click on the tables I want, but in the target definition I have nothing. This is why i assume it is a Bigquery problem Im having. 

All the best,

0
votes
Yevheniia Bilotserkovska posted this 25 July 2022

 Hello.

Thank you for your reply.

We will investigate the issue and return with feedback ASAP.

Best regards,

Yevheniia Bilotserkovska

0
votes
Yevheniia Bilotserkovska posted this 26 July 2022

Hello.

Thank you for your waiting.

You can not find any data in Target Definition because there is no data stored in BigQuery.

You need to create tables manually so that they will be available in Target Definition for future Import. After creation please refresh the Query.

Please try and let us know the result.

We are looking forward to hearing from you.

Best regards,

Yevheniia Bilotserkovska

Close