query-integration-data

To query and modify data across multiple API integrations and data warehouses, you can use a programmatic capability that reads, exports, and writes data across services like Linear, GitHub, HubSpot, Slack, Snowflake, and BigQuery without requiring local script files.

Yes, you can write data back to connected services like HubSpot and Slack from a chat automation. The capability supports create, update, and delete operations across connected integrations using credentials obtained via the listConnections sandbox function.

The best way to run ad-hoc queries on Snowflake and BigQuery without writing local scripts is using a code execution sandbox that obtains credentials programmatically, allowing you to fetch data directly for chat answers, reports, or multi-step automation workflows.

Yes, this approach works with Databricks and Google services for cross-service data orchestration. It connects to these data warehouses and external services to perform both read and write operations, enabling automated workflows without manual credential management or custom UI.

Credentials for accessing connected integrations like GitHub and Linear are managed programmatically. The system uses the listConnections(connectorName) function within a code_execution sandbox to obtain the necessary authentication tokens, eliminating manual credential handling.