![Google BigQuery](https://cdn.sanity.io/images/97bpcflt/production/6652fee37af0b9e3474718889c503a1ecf3f8917-226x200.png?bg=0fff&w=80&fit=crop&dpr=2&fm=webp&h=71)
Integrate PipeDream with Google BigQuery
Don't go through the pain of direct integration. RudderStack’s PipeDream integration makes it easy to send data from PipeDream to Google BigQuery and all of your other cloud tools.Google BigQuery is an industry-leading fully-managed cloud data warehouse that allows you to store and analyze petabytes of data in no time and leverage Google’s machine learning features. RudderStack lets you add Google BigQuery as a destination where you can send your customer event data and params from the data source of your choice., without the pain of detailed setup or custom pipeline development. Setting up a pipeline to BigQuery cloud storage requires a significant amount of detailed engineering work, dealing with googleapis, config files, commands like createdataset and create table and more. With RudderStack, you simply need to set up a service account for authentication in Google Cloud Platform, ensure your IAM profile has the correct permissions and then specify the required details (like projectid). From there, RudderStack will take care of sending data directly to GCP (google-cloud/bigquery), including metadata, without you having to manage a cloud client library, set up a new git workflow in your command line or spend engineering cycles trying to optimize loads. In fact, with RudderStack’s streaming integrations you can even send data to Google in real-time. If you have multiple databases, RudderStack also allows you to send data to relational databases like PostgreSQL, SQL server, mySQL and more.
Pipedream lets you automate pre-built actions that connect APIs. If a pre-built source is not available for your use case, you can build your own. PipeDream supports open source triggers and actions for hundreds of integrations. It allows you to connect applications, APIs, and event sources in order to run workflows.