search

MicrosoftDocs / azure-docs

Open source documentation of Microsoft Azure
https://docs.microsoft.com/azure
Creative Commons Attribution 4.0 International
10.01k stars 21k forks source link

Issue using BigQuery Connector #122264

Closed Sambgt closed 6 days ago

Sambgt commented 1 week ago

Error: ErrorCode=UserErrorInvalidPluginType,'Type=Microsoft.DataTransfer.Common.Shared.PluginNotRegisteredException,Message=Invalid type 'GoogleBigQueryV2' is provided in 'linkedServices'. Please correct the type in payload and retry.,Source=Microsoft.DataTransfer.ClientLibrary,'

Description: There is no error connecting with bigquery and retreiving the data from bigquery ( we can preview the data in the dataset, no issue at all ), but copy activity is failing and showing above error.

### Tasks

Document Details

⚠ Do not edit this section. It is required for learn.microsoft.com ➟ GitHub issue linking.

TPavanBalaji commented 1 week ago

@Sambgt It would be great if you could add a link to the documentation you are following for these steps? This would help us redirect the issue to the appropriate team. Thanks!

Sambgt commented 1 week ago

Thank you for response, I am attaching the whole process I followed. part-01 part-02

TPavanBalaji commented 1 week ago

@Sambgt It would be great if you could add a link to the documentation you are following. This would help us redirect the issue to the appropriate team. Thanks!

Sambgt commented 1 week ago

Sorry, got little confused. Here is the link https://learn.microsoft.com/en-us/azure/data-factory/connector-google-bigquery?tabs=data-factory

Sambgt commented 1 week ago

This is how configured my linked service and dataset for Google BigQuery. Linked_Service_and_Dataset_config

TPavanBalaji commented 1 week ago

@Sambgt Thanks for your feedback! We will investigate and update as appropriate.

Naveenommi-MSFT commented 1 week ago

Hello @Sambgt Thank you for your feedback! We tried to reproduce this issue, we couldn't get this, to gain a better understanding of your issue, I'd recommend working closer with our support team via an Azure support request. Or you can leverage our Q&A forum by posting your issue there so our community, and MVPs can further assist you in troubleshooting this issue or finding potential workarounds. Teams Q&A forum for technical questions about the configuration and administration of Microsoft Teams on Windows. Microsoft Teams Community forum

Naveenommi-MSFT commented 6 days ago

@Sambgt We are going to close this thread, if there are any further questions regarding the documentation, please tag me in your reply and we will be happy to continue the conversation.

Please-close

PLjjjj commented 6 days ago

Hi together, I get the same error like @Sambgt. @Naveenommi-MSFT: It is important to use a SQL Server table as destination in the copy activity. grafik The pipeline is configured exactly as @Sambgt described.

If a parquet-file is used as destination in the copy activity, no error occurs. grafik

Thank you and best regards