query-integration-data

To query and modify data across integrations and data warehouses, you can execute read operations like queries and exports, and perform write operations including create, update, and delete on connected services. You must supply the respective API credentials for the warehouses being used.

Yes, you can modify data in connected services like GitHub. The data modification feature supports write operations, allowing you to create, update, and delete records directly within your target integrations.

You need the specific API credentials for the respective integrations and data warehouses being used. Providing the correct access credentials is required to authenticate and execute read or write operations across the connected services.

The best way to retrieve sales data from a connected Databricks warehouse is to use data querying operations. You can execute read operations and exports on the warehouse to quickly fetch the required dataset to answer your business questions.

Yes, this data querying approach works for exporting records and counting rows. The functionality explicitly supports executing read operations such as queries, counts, and exports across your connected integrations and data warehouses.

When modifying data across different integrations, operations are constrained by the need for valid API credentials and the specific write capabilities of the target service. You must ensure the respective APIs support the create, update, and delete operations you intend to execute.