{"id":7859,"date":"2022-07-28T03:36:24","date_gmt":"2022-07-28T10:36:24","guid":{"rendered":"https:\/\/en.pingcap.com\/?p=7859"},"modified":"2025-06-30T04:45:09","modified_gmt":"2025-06-30T11:45:09","slug":"using-airbyte-to-migrate-data-from-tidb-cloud-to-snowflake","status":"publish","type":"post","link":"https:\/\/www.pingcap.com\/ko\/blog\/using-airbyte-to-migrate-data-from-tidb-cloud-to-snowflake\/","title":{"rendered":"Using Airbyte to Migrate Data from TiDB Cloud to Snowflake"},"content":{"rendered":"\n

TiDB Cloud<\/strong> is a fully-managed Database-as-a-Service (DBaaS) that brings TiDB, an open source Hybrid Transactional and Analytical Processing (HTAP) database, to your cloud. <\/p>\n\n\n\n

Airbyte<\/strong> is an open-source data integration engine that helps you consolidate your data in data warehouses, data lakes, and databases. <\/p>\n\n\n\n

Snowflake<\/strong> provides Software-as-a-Service (SaaS) service with a single and global platform for data warehousing with seamless data collaboration.<\/p>\n\n\n\n

Airbyte can help you connect TiDB Cloud with Snowflake, migrate data from TiDB Cloud, the source, to Snowflake, the destination, and leverage Snowflake’s strong analytical capability to respond to your multi-dimensional analytical queries. (The source data can come from either TiDB Cloud or a self-deployed TiDB cluster.) Airbyte can also synchronize data from TiDB Cloud to Snowflake periodically and give you a macro-progressive data view. <\/p>\n\n\n\n

In this tutorial, we will walk you through how to use Airbyte to connect TiDB Cloud with Snowflake, and how to make data migration from the former to the latter.<\/p>\n\n\n\n

<\/span>Get started with TiDB Cloud Dev Tier<\/span><\/h2>\n\n\n\n
    \n
  1. Sign up<\/a> for a TiDB Cloud account free of charge and log in to it. If you already have a TiDB Cloud account, you can also log in<\/a> to your account directly.<\/li>\n\n\n\n
  2. On the Active Clusters<\/strong> page, click Create Cluster<\/strong>. Then, in the Developer Tier<\/strong> box, select 1 year Free Trial<\/strong>.<\/li>\n<\/ol>\n\n\n\n
    \"\"<\/figure>\n\n\n\n

    Note<\/strong>: You can also select the paid TiDB\u00a0Dedicated Tier<\/strong>\u00a0to get better performance.\u00a0<\/p>\n\n\n\n

      \n
    1. Set up your cluster name, cloud provider (only AWS is available for the Dev Tier), and region. (A nearby region is recommended.) Then, click Create<\/strong> to create your cluster.<\/li>\n<\/ol>\n\n\n\n

      Note<\/strong>: It usually takes 1 to 3 minutes to create your TiDB Cloud cluster.<\/p>\n\n\n\n

        \n
      1. After you create a cluster, you will be directed to the Active Clusters page. Click the cluster name you just created and go to the cluster control panel. <\/li>\n<\/ol>\n\n\n\n
        \"\"<\/figure>\n\n\n\n
          \n
        1. Click Connect <\/strong>to create a traffic filter. <\/li>\n<\/ol>\n\n\n\n
          \"\"<\/figure>\n\n\n\n
            \n
          1. On the pop-up window, set 0.0.0.0\/0 as the IP Address to allow access from any other IP address. <\/li>\n<\/ol>\n\n\n\n
            \"\"<\/figure>\n\n\n\n

            <\/span>Import sample data to TiDB Cloud<\/span><\/h2>\n\n\n\n

            After you create a TiDB Cloud cluster, you can migrate data<\/a> to TiDB Cloud. Here, we use Capital Bikeshare\u2019s system dataset<\/a> as the sample data to walk you through how to import data to TiDB Cloud.<\/p>\n\n\n\n

              \n
            1. Click\u00a0Import<\/strong>\u00a0and you will be directed to the\u00a0Data Import Task<\/strong>\u00a0page.<\/li>\n<\/ol>\n\n\n\n
              \"\"<\/figure>\n\n\n\n
              \"\"<\/figure>\n\n\n\n
                \n
              1. Fill the following parameters in the fields on the\u00a0Data Import Task<\/strong>\u00a0page.\n