"No items found" on BigQuery import

  • 105Views
  • Last Post 13 April 2021
0
votes
Tomas Chejanovich posted this 31 March 2021

I've created a connection with BigQuery to retrieve Firebase events. On the query builder I can query everything succesfully, but when trying to create the import package there are no columns on the chosen table.

Please help.

 

Order By: Standard | Newest | Votes
0
votes
Tomas Chejanovich posted this 01 April 2021

Any updates? Please help

0
votes
Sabina Bashuk posted this 01 April 2021

Hi Tomas,

Sorry for the delayed reply.

Are these tables available only for querying for you or for executing, too?

The issue may be caused by their availability only for reading in BigQuery.

Could you please check?

0
votes
Tomas Chejanovich posted this 01 April 2021

I see the same tables when querying them, along with the columns (querying works fine).

When setting up the package, I see the tables but not the columns (like shown on my previous picture).

 

Querying:

0
votes
Sabina Bashuk posted this 02 April 2021

Hi Tomas,

Judging from your orevious screenshot, you're showing the screen where the Tables should be chosen, not the columns.

Are you sure it is the right one?

0
votes
Tomas Chejanovich posted this 05 April 2021

No, this is the one to choose the tables:

0
votes
Sabina Bashuk posted this 05 April 2021

Hi Tomas,

Thank you for the screenshot. May I clarify once again what 2 sources you import data from\to? From Amazon Redshift to Google BigQuery?

0
votes
Tomas Chejanovich posted this 05 April 2021

From Google BigQuery to Amazon Redshift

0
votes
Tomas Chejanovich posted this 06 April 2021

Any updates?

0
votes
Sabina Bashuk posted this 13 April 2021

Hello Tomas,

Sorry for keeping you waiting. Please have a look at the screenshots:

      Here's the Source and Target:  

  Here's the table choice in BigQuery       Here's the table choice in Redshift       Here's mapping options    

    Are you sure you're performing Import and not Replication? Replication allows to choose the columns, indeed, but Skyvia does not support the Replication from databases - only from cloud sources.

Close