使用DATABRICKS API构建智能工业自动化的指南.pdf

1、BUILDING SMART INDUSTRIAL AUTOMATIONS WITH THE DATABRICKS API12024 Databricks Inc.All rights reservedJOYCE LIN,VIAM JUNE 12,2024SMART INDUSTRIAL AUTOMATIONSWith the Databricks Statement Execution APIJoyce LinHead of Developer Relations at Viamjoycejetson|viamrobotics22024 Databricks Inc.All rights r

2、eservedSMART INDUSTRIAL AUTOMATIONSWith the Databricks Statement Execution APIJoyce LinHead of Developer Relations at Viamjoycejetson|viamrobotics32024 Databricks Inc.All rights reservedSMART INDUSTRIAL AUTOMATIONSWith the Databricks Statement Execution APIDatabricks Statement Execution APIAPI autom

3、ation examplesend notification for long-running queryCode generation42024 Databricks Inc.All rights reservedWAYS TO CONNECT TO DATABRICKS SQLNative connectors52024 Databricks Inc.All rights reservedTHE DATABRICKS STATEMENT EXECUTION API62024 Databricks Inc.All rights reservedDATABRICKS SQL STATEMENT

4、 EXECUTION API72024 Databricks Inc.All rights reservedHTTP APIUse the API to connect to your Databricks SQL warehouse over a REST API to access and manipulate data managed by the Databricks Lakehouse Platform.AvailabilityDatabricks Premium and Enterprise tiersAWS,Azure,GCP(coming soon)DATABRICKS SQL

5、 STATEMENT EXECUTION API82024 Databricks Inc.All rights reservedEndpointsSubmit a SQL statement for executionPOST/sql/statementsCheck the status and retrieve resultsGET/sql/statements/statement_id/sql/statements/statement_id/result/chunks/chunk_indexCancel a SQL statement executionPOST/sql/statement

6、s/statement_id/cancelDefaultAsynchronousSynchronousPOST/sql/statementswait_timeout:“15s”on_wait_timeout:“CONTINUE”Fetch results with IDPOST/sql/statementswait_timeout:“0s”Fetch results with IDPOST/sql/statementswait_timeout:“15s”on_wait_timeout:“CANCEL”Receive results in same callTHREE EXECUTION MOD