PRAGMA Statements

A list of PRAGMA statements supported by data.world

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