public static DataTable ExecuteSnowflakeQuery(string query) { try { using (IDbConnection conn = new SnowflakeDbConnection()) { conn.ConnectionString = “Account=<>;user=<>;Password =<>;Role=ACCOUNTADMIN;db=<>;schema=public”; conn.Open(); using (IDbCommand cmd = conn.CreateCommand()) { cmd.CommandText = “USE WAREHOUSE Warehousename”; cmd.ExecuteNonQuery(); cmd.CommandText = query; using (IDataReader reader = cmd.ExecuteReader()) { var result = new DataTable(); result.Load(reader); return result; } } } } catch (DbException […]