query-integration-data

You can query data across multiple connected services by using the listConnections() function to fetch credentials, then executing direct API calls inline within the code_execution sandbox for cross-service insights.

Yes, you can perform write operations to Databricks, Snowflake, and BigQuery without a custom integration layer by fetching credentials via listConnections() and calling APIs directly to modify resources.

The best way to automate cross-service data tasks is using the code_execution sandbox to perform multi-step operations, obtaining credentials with listConnections() and calling APIs directly to extract data warehouse records.

Yes, this approach handles credentials securely by retrieving them via the listConnections() function within the isolated code_execution sandbox before making direct API read and write operations across connected services.

To get credentials for direct API calls, use the listConnections(connectorName) function inside the code execution sandbox, which returns the necessary authentication details to execute read and write operations across your connected services.

You should avoid inline code execution for querying connected services if you require persistent scheduled batch jobs or complex custom integration layers, as this approach is designed for ad-hoc automation and direct API calls within the sandbox.