PRAGMA statements are a simple way to configure certain internal details of the data.world query engine.

PRAGMA SNOWFLAKE USE WAREHOUSE MyWarehouse

This statement is equivalent to USE WAREHOUSE in Snowflake. (Snowflake docs)

This will modify the JDBC connection string used to specify a warehouse. When setting up the connection, be sure to limit which Warehouses the configured user has access to. This statement will allow dataset users to affect the warehouse used for queries.

This statement will affect the current query only; this will have no effect on other queries.

PRAGMA SNOWFLAKE USE WAREHOUSE MyWarehouse

SELECT * FROM MyTable

PRAGMA ATHENA USE WORKGROUP MyWorkgroup

Athena Workgroups are used to separate query execution and query history between Users, Teams, or Applications running under the same AWS account.

This statement will modify the JDBC connection string to specify the Athena Workgroup. When setting up the connection, be sure to limit which Workgroup the configured user has access to. This statement will allow dataset users to affect the workgroup used for queries.

This statement will affect the current query only; this will have no effect on other queries.

PRAGMA ATHENA USE WORKGROUP MyWorkgroup

SELECT * FROM MyTable