GoogleSheets
GoogleSheets source connector
Description
Used to read data from GoogleSheets.
Key features
- batch
- stream
- exactly-once
- column projection
- parallelism
- support user-defined split
- file format
- text
- csv
- json
Options
name | type | required | default value |
---|---|---|---|
service_account_key | string | yes | - |
sheet_id | string | yes | - |
sheet_name | string | yes | - |
range | string | yes | - |
schema | config | no | - |
service_account_key [string]
google cloud service account, base64 required
sheet_id [string]
sheet id in a Google Sheets URL
sheet_name [string]
the name of the sheet you want to import
range [string]
the range of the sheet you want to import
schema [config]
fields [config]
the schema fields of upstream data
Example
simple:
GoogleSheets {
service_account_key = "seatunnel-test"
sheet_id = "1VI0DvyZK-NIdssSdsDSsSSSC-_-rYMi7ppJiI_jhE"
sheet_name = "sheets01"
range = "A1:C3"
schema = {
fields {
a = int
b = string
c = string
}
}
}
Changelog
next version
- Add GoogleSheets Source Connector