Google BigQuery and Redshift との統合と自動化

Google BigQuery and Redshiftを他のツールとシームレスに接続。ワークフローを自動化し、業務効率を向上させます。

評価

4.9

事前構築済み

150+

統合

合計

100+

アクティブユーザー

平均

2分

接続まで

カスタム接続

利用可能

HTTPコネクター経由で利用可能

主要企業が Workato を活用

強力なワークフローを迅速に構築

Triggers

When this happens…

Google BigQuery

New job completed
New job completed in BigQuery
New row
New row in a table in BigQuery
New rows Batch
New batch of rows in a table in BigQuery
Scheduled query Batch
New scheduled query using custom SQL in BigQuery

Any other trigger you can think up

Redshift

New row
New row in a table in Redshift
New rows Batch
New batch of rows in a table in Redshift
New rows via custom SQL Batch
New batch of rows via custom SQL in Redshift
New/updated row
New/updated row in a table in Redshift
New/updated rows Batch
New/updated batch of rows in a table in Redshift
New/updated rows via custom SQL Batch
New/updated batch of rows via custom SQL in Redshift

Any other trigger you can think up

Actions

Do this…

Google BigQuery

Custom action
Custom action in Google BigQuery (Custom)
Get batch of rows by Job ID Batch
Get batch of rows from query result in BigQuery
Insert row
Insert a row in table in BigQuery
Insert rows Batch
Insert rows in table in BigQuery
Load data into BigQuery
Load data into table on BigQuery
Load data from Google Cloud Storage into BigQuery
Load data from Google Cloud Storage into table on BigQuery
Run custom SQL in BigQuery
Run custom SQL in BigQuery
Select rows (Old) Batch
Select rows asynchronously in a table in BigQuery
Select rows Batch
Select rows in a table in BigQuery
Select rows using custom SQL (Old) Batch
Select rows asynchronously using custom SQL in BigQuery
Select rows using custom SQL Batch
Select rows using custom SQL in BigQuery
Select rows using custom SQL and insert into table Batch
Select rows using custom SQL and insert into table in BigQuery

Any other action you can think up

Redshift

Delete rows Batch
Delete rows in a table in Redshift
Export query result
Export query result as a CSV file in Redshift
Insert row
Insert row in a table in Redshift
Insert rows Batch
Insert batch of rows in a table in Redshift
Run custom SQL Batch
Run custom SQL in Redshift
Run long query using custom SQL
Run long query using custom SQL in Redshift
Select rows Batch
Select rows in a table in Redshift
Select rows using custom SQL Batch
Select rows using custom SQL in Redshift
Update rows
Update rows in a table in Redshift
Update rows Batch
Update batch of rows in a table in Redshift
Upsert row
Upsert row in a table in Redshift
Upsert rows Batch
Upsert batch of rows in a table in Redshift

Any other action you can think up

単一のプラットフォーム

強力
俊敏性
スピード
革新