Forum Discussion
Pipeline doesn't allow BigQuery connection
Hi, I added Bigquery connection to my Fabric tenant and everything is fine when I am using Dataflow Gen2, when trying to import the data, but when I am using Data pipeline with the same connection, when I press on that connection it just loads for a few seconds and then goes back like nothing happened.
I tried adding multiple BigQuery connections, but all the ones I added are working with a dataflow but are not working with the copy assistant in data pipeline.
Can you please help here?
3 Replies
Hi Anonymous
The following properties must be observed to configure Google BigQuery in a pipeline:
Datastore type: select "External".
Connection: Select a Google BigQuery connection from the list of connections. If no connection exists, select New to create a new Google BigQuery connection.
Use Query: Choose from Table or Google SQL.
You can follow the documentation to try again. You can view the link below for more details:
Google BigQuery connector overview - Microsoft Fabric | Microsoft Learn
Set up your Google BigQuery connection - Microsoft Fabric | Microsoft Learn
Configure Google BigQuery in a copy activity - Microsoft Fabric | Microsoft Learn
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.