Stay organized with collections
Save and categorize content based on your preferences.
Load data using a third-party application
Some third-party applications and services provide
connectors that can ingest data into BigQuery.
For example, Informatica
lets you load data from external sources into BigQuery's storage.
Load data using Informatica
To load data using Informatica Data Loader, follow these steps:
In the Google Cloud console, go to the BigQuery page.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-29 UTC."],[[["\u003cp\u003eThird-party applications like Informatica and Fivetran can be used to load data into BigQuery from external sources.\u003c/p\u003e\n"],["\u003cp\u003eLoading data with Informatica involves navigating to the BigQuery page in the Google Cloud console, selecting Informatica Data Loader, and then logging into your Informatica account.\u003c/p\u003e\n"],["\u003cp\u003eLoading data with Fivetran follows a similar process, requiring you to choose Fivetran Data Pipelines, and then log into your Fivetran account.\u003c/p\u003e\n"],["\u003cp\u003eThe process of both informatice and Fivetran will require you to follow the corresponding login pages instructions to complete loading data into BigQuery.\u003c/p\u003e\n"]]],[],null,["# Load data using a third-party application\n=========================================\n\nSome third-party applications and services provide\nconnectors that can ingest data into BigQuery.\nFor example, [Informatica](/bigquery/docs/bigquery-ready-partners#informatica)\nlets you load data from external sources into BigQuery's storage.\n\nLoad data using Informatica\n---------------------------\n\nTo load data using Informatica Data Loader, follow these steps:\n\n1. In the Google Cloud console, go to the **BigQuery** page.\n\n [Go to BigQuery](https://console.cloud.google.com/bigquery)\n2. In the **Explorer** pane, click add\n **Add**.\n\n The **Add data** dialog opens.\n3. Click a data source, for example, **Amazon S3** or **Google Cloud AlloyDB**.\n\n4. Click the **Informatica Data Loader** solution card.\n\n5. If you agree to the terms in the **You're leaving Google** dialog, click\n **Confirm**.\n\n6. On the Informatica login page, sign in to your Informatica account.\n\n7. To load data into BigQuery, follow the steps in\n your Informatica account.\n\nLoad data using Fivetran\n------------------------\n\nTo load data using Fivetran Data Pipelines, follow these steps:\n\n1. In the Google Cloud console, go to the **BigQuery** page.\n\n [Go to BigQuery](https://console.cloud.google.com/bigquery)\n2. In the **Explorer** pane, click add\n **Add**.\n\n The **Add data** dialog opens.\n3. Click a data source, for example, **Amazon S3** or **Google Cloud AlloyDB**.\n\n4. Click the **Fivetran Data Pipelines** solution card.\n\n5. If you agree to the terms in the **You're leaving Google** dialog, click\n **Confirm**.\n\n6. On the Fivetran login page, sign in to your Fivetran account.\n\n7. To load data into BigQuery, follow the steps in\n your Fivetran account.\n\nWhat's next\n-----------\n\n- Learn how to [work with BigQuery connections](/bigquery/docs/working-with-connections).\n- Learn about [Informatica](/bigquery/docs/bigquery-ready-partners#informatica)."]]
