<\/span>TiDB Cloud and Zapier integration solves business problems<\/span><\/h2>\n\n\n\nZapier<\/a> is a powerful no-code platform that lets you connect data sources and automate workflows without any coding experience. TiDB Cloud is the fully-managed service of \ud2f0DB<\/a>, an advanced, open-source, distributed SQL database that provides real-time data access with low latency and horizontal scalability. TiDB Cloud also has Hybrid Transactional and Analytical Processing (HTAP) capabilities, making it ideal for businesses with hybrid workloads. <\/p>\n\n\n\nWith these two powerful tools integrated, companies in different industries can automate repetitive and also gain real-time insights into business operations. The results? Better performance and higher efficiency. <\/p>\n\n\n\n
This integration can solve a lot of real world business problems. For example, in the retail industry, this integration helps optimize retail business operations, allowing retailers to focus on business growth. In the healthcare industry, clinics and hospitals can improve their patient management and billing processes, resulting in more revenue and improved patient satisfaction. <\/p>\n\n\n\n
<\/span>TiDB Cloud and Zapier integration in action<\/span><\/h2>\n\n\n\nWe\u2019ll now examine how to use Zapier to connect Google Sheets with TiDB Cloud. We will also share how Chat2Query, the AI powered SQL generator in TiDB Cloud, can help you automatically generate SQL scripts to aggregate data from TiDB Cloud. Finally, we’ll explore how you can leverage analytics and business intelligence tools like Grafana to visualize and gain insights from your aggregated data. Let’s dive in!<\/p>\n\n\n\n
Prerequisites<\/h3>\n\n\n\n
Before you begin, make sure you have the following accounts.<\/p>\n\n\n\n
\n- Zapier<\/a><\/li>\n\n\n\n
- TiDB Cloud.<\/a> After you create the account, create a free Serverless Tier cluster. For details, see TiDB Cloud Quick Start<\/a>.<\/li>\n\n\n\n
- Grafana<\/a><\/li>\n<\/ul>\n\n\n\n
Set up TiDB Cloud<\/h3>\n\n\n\nCreate API Keys<\/h4>\n\n\n\n
To create API Keys, do the following: <\/p>\n\n\n\n
<\/figure><\/p>\n\n\n\n\n- On the TiDB Cloud page, click the Organization <\/strong>icon. <\/li>\n\n\n\n
- On the scroll-down menu, select the Organization Settings option<\/strong>.
![\"\"](\"https:\/\/static.pingcap.com\/files\/2023\/04\/13050346\/image-2-1024x313.png\")
<\/figure><\/li>\n\n\n\n- Click Create API Key<\/strong> and enter a description, for example New Zapier Key<\/strong>. <\/li>\n\n\n\n
- Click Done<\/strong>. <\/li>\n<\/ol>\n\n\n\n
TiDB Cloud automatically creates the public and private keys. Copy and save them for later use.<\/p>\n\n\n\n
Create a table<\/h4>\n\n\n\n
Use the Chat2Query editor<\/a> to execute a SQL script to create a `nces_avg_cost` table. The sample dataset will be stored in this table later. <\/p>\n\n\n\nCREATE TABLE test.nces_avg_cost\n\n(\n\n id bigint AUTO_RANDOM primary key,\n\n Year int,\n\n State varchar(25) NOT NULL,\n\n Type varchar(25) NOT NULL,\n\n Length varchar(10) NOT NULL,\n\n Expense varchar(50) NOT NULL,\n\n Amount double NOT NULL \n\n)<\/code><\/pre>\n\n\n\nFor this example, we\u2019ll use the National Center for Education Statistics (NCES) data as a sample dataset. This dataset contains college tuition fee data for different states in the US.<\/p>\n\n\n\n![\"\"](\"https:\/\/static.pingcap.com\/files\/2023\/04\/13050443\/image-3-1024x323.png\")
<\/figure>\n\n\n\nSet up Google Sheets<\/h3>\n\n\n\n
Next, sign into your Google Docs account and create a new spreadsheet with the columns as shown below. Alternatively, you can copy this Google spreadsheet<\/a>. You can also add a row of data to the spreadsheet. This will help us when we test our Zap trigger later.
<\/p>\n\n\n\n![\"\"](\"https:\/\/static.pingcap.com\/files\/2023\/04\/13050454\/image-4-1024x172.png\")
<\/figure>\n\n\n\nNote<\/strong>: The sheet contains only columns. The column names match the table columns that we created earlier.<\/p>\n\n\n\nCreate a Zap: connecting Google Sheets with TiDB Cloud<\/h3>\n\n\n\n
You\u2019ve created a Google Sheet and a TiDB Cloud instance. Now, we’ll use Zapier to connect them. Zapier lets you automate workflows by creating “Zaps” that consist of triggers and actions. In this case, we\u2019ll create a Zap that triggers an action in TiDB Cloud whenever a new row is added to our Google Sheet. This will ensure that the TiDB Cloud database has the latest data from the Google Sheet, without requiring any manual effort.<\/p>\n\n\n\n
Create a new Zap<\/h4>\n\n\n\n
To create a new Zap:<\/p>\n\n\n\n
\n- Log in to your Zapier account and navigate to the dashboard. (As an alternative, you can access this Integration by logging into your TiDB Cloud account and navigating to the \ud1b5\ud569<\/strong> page.)<\/li>\n\n\n\n
- On the Make a Zap <\/strong>page,<\/strong> select Google Sheets<\/strong> to connect with TiDB Cloud<\/strong>.
![\"\"](\"https:\/\/static.pingcap.com\/files\/2023\/04\/13052404\/image-5-1024x401.png\")
<\/figure><\/li>\n\n\n\n- Create the trigger and action. Select New Spreadsheet Row<\/strong> to Create Row<\/strong>. This tells Zapier to create a new row in the TiDB Cloud database whenever a new row is added to your Google Sheets. <\/li>\n\n\n\n
- Click Try it<\/strong>.<\/li>\n<\/ol>\n\n\n\n
Configure the trigger<\/h4>\n\n\n\n\n- Click the Edit <\/strong>icon and name the Zap NCES Data Integration<\/strong>.
![\"\"](\"https:\/\/static.pingcap.com\/files\/2023\/04\/13052450\/image-6-1024x455.png\")
<\/figure><\/li>\n\n\n\n- Configure the trigger. Leave Choose app & event <\/strong>with their default values. <\/li>\n\n\n\n
- Choose an account. Click Connect a new account. <\/strong>Specify the Google account that has your Google Sheets.<\/li>\n\n\n\n
- Set up a trigger. Choose the Spreadsheet<\/strong> \uadf8\ub9ac\uace0 Worksheet <\/strong>that has column headers.<\/li>\n\n\n\n
- Test the trigger. Select the row from the drop-down list and click Continue<\/strong>.<\/li>\n<\/ol>\n\n\n\n
Configure the action<\/h4>\n\n\n\n
After you configure the Zap, you can configure the action.<\/p>\n\n\n\n
\n- Leave Choose app & event<\/strong> with their default values.<\/li>\n\n\n\n
- Choose an account. Click Connect a new account<\/strong>.<\/li>\n\n\n\n
- Enter the Public Key <\/strong>\uadf8\ub9ac\uace0 Private Key<\/strong> information that you obtained from TiDB Cloud earlier and then click Yes, Continue<\/strong>.
![\"\"](\"https:\/\/static.pingcap.com\/files\/2023\/04\/13052610\/image-7-1024x577.png\")
<\/figure><\/li>\n\n\n\n- In the Set up action <\/strong>section, enter TiDB Cloud Connection information<\/a>.
<\/figure><\/li>\n\n\n\n- Map the Google Sheet columns with the columns from the`nces_avg_cost` table.
Note<\/strong>: Leave the Id<\/strong> column blank. It\u2019s configured to be an auto-generated column in the table.<\/p>![\"\"](\"https:\/\/static.pingcap.com\/files\/2023\/04\/13053123\/image-10-1024x474.png\")
<\/figure><\/li>\n\n\n\n- Once the mapping is done, click Continue<\/strong>.<\/li>\n\n\n\n
- Test it to ensure that it’s working properly. This will create a single row in TiDB Cloud. <\/li>\n\n\n\n
- If everything looks good, click Publish Zap<\/strong>.
![\"\"](\"https:\/\/static.pingcap.com\/files\/2023\/04\/13053216\/image-11.png\")
<\/figure><\/li>\n<\/ol>\n\n\n\nWith your Zap published and running, you can test it by adding new records to your Google Sheets. You can find free sample datasets on Kaggle<\/a> or use our sample data sheet<\/a>.<\/p>\n\n\n\nTo explore and review the data generated by our TiDB Cloud Zap, we\u2019ll use datasets from 2020 and 2021 for five US states.<\/p>\n\n\n\n
Note:<\/strong> Zapier\u2019s free tier only runs Zaps every 15 minutes, so you may need to wait up to 15 minutes for the new rows to be added to TiDB Cloud. If you are on a Professional or Team Plan, the updates will be triggered instantly.<\/p>\n\n\n\n<\/span>Exploring and reviewing data<\/span><\/h2>\n\n\n\nNow that we have successfully integrated Google Sheets with TiDB Cloud, and data is automatically updated in the database, it’s time to explore and review that data. We’ll use TiDB’s AI-powered Chat2Query feature<\/a> to generate a SQL query that aggregates and summarizes the data. We will be looking at the year-on-year tuition fees in each state for a 4-year program. Then we’ll use a popular visualization tool, Grafana, to create a dashboard to display that data so it\u2019s easy to understand and analyze.<\/p>\n\n\n\nData exploration with Chat2Query<\/h3>\n\n\n\n
To access Chat2Query:<\/p>\n\n\n\n
\n- Navigate to the TiDB Cloud <\/strong>Clusters<\/strong><\/a> page and select the target cluster. <\/li>\n\n\n\n
- Open the query editor. In the left navigation panel, click Chat2Query<\/strong>. <\/li>\n\n\n\n
- Ask a question to generate a query. As an example, we can ask Chat2Query to generate a query that retrieves the tuition fees for each state for a four-year program.
![\"This](\"https:\/\/static.pingcap.com\/files\/2023\/04\/13184533\/chat2query-zapier.gif\")
<\/li>\n<\/ol>\n\n\n\nAfter Chat2Query generates the query, you can modify it as needed to ensure that the output matches your visualization requirements. <\/p>\n\n\n\n
SELECT Year, CONCAT(State, ' - ', Year) AS State, SUM(Amount) AS Tuition\n\nFROM test.nces_avg_cost\n\nWHERE Length like '%4%'\n\nGROUP BY Year,State\n\nORDER BY State, Year DESC<\/code><\/pre>\n\n\n\nData visualization<\/h3>\n\n\n\n
After you use Chat2Query to generate the SQL query and tweak it to fit your needs, you can use Grafana (or other MySQL-compatible visualization tool) to visualize the data. To connect Grafana to your TiDB cluster, follow the steps in How to connect Grafana to a remote MySQL database<\/a>.<\/p>\n\n\n\nGrafana lets you create charts and dashboards that help you better understand your data. In our case, we\u2019ll create a bar chart that shows the year-over-year tuition fees for four-year programs in the five states we selected. As you can see from the chart, most states had a significant decrease in tuition between 2020 and 2021. A few others remained relatively stable. With this visualization, we can quickly gain insights and make data-driven decisions that impact our educational choices.<\/p>\n\n\n\n![\"\"](\"https:\/\/static.pingcap.com\/files\/2023\/04\/13060225\/image-12-1024x354.png\")
<\/figure>\n\n\n\n<\/span>Summary<\/span><\/h2>\n\n\n\nIntegrating TiDB Cloud and Zapier offers a powerful solution for businesses to manage their data and streamline their workflows. This integration also allows businesses to gain valuable insights from their data, make more informed decisions, and improve overall efficiency.<\/p>\n\n\n\n
We hope you find this blog useful. If you\u2019re interested in this integration, you are welcome to sign in to (or sign up for) your TiDB Cloud<\/a> \uadf8\ub9ac\uace0 Zapier<\/a> accounts and give them a try. If you want more deployment details for this integration, see our documentation<\/a>. If you have any questions, feel free to contact us through Twitter<\/a>, LinkedIn<\/a>, or our Slack Channel<\/a>.<\/p>","protected":false},"excerpt":{"rendered":"Learn how to connect multiple data-intensive applications with streamlined workflows and receive informed business insights in real time using TiDB Cloud and Zapier.\u00a0<\/p>","protected":false},"author":216,"featured_media":11483,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ub_ctt_via":"","footnotes":""},"categories":[13],"tags":[11,31],"class_list":["post-11471","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-product","tag-real-time-analytics","tag-tidb-cloud"],"acf":[],"featured_image_src":"https:\/\/static.pingcap.com\/files\/2023\/04\/13024432\/20230413-174356.jpeg","author_info":{"display_name":"Arun Vijayraghavan","author_link":"https:\/\/www.pingcap.com\/ko\/blog\/author\/arun-vijayraghavan\/"},"yoast_head":"\n
Streamline Data Workflows with TiDB Cloud and Zapier | TiDB<\/title>\n<meta name=\"description\" content=\"Learn how to connect multiple data-intensive applications and receive informed business insights in real time using TiDB Cloud and Zapier.\u00a0\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.pingcap.com\/ko\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Streamline Data Workflows with TiDB Cloud and Zapier | TiDB\" \/>\n<meta property=\"og:description\" content=\"Learn how to connect multiple data-intensive applications and receive informed business insights in real time using TiDB Cloud and Zapier.\u00a0\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pingcap.com\/ko\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/\" \/>\n<meta property=\"og:site_name\" content=\"TiDB\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/facebook.com\/pingcap2015\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-13T09:52:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-06-07T04:56:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/static.pingcap.com\/files\/2023\/04\/13024659\/zapier-social.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1600\" \/>\n\t<meta property=\"og:image:height\" content=\"800\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Arun Vijayraghavan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/static.pingcap.com\/files\/2023\/04\/13024659\/zapier-social.jpg\" \/>\n<meta name=\"twitter:creator\" content=\"@PingCAP\" \/>\n<meta name=\"twitter:site\" content=\"@PingCAP\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Arun Vijayraghavan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/\"},\"author\":{\"name\":\"Arun Vijayraghavan\",\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/person\/8a9e54493a2a21018fd222e0a32b1ffd\"},\"headline\":\"Streamline Data Workflows with TiDB Cloud and Zapier\",\"datePublished\":\"2023-04-13T09:52:51+00:00\",\"dateModified\":\"2024-06-07T04:56:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/\"},\"wordCount\":1429,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.pingcap.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/static.pingcap.com\/files\/2023\/04\/13024432\/20230413-174356.jpeg\",\"keywords\":[\"Real-time analytics\",\"TiDB Cloud\"],\"articleSection\":[\"Product\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/\",\"url\":\"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/\",\"name\":\"Streamline Data Workflows with TiDB Cloud and Zapier | TiDB\",\"isPartOf\":{\"@id\":\"https:\/\/www.pingcap.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/static.pingcap.com\/files\/2023\/04\/13024432\/20230413-174356.jpeg\",\"datePublished\":\"2023-04-13T09:52:51+00:00\",\"dateModified\":\"2024-06-07T04:56:44+00:00\",\"description\":\"Learn how to connect multiple data-intensive applications and receive informed business insights in real time using TiDB Cloud and Zapier.\u00a0\",\"breadcrumb\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/#primaryimage\",\"url\":\"https:\/\/static.pingcap.com\/files\/2023\/04\/13024432\/20230413-174356.jpeg\",\"contentUrl\":\"https:\/\/static.pingcap.com\/files\/2023\/04\/13024432\/20230413-174356.jpeg\",\"width\":1600,\"height\":534},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.pingcap.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Streamline Data Workflows with TiDB Cloud and Zapier\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.pingcap.com\/#website\",\"url\":\"https:\/\/www.pingcap.com\/\",\"name\":\"TiDB\",\"description\":\"TiDB | SQL at Scale\",\"publisher\":{\"@id\":\"https:\/\/www.pingcap.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.pingcap.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.pingcap.com\/#organization\",\"name\":\"PingCAP\",\"url\":\"https:\/\/www.pingcap.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png\",\"contentUrl\":\"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png\",\"width\":811,\"height\":232,\"caption\":\"PingCAP\"},\"image\":{\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/facebook.com\/pingcap2015\",\"https:\/\/x.com\/PingCAP\",\"https:\/\/linkedin.com\/company\/pingcap\",\"https:\/\/youtube.com\/channel\/UCuq4puT32DzHKT5rU1IZpIA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/person\/8a9e54493a2a21018fd222e0a32b1ffd\",\"name\":\"Arun Vijayraghavan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/static.pingcap.com\/files\/2022\/10\/17234942\/avatar.jpg\",\"contentUrl\":\"https:\/\/static.pingcap.com\/files\/2022\/10\/17234942\/avatar.jpg\",\"caption\":\"Arun Vijayraghavan\"},\"description\":\"TiDB Cloud Product Manager\",\"url\":\"https:\/\/www.pingcap.com\/ko\/blog\/author\/arun-vijayraghavan\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Streamline Data Workflows with TiDB Cloud and Zapier | TiDB","description":"Learn how to connect multiple data-intensive applications and receive informed business insights in real time using TiDB Cloud and Zapier.\u00a0","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.pingcap.com\/ko\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/","og_locale":"ko_KR","og_type":"article","og_title":"Streamline Data Workflows with TiDB Cloud and Zapier | TiDB","og_description":"Learn how to connect multiple data-intensive applications and receive informed business insights in real time using TiDB Cloud and Zapier.\u00a0","og_url":"https:\/\/www.pingcap.com\/ko\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/","og_site_name":"TiDB","article_publisher":"https:\/\/facebook.com\/pingcap2015","article_published_time":"2023-04-13T09:52:51+00:00","article_modified_time":"2024-06-07T04:56:44+00:00","og_image":[{"width":1600,"height":800,"url":"https:\/\/static.pingcap.com\/files\/2023\/04\/13024659\/zapier-social.jpg","type":"image\/jpeg"}],"author":"Arun Vijayraghavan","twitter_card":"summary_large_image","twitter_image":"https:\/\/static.pingcap.com\/files\/2023\/04\/13024659\/zapier-social.jpg","twitter_creator":"@PingCAP","twitter_site":"@PingCAP","twitter_misc":{"Written by":"Arun Vijayraghavan","Est. reading time":"8\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/#article","isPartOf":{"@id":"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/"},"author":{"name":"Arun Vijayraghavan","@id":"https:\/\/www.pingcap.com\/#\/schema\/person\/8a9e54493a2a21018fd222e0a32b1ffd"},"headline":"Streamline Data Workflows with TiDB Cloud and Zapier","datePublished":"2023-04-13T09:52:51+00:00","dateModified":"2024-06-07T04:56:44+00:00","mainEntityOfPage":{"@id":"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/"},"wordCount":1429,"commentCount":0,"publisher":{"@id":"https:\/\/www.pingcap.com\/#organization"},"image":{"@id":"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/#primaryimage"},"thumbnailUrl":"https:\/\/static.pingcap.com\/files\/2023\/04\/13024432\/20230413-174356.jpeg","keywords":["Real-time analytics","TiDB Cloud"],"articleSection":["Product"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/","url":"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/","name":"Streamline Data Workflows with TiDB Cloud and Zapier | TiDB","isPartOf":{"@id":"https:\/\/www.pingcap.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/#primaryimage"},"image":{"@id":"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/#primaryimage"},"thumbnailUrl":"https:\/\/static.pingcap.com\/files\/2023\/04\/13024432\/20230413-174356.jpeg","datePublished":"2023-04-13T09:52:51+00:00","dateModified":"2024-06-07T04:56:44+00:00","description":"Learn how to connect multiple data-intensive applications and receive informed business insights in real time using TiDB Cloud and Zapier.\u00a0","breadcrumb":{"@id":"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/#primaryimage","url":"https:\/\/static.pingcap.com\/files\/2023\/04\/13024432\/20230413-174356.jpeg","contentUrl":"https:\/\/static.pingcap.com\/files\/2023\/04\/13024432\/20230413-174356.jpeg","width":1600,"height":534},{"@type":"BreadcrumbList","@id":"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pingcap.com\/"},{"@type":"ListItem","position":2,"name":"Streamline Data Workflows with TiDB Cloud and Zapier"}]},{"@type":"WebSite","@id":"https:\/\/www.pingcap.com\/#website","url":"https:\/\/www.pingcap.com\/","name":"\ud2f0DB","description":"TiDB | SQL at Scale","publisher":{"@id":"https:\/\/www.pingcap.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.pingcap.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Organization","@id":"https:\/\/www.pingcap.com\/#organization","name":"PingCAP","url":"https:\/\/www.pingcap.com\/","logo":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/","url":"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png","contentUrl":"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png","width":811,"height":232,"caption":"PingCAP"},"image":{"@id":"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/facebook.com\/pingcap2015","https:\/\/x.com\/PingCAP","https:\/\/linkedin.com\/company\/pingcap","https:\/\/youtube.com\/channel\/UCuq4puT32DzHKT5rU1IZpIA"]},{"@type":"Person","@id":"https:\/\/www.pingcap.com\/#\/schema\/person\/8a9e54493a2a21018fd222e0a32b1ffd","name":"Arun Vijayraghavan","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.pingcap.com\/#\/schema\/person\/image\/","url":"https:\/\/static.pingcap.com\/files\/2022\/10\/17234942\/avatar.jpg","contentUrl":"https:\/\/static.pingcap.com\/files\/2022\/10\/17234942\/avatar.jpg","caption":"Arun Vijayraghavan"},"description":"TiDB Cloud Product Manager","url":"https:\/\/www.pingcap.com\/ko\/blog\/author\/arun-vijayraghavan\/"}]}},"grav_blocks":false,"card_markup":"<a class=\"card-resource bg-white\" href=\"https:\/\/www.pingcap.com\/ko\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/\"><div class=\"card-resource__image-container\"><img class=\"card-resource__image\" alt=\"20230413-174356\" src=\"https:\/\/static.pingcap.com\/files\/2023\/04\/13024432\/20230413-174356.jpeg\" loading=\"lazy\" width=1600 height=534 \/><\/div><div class=\"card-resource__content-container\"><div class=\"card-resource__content-head\"><div class=\"card-resource__category\">Product<\/div><\/div><h5 class=\"card-resource__title\">Streamline Data Workflows with TiDB Cloud and Zapier<\/h5><\/div><\/a>","_links":{"self":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/posts\/11471","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/users\/216"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/comments?post=11471"}],"version-history":[{"count":13,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/posts\/11471\/revisions"}],"predecessor-version":[{"id":17567,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/posts\/11471\/revisions\/17567"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/media\/11483"}],"wp:attachment":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/media?parent=11471"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/categories?post=11471"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/tags?post=11471"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
With these two powerful tools integrated, companies in different industries can automate repetitive and also gain real-time insights into business operations. The results? Better performance and higher efficiency. <\/p>\n\n\n\n
This integration can solve a lot of real world business problems. For example, in the retail industry, this integration helps optimize retail business operations, allowing retailers to focus on business growth. In the healthcare industry, clinics and hospitals can improve their patient management and billing processes, resulting in more revenue and improved patient satisfaction. <\/p>\n\n\n\n
<\/span>TiDB Cloud and Zapier integration in action<\/span><\/h2>\n\n\n\nWe\u2019ll now examine how to use Zapier to connect Google Sheets with TiDB Cloud. We will also share how Chat2Query, the AI powered SQL generator in TiDB Cloud, can help you automatically generate SQL scripts to aggregate data from TiDB Cloud. Finally, we’ll explore how you can leverage analytics and business intelligence tools like Grafana to visualize and gain insights from your aggregated data. Let’s dive in!<\/p>\n\n\n\n
Prerequisites<\/h3>\n\n\n\n
Before you begin, make sure you have the following accounts.<\/p>\n\n\n\n
\n- Zapier<\/a><\/li>\n\n\n\n
- TiDB Cloud.<\/a> After you create the account, create a free Serverless Tier cluster. For details, see TiDB Cloud Quick Start<\/a>.<\/li>\n\n\n\n
- Grafana<\/a><\/li>\n<\/ul>\n\n\n\n
Set up TiDB Cloud<\/h3>\n\n\n\nCreate API Keys<\/h4>\n\n\n\n
To create API Keys, do the following: <\/p>\n\n\n\n
<\/figure><\/p>\n\n\n\n\n- On the TiDB Cloud page, click the Organization <\/strong>icon. <\/li>\n\n\n\n
- On the scroll-down menu, select the Organization Settings option<\/strong>.
<\/figure><\/li>\n\n\n\n- Click Create API Key<\/strong> and enter a description, for example New Zapier Key<\/strong>. <\/li>\n\n\n\n
- Click Done<\/strong>. <\/li>\n<\/ol>\n\n\n\n
TiDB Cloud automatically creates the public and private keys. Copy and save them for later use.<\/p>\n\n\n\n
Create a table<\/h4>\n\n\n\n
Use the Chat2Query editor<\/a> to execute a SQL script to create a `nces_avg_cost` table. The sample dataset will be stored in this table later. <\/p>\n\n\n\nCREATE TABLE test.nces_avg_cost\n\n(\n\n id bigint AUTO_RANDOM primary key,\n\n Year int,\n\n State varchar(25) NOT NULL,\n\n Type varchar(25) NOT NULL,\n\n Length varchar(10) NOT NULL,\n\n Expense varchar(50) NOT NULL,\n\n Amount double NOT NULL \n\n)<\/code><\/pre>\n\n\n\nFor this example, we\u2019ll use the National Center for Education Statistics (NCES) data as a sample dataset. This dataset contains college tuition fee data for different states in the US.<\/p>\n\n\n\n<\/figure>\n\n\n\nSet up Google Sheets<\/h3>\n\n\n\n
Next, sign into your Google Docs account and create a new spreadsheet with the columns as shown below. Alternatively, you can copy this Google spreadsheet<\/a>. You can also add a row of data to the spreadsheet. This will help us when we test our Zap trigger later.
<\/p>\n\n\n\n<\/figure>\n\n\n\nNote<\/strong>: The sheet contains only columns. The column names match the table columns that we created earlier.<\/p>\n\n\n\nCreate a Zap: connecting Google Sheets with TiDB Cloud<\/h3>\n\n\n\n
You\u2019ve created a Google Sheet and a TiDB Cloud instance. Now, we’ll use Zapier to connect them. Zapier lets you automate workflows by creating “Zaps” that consist of triggers and actions. In this case, we\u2019ll create a Zap that triggers an action in TiDB Cloud whenever a new row is added to our Google Sheet. This will ensure that the TiDB Cloud database has the latest data from the Google Sheet, without requiring any manual effort.<\/p>\n\n\n\n
Create a new Zap<\/h4>\n\n\n\n
To create a new Zap:<\/p>\n\n\n\n
\n- Log in to your Zapier account and navigate to the dashboard. (As an alternative, you can access this Integration by logging into your TiDB Cloud account and navigating to the \ud1b5\ud569<\/strong> page.)<\/li>\n\n\n\n
- On the Make a Zap <\/strong>page,<\/strong> select Google Sheets<\/strong> to connect with TiDB Cloud<\/strong>.
<\/figure><\/li>\n\n\n\n- Create the trigger and action. Select New Spreadsheet Row<\/strong> to Create Row<\/strong>. This tells Zapier to create a new row in the TiDB Cloud database whenever a new row is added to your Google Sheets. <\/li>\n\n\n\n
- Click Try it<\/strong>.<\/li>\n<\/ol>\n\n\n\n
Configure the trigger<\/h4>\n\n\n\n\n- Click the Edit <\/strong>icon and name the Zap NCES Data Integration<\/strong>.
<\/figure><\/li>\n\n\n\n- Configure the trigger. Leave Choose app & event <\/strong>with their default values. <\/li>\n\n\n\n
- Choose an account. Click Connect a new account. <\/strong>Specify the Google account that has your Google Sheets.<\/li>\n\n\n\n
- Set up a trigger. Choose the Spreadsheet<\/strong> \uadf8\ub9ac\uace0 Worksheet <\/strong>that has column headers.<\/li>\n\n\n\n
- Test the trigger. Select the row from the drop-down list and click Continue<\/strong>.<\/li>\n<\/ol>\n\n\n\n
Configure the action<\/h4>\n\n\n\n
After you configure the Zap, you can configure the action.<\/p>\n\n\n\n
\n- Leave Choose app & event<\/strong> with their default values.<\/li>\n\n\n\n
- Choose an account. Click Connect a new account<\/strong>.<\/li>\n\n\n\n
- Enter the Public Key <\/strong>\uadf8\ub9ac\uace0 Private Key<\/strong> information that you obtained from TiDB Cloud earlier and then click Yes, Continue<\/strong>.
<\/figure><\/li>\n\n\n\n- In the Set up action <\/strong>section, enter TiDB Cloud Connection information<\/a>.
<\/figure><\/li>\n\n\n\n- Map the Google Sheet columns with the columns from the`nces_avg_cost` table.
Note<\/strong>: Leave the Id<\/strong> column blank. It\u2019s configured to be an auto-generated column in the table.<\/p><\/figure><\/li>\n\n\n\n- Once the mapping is done, click Continue<\/strong>.<\/li>\n\n\n\n
- Test it to ensure that it’s working properly. This will create a single row in TiDB Cloud. <\/li>\n\n\n\n
- If everything looks good, click Publish Zap<\/strong>.
<\/figure><\/li>\n<\/ol>\n\n\n\nWith your Zap published and running, you can test it by adding new records to your Google Sheets. You can find free sample datasets on Kaggle<\/a> or use our sample data sheet<\/a>.<\/p>\n\n\n\nTo explore and review the data generated by our TiDB Cloud Zap, we\u2019ll use datasets from 2020 and 2021 for five US states.<\/p>\n\n\n\n
Note:<\/strong> Zapier\u2019s free tier only runs Zaps every 15 minutes, so you may need to wait up to 15 minutes for the new rows to be added to TiDB Cloud. If you are on a Professional or Team Plan, the updates will be triggered instantly.<\/p>\n\n\n\n<\/span>Exploring and reviewing data<\/span><\/h2>\n\n\n\nNow that we have successfully integrated Google Sheets with TiDB Cloud, and data is automatically updated in the database, it’s time to explore and review that data. We’ll use TiDB’s AI-powered Chat2Query feature<\/a> to generate a SQL query that aggregates and summarizes the data. We will be looking at the year-on-year tuition fees in each state for a 4-year program. Then we’ll use a popular visualization tool, Grafana, to create a dashboard to display that data so it\u2019s easy to understand and analyze.<\/p>\n\n\n\nData exploration with Chat2Query<\/h3>\n\n\n\n
To access Chat2Query:<\/p>\n\n\n\n
\n- Navigate to the TiDB Cloud <\/strong>Clusters<\/strong><\/a> page and select the target cluster. <\/li>\n\n\n\n
- Open the query editor. In the left navigation panel, click Chat2Query<\/strong>. <\/li>\n\n\n\n
- Ask a question to generate a query. As an example, we can ask Chat2Query to generate a query that retrieves the tuition fees for each state for a four-year program.<\/li>\n<\/ol>\n\n\n\n
After Chat2Query generates the query, you can modify it as needed to ensure that the output matches your visualization requirements. <\/p>\n\n\n\n
SELECT Year, CONCAT(State, ' - ', Year) AS State, SUM(Amount) AS Tuition\n\nFROM test.nces_avg_cost\n\nWHERE Length like '%4%'\n\nGROUP BY Year,State\n\nORDER BY State, Year DESC<\/code><\/pre>\n\n\n\nData visualization<\/h3>\n\n\n\n
After you use Chat2Query to generate the SQL query and tweak it to fit your needs, you can use Grafana (or other MySQL-compatible visualization tool) to visualize the data. To connect Grafana to your TiDB cluster, follow the steps in How to connect Grafana to a remote MySQL database<\/a>.<\/p>\n\n\n\nGrafana lets you create charts and dashboards that help you better understand your data. In our case, we\u2019ll create a bar chart that shows the year-over-year tuition fees for four-year programs in the five states we selected. As you can see from the chart, most states had a significant decrease in tuition between 2020 and 2021. A few others remained relatively stable. With this visualization, we can quickly gain insights and make data-driven decisions that impact our educational choices.<\/p>\n\n\n\n<\/figure>\n\n\n\n<\/span>Summary<\/span><\/h2>\n\n\n\nIntegrating TiDB Cloud and Zapier offers a powerful solution for businesses to manage their data and streamline their workflows. This integration also allows businesses to gain valuable insights from their data, make more informed decisions, and improve overall efficiency.<\/p>\n\n\n\n
We hope you find this blog useful. If you\u2019re interested in this integration, you are welcome to sign in to (or sign up for) your TiDB Cloud<\/a> \uadf8\ub9ac\uace0 Zapier<\/a> accounts and give them a try. If you want more deployment details for this integration, see our documentation<\/a>. If you have any questions, feel free to contact us through Twitter<\/a>, LinkedIn<\/a>, or our Slack Channel<\/a>.<\/p>","protected":false},"excerpt":{"rendered":"Learn how to connect multiple data-intensive applications with streamlined workflows and receive informed business insights in real time using TiDB Cloud and Zapier.\u00a0<\/p>","protected":false},"author":216,"featured_media":11483,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ub_ctt_via":"","footnotes":""},"categories":[13],"tags":[11,31],"class_list":["post-11471","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-product","tag-real-time-analytics","tag-tidb-cloud"],"acf":[],"featured_image_src":"https:\/\/static.pingcap.com\/files\/2023\/04\/13024432\/20230413-174356.jpeg","author_info":{"display_name":"Arun Vijayraghavan","author_link":"https:\/\/www.pingcap.com\/ko\/blog\/author\/arun-vijayraghavan\/"},"yoast_head":"\n
Streamline Data Workflows with TiDB Cloud and Zapier | TiDB<\/title>\n<meta name=\"description\" content=\"Learn how to connect multiple data-intensive applications and receive informed business insights in real time using TiDB Cloud and Zapier.\u00a0\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.pingcap.com\/ko\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Streamline Data Workflows with TiDB Cloud and Zapier | TiDB\" \/>\n<meta property=\"og:description\" content=\"Learn how to connect multiple data-intensive applications and receive informed business insights in real time using TiDB Cloud and Zapier.\u00a0\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pingcap.com\/ko\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/\" \/>\n<meta property=\"og:site_name\" content=\"TiDB\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/facebook.com\/pingcap2015\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-13T09:52:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-06-07T04:56:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/static.pingcap.com\/files\/2023\/04\/13024659\/zapier-social.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1600\" \/>\n\t<meta property=\"og:image:height\" content=\"800\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Arun Vijayraghavan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/static.pingcap.com\/files\/2023\/04\/13024659\/zapier-social.jpg\" \/>\n<meta name=\"twitter:creator\" content=\"@PingCAP\" \/>\n<meta name=\"twitter:site\" content=\"@PingCAP\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Arun Vijayraghavan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/\"},\"author\":{\"name\":\"Arun Vijayraghavan\",\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/person\/8a9e54493a2a21018fd222e0a32b1ffd\"},\"headline\":\"Streamline Data Workflows with TiDB Cloud and Zapier\",\"datePublished\":\"2023-04-13T09:52:51+00:00\",\"dateModified\":\"2024-06-07T04:56:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/\"},\"wordCount\":1429,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.pingcap.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/static.pingcap.com\/files\/2023\/04\/13024432\/20230413-174356.jpeg\",\"keywords\":[\"Real-time analytics\",\"TiDB Cloud\"],\"articleSection\":[\"Product\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/\",\"url\":\"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/\",\"name\":\"Streamline Data Workflows with TiDB Cloud and Zapier | TiDB\",\"isPartOf\":{\"@id\":\"https:\/\/www.pingcap.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/static.pingcap.com\/files\/2023\/04\/13024432\/20230413-174356.jpeg\",\"datePublished\":\"2023-04-13T09:52:51+00:00\",\"dateModified\":\"2024-06-07T04:56:44+00:00\",\"description\":\"Learn how to connect multiple data-intensive applications and receive informed business insights in real time using TiDB Cloud and Zapier.\u00a0\",\"breadcrumb\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/#primaryimage\",\"url\":\"https:\/\/static.pingcap.com\/files\/2023\/04\/13024432\/20230413-174356.jpeg\",\"contentUrl\":\"https:\/\/static.pingcap.com\/files\/2023\/04\/13024432\/20230413-174356.jpeg\",\"width\":1600,\"height\":534},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.pingcap.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Streamline Data Workflows with TiDB Cloud and Zapier\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.pingcap.com\/#website\",\"url\":\"https:\/\/www.pingcap.com\/\",\"name\":\"TiDB\",\"description\":\"TiDB | SQL at Scale\",\"publisher\":{\"@id\":\"https:\/\/www.pingcap.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.pingcap.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.pingcap.com\/#organization\",\"name\":\"PingCAP\",\"url\":\"https:\/\/www.pingcap.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png\",\"contentUrl\":\"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png\",\"width\":811,\"height\":232,\"caption\":\"PingCAP\"},\"image\":{\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/facebook.com\/pingcap2015\",\"https:\/\/x.com\/PingCAP\",\"https:\/\/linkedin.com\/company\/pingcap\",\"https:\/\/youtube.com\/channel\/UCuq4puT32DzHKT5rU1IZpIA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/person\/8a9e54493a2a21018fd222e0a32b1ffd\",\"name\":\"Arun Vijayraghavan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/static.pingcap.com\/files\/2022\/10\/17234942\/avatar.jpg\",\"contentUrl\":\"https:\/\/static.pingcap.com\/files\/2022\/10\/17234942\/avatar.jpg\",\"caption\":\"Arun Vijayraghavan\"},\"description\":\"TiDB Cloud Product Manager\",\"url\":\"https:\/\/www.pingcap.com\/ko\/blog\/author\/arun-vijayraghavan\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Streamline Data Workflows with TiDB Cloud and Zapier | TiDB","description":"Learn how to connect multiple data-intensive applications and receive informed business insights in real time using TiDB Cloud and Zapier.\u00a0","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.pingcap.com\/ko\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/","og_locale":"ko_KR","og_type":"article","og_title":"Streamline Data Workflows with TiDB Cloud and Zapier | TiDB","og_description":"Learn how to connect multiple data-intensive applications and receive informed business insights in real time using TiDB Cloud and Zapier.\u00a0","og_url":"https:\/\/www.pingcap.com\/ko\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/","og_site_name":"TiDB","article_publisher":"https:\/\/facebook.com\/pingcap2015","article_published_time":"2023-04-13T09:52:51+00:00","article_modified_time":"2024-06-07T04:56:44+00:00","og_image":[{"width":1600,"height":800,"url":"https:\/\/static.pingcap.com\/files\/2023\/04\/13024659\/zapier-social.jpg","type":"image\/jpeg"}],"author":"Arun Vijayraghavan","twitter_card":"summary_large_image","twitter_image":"https:\/\/static.pingcap.com\/files\/2023\/04\/13024659\/zapier-social.jpg","twitter_creator":"@PingCAP","twitter_site":"@PingCAP","twitter_misc":{"Written by":"Arun Vijayraghavan","Est. reading time":"8\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/#article","isPartOf":{"@id":"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/"},"author":{"name":"Arun Vijayraghavan","@id":"https:\/\/www.pingcap.com\/#\/schema\/person\/8a9e54493a2a21018fd222e0a32b1ffd"},"headline":"Streamline Data Workflows with TiDB Cloud and Zapier","datePublished":"2023-04-13T09:52:51+00:00","dateModified":"2024-06-07T04:56:44+00:00","mainEntityOfPage":{"@id":"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/"},"wordCount":1429,"commentCount":0,"publisher":{"@id":"https:\/\/www.pingcap.com\/#organization"},"image":{"@id":"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/#primaryimage"},"thumbnailUrl":"https:\/\/static.pingcap.com\/files\/2023\/04\/13024432\/20230413-174356.jpeg","keywords":["Real-time analytics","TiDB Cloud"],"articleSection":["Product"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/","url":"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/","name":"Streamline Data Workflows with TiDB Cloud and Zapier | TiDB","isPartOf":{"@id":"https:\/\/www.pingcap.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/#primaryimage"},"image":{"@id":"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/#primaryimage"},"thumbnailUrl":"https:\/\/static.pingcap.com\/files\/2023\/04\/13024432\/20230413-174356.jpeg","datePublished":"2023-04-13T09:52:51+00:00","dateModified":"2024-06-07T04:56:44+00:00","description":"Learn how to connect multiple data-intensive applications and receive informed business insights in real time using TiDB Cloud and Zapier.\u00a0","breadcrumb":{"@id":"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/#primaryimage","url":"https:\/\/static.pingcap.com\/files\/2023\/04\/13024432\/20230413-174356.jpeg","contentUrl":"https:\/\/static.pingcap.com\/files\/2023\/04\/13024432\/20230413-174356.jpeg","width":1600,"height":534},{"@type":"BreadcrumbList","@id":"https:\/\/www.pingcap.com\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pingcap.com\/"},{"@type":"ListItem","position":2,"name":"Streamline Data Workflows with TiDB Cloud and Zapier"}]},{"@type":"WebSite","@id":"https:\/\/www.pingcap.com\/#website","url":"https:\/\/www.pingcap.com\/","name":"\ud2f0DB","description":"TiDB | SQL at Scale","publisher":{"@id":"https:\/\/www.pingcap.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.pingcap.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Organization","@id":"https:\/\/www.pingcap.com\/#organization","name":"PingCAP","url":"https:\/\/www.pingcap.com\/","logo":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/","url":"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png","contentUrl":"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png","width":811,"height":232,"caption":"PingCAP"},"image":{"@id":"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/facebook.com\/pingcap2015","https:\/\/x.com\/PingCAP","https:\/\/linkedin.com\/company\/pingcap","https:\/\/youtube.com\/channel\/UCuq4puT32DzHKT5rU1IZpIA"]},{"@type":"Person","@id":"https:\/\/www.pingcap.com\/#\/schema\/person\/8a9e54493a2a21018fd222e0a32b1ffd","name":"Arun Vijayraghavan","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.pingcap.com\/#\/schema\/person\/image\/","url":"https:\/\/static.pingcap.com\/files\/2022\/10\/17234942\/avatar.jpg","contentUrl":"https:\/\/static.pingcap.com\/files\/2022\/10\/17234942\/avatar.jpg","caption":"Arun Vijayraghavan"},"description":"TiDB Cloud Product Manager","url":"https:\/\/www.pingcap.com\/ko\/blog\/author\/arun-vijayraghavan\/"}]}},"grav_blocks":false,"card_markup":"<a class=\"card-resource bg-white\" href=\"https:\/\/www.pingcap.com\/ko\/blog\/streamline-data-workflows-with-tidb-cloud-and-zapier\/\"><div class=\"card-resource__image-container\"><img class=\"card-resource__image\" alt=\"20230413-174356\" src=\"https:\/\/static.pingcap.com\/files\/2023\/04\/13024432\/20230413-174356.jpeg\" loading=\"lazy\" width=1600 height=534 \/><\/div><div class=\"card-resource__content-container\"><div class=\"card-resource__content-head\"><div class=\"card-resource__category\">Product<\/div><\/div><h5 class=\"card-resource__title\">Streamline Data Workflows with TiDB Cloud and Zapier<\/h5><\/div><\/a>","_links":{"self":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/posts\/11471","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/users\/216"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/comments?post=11471"}],"version-history":[{"count":13,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/posts\/11471\/revisions"}],"predecessor-version":[{"id":17567,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/posts\/11471\/revisions\/17567"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/media\/11483"}],"wp:attachment":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/media?parent=11471"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/categories?post=11471"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/tags?post=11471"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
Set up TiDB Cloud<\/h3>\n\n\n\nCreate API Keys<\/h4>\n\n\n\n
To create API Keys, do the following: <\/p>\n\n\n\n
TiDB Cloud automatically creates the public and private keys. Copy and save them for later use.<\/p>\n\n\n\n Use the Chat2Query editor<\/a> to execute a SQL script to create a `nces_avg_cost` table. The sample dataset will be stored in this table later. <\/p>\n\n\n\n For this example, we\u2019ll use the National Center for Education Statistics (NCES) data as a sample dataset. This dataset contains college tuition fee data for different states in the US.<\/p>\n\n\n\n Next, sign into your Google Docs account and create a new spreadsheet with the columns as shown below. Alternatively, you can copy this Google spreadsheet<\/a>. You can also add a row of data to the spreadsheet. This will help us when we test our Zap trigger later. Note<\/strong>: The sheet contains only columns. The column names match the table columns that we created earlier.<\/p>\n\n\n\n You\u2019ve created a Google Sheet and a TiDB Cloud instance. Now, we’ll use Zapier to connect them. Zapier lets you automate workflows by creating “Zaps” that consist of triggers and actions. In this case, we\u2019ll create a Zap that triggers an action in TiDB Cloud whenever a new row is added to our Google Sheet. This will ensure that the TiDB Cloud database has the latest data from the Google Sheet, without requiring any manual effort.<\/p>\n\n\n\n To create a new Zap:<\/p>\n\n\n\n After you configure the Zap, you can configure the action.<\/p>\n\n\n\n Note<\/strong>: Leave the Id<\/strong> column blank. It\u2019s configured to be an auto-generated column in the table.<\/p> With your Zap published and running, you can test it by adding new records to your Google Sheets. You can find free sample datasets on Kaggle<\/a> or use our sample data sheet<\/a>.<\/p>\n\n\n\n To explore and review the data generated by our TiDB Cloud Zap, we\u2019ll use datasets from 2020 and 2021 for five US states.<\/p>\n\n\n\n Note:<\/strong> Zapier\u2019s free tier only runs Zaps every 15 minutes, so you may need to wait up to 15 minutes for the new rows to be added to TiDB Cloud. If you are on a Professional or Team Plan, the updates will be triggered instantly.<\/p>\n\n\n\n Now that we have successfully integrated Google Sheets with TiDB Cloud, and data is automatically updated in the database, it’s time to explore and review that data. We’ll use TiDB’s AI-powered Chat2Query feature<\/a> to generate a SQL query that aggregates and summarizes the data. We will be looking at the year-on-year tuition fees in each state for a 4-year program. Then we’ll use a popular visualization tool, Grafana, to create a dashboard to display that data so it\u2019s easy to understand and analyze.<\/p>\n\n\n\n To access Chat2Query:<\/p>\n\n\n\n After Chat2Query generates the query, you can modify it as needed to ensure that the output matches your visualization requirements. <\/p>\n\n\n\n After you use Chat2Query to generate the SQL query and tweak it to fit your needs, you can use Grafana (or other MySQL-compatible visualization tool) to visualize the data. To connect Grafana to your TiDB cluster, follow the steps in How to connect Grafana to a remote MySQL database<\/a>.<\/p>\n\n\n\n Grafana lets you create charts and dashboards that help you better understand your data. In our case, we\u2019ll create a bar chart that shows the year-over-year tuition fees for four-year programs in the five states we selected. As you can see from the chart, most states had a significant decrease in tuition between 2020 and 2021. A few others remained relatively stable. With this visualization, we can quickly gain insights and make data-driven decisions that impact our educational choices.<\/p>\n\n\n\n Integrating TiDB Cloud and Zapier offers a powerful solution for businesses to manage their data and streamline their workflows. This integration also allows businesses to gain valuable insights from their data, make more informed decisions, and improve overall efficiency.<\/p>\n\n\n\n We hope you find this blog useful. If you\u2019re interested in this integration, you are welcome to sign in to (or sign up for) your TiDB Cloud<\/a> \uadf8\ub9ac\uace0 Zapier<\/a> accounts and give them a try. If you want more deployment details for this integration, see our documentation<\/a>. If you have any questions, feel free to contact us through Twitter<\/a>, LinkedIn<\/a>, or our Slack Channel<\/a>.<\/p>","protected":false},"excerpt":{"rendered":" Learn how to connect multiple data-intensive applications with streamlined workflows and receive informed business insights in real time using TiDB Cloud and Zapier.\u00a0<\/p>","protected":false},"author":216,"featured_media":11483,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ub_ctt_via":"","footnotes":""},"categories":[13],"tags":[11,31],"class_list":["post-11471","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-product","tag-real-time-analytics","tag-tidb-cloud"],"acf":[],"featured_image_src":"https:\/\/static.pingcap.com\/files\/2023\/04\/13024432\/20230413-174356.jpeg","author_info":{"display_name":"Arun Vijayraghavan","author_link":"https:\/\/www.pingcap.com\/ko\/blog\/author\/arun-vijayraghavan\/"},"yoast_head":"\n\n
<\/figure><\/li>\n\n\n\nCreate a table<\/h4>\n\n\n\n
CREATE TABLE test.nces_avg_cost\n\n(\n\n id bigint AUTO_RANDOM primary key,\n\n Year int,\n\n State varchar(25) NOT NULL,\n\n Type varchar(25) NOT NULL,\n\n Length varchar(10) NOT NULL,\n\n Expense varchar(50) NOT NULL,\n\n Amount double NOT NULL \n\n)<\/code><\/pre>\n\n\n\n<\/figure>\n\n\n\nSet up Google Sheets<\/h3>\n\n\n\n
<\/p>\n\n\n\n<\/figure>\n\n\n\nCreate a Zap: connecting Google Sheets with TiDB Cloud<\/h3>\n\n\n\n
Create a new Zap<\/h4>\n\n\n\n
\n
<\/figure><\/li>\n\n\n\nConfigure the trigger<\/h4>\n\n\n\n
\n
<\/figure><\/li>\n\n\n\nConfigure the action<\/h4>\n\n\n\n
\n
<\/figure><\/li>\n\n\n\n<\/figure><\/li>\n\n\n\n<\/figure><\/li>\n<\/ol>\n\n\n\n<\/span>Exploring and reviewing data<\/span><\/h2>\n\n\n\n
Data exploration with Chat2Query<\/h3>\n\n\n\n
\n
<\/li>\n<\/ol>\n\n\n\nSELECT Year, CONCAT(State, ' - ', Year) AS State, SUM(Amount) AS Tuition\n\nFROM test.nces_avg_cost\n\nWHERE Length like '%4%'\n\nGROUP BY Year,State\n\nORDER BY State, Year DESC<\/code><\/pre>\n\n\n\nData visualization<\/h3>\n\n\n\n
<\/figure>\n\n\n\n<\/span>Summary<\/span><\/h2>\n\n\n\n