The cloud-native orchestrator for the whole development lifecycle, with integrated lineage and observability.

dagster

I'm trying to query our Snowflake database and following this <https://docs.dagster.io/integrations/snowflake/reference#executing-custom-sql-commands-with-the-snowflake-resource|documentation>. I identically followed the documentation and can't see the query being passed to the database on the Snowflake side. Code in thread :thread:

```def table(snowflake: SnowflakeResource) -&gt; pd.DataFrame:
    with snowflake.get_connection() as conn:
        return (
            conn.cursor()
            .execute(
                "SELECT * FROM OPEN_WEATHER"
            )
            .fetch_pandas_all()
        )

defs = Definitions(
    resources={
        "snowflake": SnowflakeResource(
            account=EnvVar("SNOWFLAKE_ACCOUNT"),
            user=EnvVar("SNOWFLAKE_USER"),
            password=EnvVar("SNOWFLAKE_PASSWORD"),
            database="PROD",
            schema="RAW",
        )
    },
)```

Hi! What feedback are you getting from Python?

Is the run hanging, failing, oddly working, etc.?

Oddly working, but I don't see the sql statement passing to the database on the snowflake side.

Oh hmm. I see you're not specifying the role, what could be happening is that it's executing with a default role that is higher than the one you're viewing the query history in (ex. ACCOUNTADAMIN)