Routing SQL statements to elastic compute nodes using workload class

One or more computing devices comprising:

• processors;
• and
• memory;
• the one or more computing devices configured, via computer-executable instructions, to route structured query language (SQL) statements to elastic compute nodes (ECNs) using workload classes within a distributed database environment, the operations comprising:
• creating a workload class, wherein the workload class comprises a routing location hint, wherein the routing location hint identifies one or more elastic compute nodes that are associated with the workload class;
• creating a workload mapping that is associated with the workload class, wherein the workload mapping defines which types of SQL statements are mapped to the workload class based at least in part on properties associated with the SQL statements;
• receiving a SQL statement for execution within the distributed database environment, wherein the workload class matches one or more properties of the SQL statement;
• routing the SQL statement to a selected elastic compute node of the one or more elastic compute nodes identified by the routing location hint of the workload class;
• and
• executing, by the selected elastic compute node, the SQL statement, wherein the SQL statement uses one or more persistent database tables that are not stored at the selected elastic compute node.

One or more computer-readable storage media storing computer-executable instructions for execution on one or more computing devices to perform operations for routing structured query language (SQL) statements to elastic compute nodes (ECNs) using workload classes within a distributed database environment, the operations comprising:

• creating a workload class, wherein the workload class comprises a routing location hint, wherein the routing location hint identifies one or more elastic compute nodes that are associated with the workload class;
• creating a workload mapping that is associated with the workload class, wherein the workload mapping defines which types of SQL statements are mapped to the workload class based at least in part on properties associated with the SQL statements;
• receiving a SQL statement for execution within the distributed database environment, wherein the workload class matches one or more properties of the SQL statement;
• routing the SQL statement to a selected elastic compute node of the one or more elastic compute nodes identified by the routing location hint of the workload class;
• and
• executing, by the selected elastic compute node, the SQL statement, wherein the SQL statement uses one or more persistent database tables that are not stored at the selected elastic compute node.