activities
latest
false
Integration Service 活动
- 概述
- UiPath 生成式 AI 活动
- Act! 365
- ActiveCampaign
- Adobe Acrobat Sign
- Adobe PDF 服务
- 智能体 2 智能体 - 预览版
- Amazon Bedrock
- Amazon Connect
- Amazon Polly
- 亚马逊 SES
- Amazon Transcribe
- Anthropic Claude
- Asana
- AWeber
- Azure AI 文档智能
- Azure Defender for Cloud
- Azure Maps
- BambooHR
- Box
- Brevo
- Calendly
- Campaign Monitor
- Cisco Webex Teams
- Citrix ShareFile
- 清除位
- Confluence Cloud
- Constant Contact
- Coupa
- CrewAI – 预览版
- Customer.io
- Database Hub
- Databricks - Preview
- About the Databricks activities
- 项目兼容性
- Execute a SQL Query
- Get SQL Statement Result
- 创建作业
- Delete a Job
- Cancel a Job Run
- Run a Job Now
- Run a Notebook
- Get a Job
- List Jobs
- Get a Job Run
- Get a Job Run Output
- List Job Runs
- Import a Notebook
- Export a Notebook
- List a Workspace Folder
- Get Workspace Object Status
- Delete a Catalog
- List Catalogs
- Delete a Directory
- Delete a File
- List a Directory
- Download a File
- 获取文件信息
- Create a Directory
- Upload a File
- Start a Conversation
- Execute a Message SQL Query
- Create a Conversation Message
- Get a Conversation Message
- Get Genie Query Results
- List Genie Spaces
- Get a Genie Space
- Create a Vector Search Index
- Query a Vector Search Index
- List Vector Search Indexes
- Get a Vector Search Index
- 删除记录
- 获取记录
- 插入记录
- 列出记录
- 更新记录
- Databricks HTTP Request
- Databricks智能体
- Datadog
- 深度查找
- Deputy
- Discord - 预览
- DocuSign
- 水滴
- Dropbox
- Dropbox Business
- Egnyte
- Epic FHIR - 预览
- Eventbrite
- 汇率
- Expensify
- Facebook
- Freshbooks
- Freshdesk
- Freshsales
- Freshservice
- 获取响应
- GitHub
- Google Maps
- Google 语音转文本
- Google 文本转语音
- Google Vertex
- Google Vision
- GoToWebinar
- Greenhouse
- Hootsuite
- HTTP Webhook
- HubSpot CRM
- HubSpot Marketing
- Icertis
- iContact
- Insightly CRM
- Intercom
- Jina.ai
- Jira
- Keap
- Klaviyo
- LinkedIn
- Mailchimp
- Mailjet
- MailerLite
- Mailgun
- Marketo
- MCP
- Microsoft Azure OpenAI
- Microsoft Azure AI Foundry
- Microsoft Azure Sentinel
- Microsoft Dynamics CRM
- Microsoft Power Automate
- Microsoft Sentiment
- Microsoft Sentinel Threat Intelligence
- Microsoft Teams
- Microsoft Translator
- Microsoft Vision
- Miro
- NVIDIA NIM
- 奥克塔
- OpenAI
- 符合 OpenAI V1 的 LLM
- Oracle Eloqua
- Oracle NetSuite
- PagerDuty
- Paypal
- PDFMonkey
- Perplexity
- Pinecone
- Pipedrive
- QuickBooks Online
- Quip
- Salesforce
- Salesforce Agentforce & Flows
- Salesforce Marketing Cloud
- SAP BAPI
- SAP Cloud for Customer
- SAP Concur
- SAP OData
- SendGrid
- ServiceNow
- Shopify
- Slack
- SmartRecruiters
- Smartsheet
- Snowflake
- Snowflake Cortex
- Stripe
- Sugar Enterprise
- Sugar Professional
- Sugar Sell
- Sugar Serve
- 探戈卡
- Todoist
- Trello
- Twilio
- 类型安全 - 预览
- UiPath Apps - Preview
- UiPath Orchestrator
- UiPath Test Manager
- IBM WatsonX
- WhatsApp Business
- WOO COMMERCE
- 可行
- Workday
- Workday REST
- X（以前称为 Twitter）
- Xero
- Youtube
- Zendesk
- Zoho Campaigns
- Zoho Desk
- Zoho Mail
- 缩放
- Zoom 信息
重要 :
请注意，此内容已使用机器翻译进行了部分本地化。
新发布内容的本地化可能需要 1-2 周的时间才能完成。
Execute a SQL Query
Execute a SQL Query activity in the Databricks connector.
项目兼容性
Windows | 跨平台
概述
| 描述 | API 方法 | API 路径 |
|---|---|---|
| Run a SQL statement on a Databricks SQL warehouse. Requires warehouse_id and statement; rows come back under result.data_array with column metadata in manifest.schema. | 发布 | /statements |
输入
| 参数 | 描述 | 数据类型 |
|---|---|---|
| SQL Statement * | The SQL statement to execute. For example, SELECT * FROM hive_metastore.default.p_order LIMIT 10. | 字符串 |
| Warehouse ID * | ID of the SQL warehouse to run the statement on. For example, a1b2c3d4e5f6a7b8. | 字符串 |
| 目录 | Catalog used as the default for the statement. For example, main. | 字符串 |
| 架构 | Schema used as the default for the statement. For example, default. | 字符串 |
| Wait Timeout | How long to wait synchronously, 0s or 5s-50s. Default: 30s. | 字符串 |
| On Wait Timeout | CONTINUE returns a statement_id to poll; CANCEL aborts the statement. For long queries, set Wait Timeout to 0s and On Wait Timeout to CONTINUE, then poll with Get SQL Statement Result. Allowed values: CONTINUE, CANCEL. Default: CONTINUE. | 字符串 |
| Row Limit | Maximum number of rows to return. For example, 1000. | 整数 |
| Byte Limit | Maximum result size in bytes. For example, 10485760. | 整数 |
| Disposition | INLINE returns data in the response; EXTERNAL_LINKS returns presigned URLs. Allowed values: INLINE, EXTERNAL_LINKS. Default: INLINE. | 字符串 |
| 格式 | Result serialization format. Allowed values: JSON_ARRAY, ARROW_STREAM, CSV. Default: JSON_ARRAY. | 字符串 |
| 参数 | Named parameter markers, for example [{"name":"p","value":"1","type":"INT"}]. | 数组 |
* Required parameter.
输出
| 参数 | 描述 | 数据类型 |
|---|---|---|
| Statement ID | Server-assigned statement id; poll with Get Statement. | 字符串 |
| 状态 | Execution state: PENDING, RUNNING, SUCCEEDED, FAILED, CANCELED, CLOSED. | object |
| Manifest | Result schema, chunk layout and row counts. | object |
| 结果 | Result payload; row data is under result.data_array. | object |
备注：
You might see variations in the output depending on where you run the activity. In API workflows and Maestro Flow, a single response object containing all the fields is returned. In RPA workflows, not all fields are exposed, but you can still retrieve them from the exposed response object.