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. Under the hood,
this will change the JDBC connection string to specify a warehouse. When
setting up a connection to Snowflake, be sure to limit which Warehouses the
user has access to. This statement will allow dataset users to affect the
warehouse used for all queries.
This statement will only affect the current query; other queries will not be affected.
PRAGMA SNOWFLAKE USE WAREHOUSE MyWarehouse SELECT * FROM MyTable