Enabling federated query access to Heterogeneous data sources

A computer-implemented method performed by an interactive query service, the method comprising:

• receiving input defining first configuration data for a first data source and second configuration data for a second data source, wherein the first data source uses a first type of data storage that is different from a second type of data storage used by the second data source, and wherein the first and second types of data storage include one or more of object storage, a database instance, a data warehouse, or data accessible from an external service;
• receiving a query that references first data stored at the first data source and second data stored at the second data source;
• translating at least a first portion of the query into first operations used to access the first data source and at least a second portion of the query into second operations used to access the second data source;
• and
• executing the query by accessing the first data stored at the first data source using the first configuration data and the first operations and accessing the second data stored at the second data source using the second configuration data and the second operations.

A system comprising:

• an interactive query service of a service provider network implemented by a first one or more electronic devices, the interactive query service including instructions that upon execution cause the interactive query service to:
• receive input defining first configuration data for a first data source and second configuration data for a second data source, wherein the first data source stores data using a first type of data storage that is different from a second type of data storage used by the second data source, wherein the first type of data storage of the first data source is one of object storage, a data warehouse, or data accessible from an external service, and wherein the second data source is provided by a database service of the service provider network,
• receive a query that references first data stored at the first data source and second data stored at the second data source,
• translate at least a first portion of the query into first operations used to access the first data source and at least a second portion of the query into second operations used to access the second data source,
• generate a query plan based at least in part on the query, the first configuration data, and the second configuration data, and
• execute the query plan at least in part by sending a portion of the query plan to the database service;
• and
• the database service of the service provider network implemented by a second one or more electronic devices, the database service including instructions that upon execution cause the database service to:
• receive the portion of the query plan from the interactive query service,
• execute the portion of the query plan using a query engine of the database service to obtain partial query results, and
• send the partial query results to the interactive query service.