{"action":"created","issue":{"url":"https://api.github.com/repos/snowflakedb/snowflake-connector-net/issues/42","repository_url":"https://api.github.com/repos/snowflakedb/snowflake-connector-net","labels_url":"https://api.github.com/repos/snowflakedb/snowflake-connector-net/issues/42/labels{/name}","comments_url":"https://api.github.com/repos/snowflakedb/snowflake-connector-net/issues/42/comments","events_url":"https://api.github.com/repos/snowflakedb/snowflake-connector-net/issues/42/events","html_url":"https://github.com/snowflakedb/snowflake-connector-net/issues/42","id":334157180,"node_id":"MDU6SXNzdWUzMzQxNTcxODA=","number":42,"title":"Role as part of the connection string is not being recognize.","user":{"login":"eddychansnowflake","id":22844739,"node_id":"MDQ6VXNlcjIyODQ0NzM5","avatar_url":"https://avatars1.githubusercontent.com/u/22844739?v=4","gravatar_id":"","url":"https://api.github.com/users/eddychansnowflake","html_url":"https://github.com/eddychansnowflake","followers_url":"https://api.github.com/users/eddychansnowflake/followers","following_url":"https://api.github.com/users/eddychansnowflake/following{/other_user}","gists_url":"https://api.github.com/users/eddychansnowflake/gists{/gist_id}","starred_url":"https://api.github.com/users/eddychansnowflake/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/eddychansnowflake/subscriptions","organizations_url":"https://api.github.com/users/eddychansnowflake/orgs","repos_url":"https://api.github.com/users/eddychansnowflake/repos","events_url":"https://api.github.com/users/eddychansnowflake/events{/privacy}","received_events_url":"https://api.github.com/users/eddychansnowflake/received_events","type":"User","site_admin":false},"labels":[{"id":641666201,"node_id":"MDU6TGFiZWw2NDE2NjYyMDE=","url":"https://api.github.com/repos/snowflakedb/snowflake-connector-net/labels/bug","name":"bug","color":"ee0701","default":true}],"state":"closed","locked":false,"assignee":{"login":"howryu","id":6554661,"node_id":"MDQ6VXNlcjY1NTQ2NjE=","avatar_url":"https://avatars2.githubusercontent.com/u/6554661?v=4","gravatar_id":"","url":"https://api.github.com/users/howryu","html_url":"https://github.com/howryu","followers_url":"https://api.github.com/users/howryu/followers","following_url":"https://api.github.com/users/howryu/following{/other_user}","gists_url":"https://api.github.com/users/howryu/gists{/gist_id}","starred_url":"https://api.github.com/users/howryu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/howryu/subscriptions","organizations_url":"https://api.github.com/users/howryu/orgs","repos_url":"https://api.github.com/users/howryu/repos","events_url":"https://api.github.com/users/howryu/events{/privacy}","received_events_url":"https://api.github.com/users/howryu/received_events","type":"User","site_admin":false},"assignees":[{"login":"howryu","id":6554661,"node_id":"MDQ6VXNlcjY1NTQ2NjE=","avatar_url":"https://avatars2.githubusercontent.com/u/6554661?v=4","gravatar_id":"","url":"https://api.github.com/users/howryu","html_url":"https://github.com/howryu","followers_url":"https://api.github.com/users/howryu/followers","following_url":"https://api.github.com/users/howryu/following{/other_user}","gists_url":"https://api.github.com/users/howryu/gists{/gist_id}","starred_url":"https://api.github.com/users/howryu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/howryu/subscriptions","organizations_url":"https://api.github.com/users/howryu/orgs","repos_url":"https://api.github.com/users/howryu/repos","events_url":"https://api.github.com/users/howryu/events{/privacy}","received_events_url":"https://api.github.com/users/howryu/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/snowflakedb/snowflake-connector-net/milestones/1","html_url":"https://github.com/snowflakedb/snowflake-connector-net/milestone/1","labels_url":"https://api.github.com/repos/snowflakedb/snowflake-connector-net/milestones/1/labels","id":3442850,"node_id":"MDk6TWlsZXN0b25lMzQ0Mjg1MA==","number":1,"title":"v1.0.2","description":null,"creator":{"login":"howryu","id":6554661,"node_id":"MDQ6VXNlcjY1NTQ2NjE=","avatar_url":"https://avatars2.githubusercontent.com/u/6554661?v=4","gravatar_id":"","url":"https://api.github.com/users/howryu","html_url":"https://github.com/howryu","followers_url":"https://api.github.com/users/howryu/followers","following_url":"https://api.github.com/users/howryu/following{/other_user}","gists_url":"https://api.github.com/users/howryu/gists{/gist_id}","starred_url":"https://api.github.com/users/howryu/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/howryu/subscriptions","organizations_url":"https://api.github.com/users/howryu/orgs","repos_url":"https://api.github.com/users/howryu/repos","events_url":"https://api.github.com/users/howryu/events{/privacy}","received_events_url":"https://api.github.com/users/howryu/received_events","type":"User","site_admin":false},"open_issues":0,"closed_issues":4,"state":"open","created_at":"2018-06-21T18:05:22Z","updated_at":"2018-06-21T22:58:44Z","due_on":null,"closed_at":null},"comments":1,"created_at":"2018-06-20T16:30:03Z","updated_at":"2018-06-22T13:21:17Z","closed_at":"2018-06-21T22:57:58Z","author_association":"NONE","body":"It won't change the role from the default to ACCOUNTADMIN even though its defined in the connection string, nor is the database and maybe schema parameters are recognized.\r\n\r\n            using (IDbConnection conn = new SnowflakeDbConnection())\r\n            {\r\n                conn.ConnectionString = \"account=demo16;host=XXXXX.snowflakecomputing.com;user=eddy;password=XXXXXXX;db=edy;schema=public;role=accountadmin;warehouse=etl\" ;\r\n                conn.Open();\r\n\r\n                IDbCommand cmd = conn.CreateCommand();\r\n                cmd.CommandText = \"select * from edy.public.eddy1;\";\r\n                IDataReader reader = cmd.ExecuteReader();\r\n\r\n                while (reader.Read())\r\n                {\r\n                    Console.WriteLine(reader.GetString(0));\r\n                }\r\n\r\n                conn.Close();\r\n            }\r\n\r\n\r\n\r\nI had to add in these commands to properly switch the context:\r\n                IDbCommand cmd = conn.CreateCommand();\r\n                cmd.CommandText = \"use role accountadmin\";\r\n                cmd.ExecuteNonQuery();\r\n\r\n                conn.CreateCommand();\r\n                cmd.CommandText = \"use database edy\";\r\n                cmd.ExecuteNonQuery();\r\n\r\n                conn.CreateCommand();\r\n                cmd.CommandText = \"use schema public\";\r\n                cmd.ExecuteNonQuery();"},"comment":{"url":"https://api.github.com/repos/snowflakedb/snowflake-connector-net/issues/comments/399440227","html_url":"https://github.com/snowflakedb/snowflake-connector-net/issues/42#issuecomment-399440227","issue_url":"https://api.github.com/repos/snowflakedb/snowflake-connector-net/issues/42","id":399440227,"node_id":"MDEyOklzc3VlQ29tbWVudDM5OTQ0MDIyNw==","user":{"login":"eddychansnowflake","id":22844739,"node_id":"MDQ6VXNlcjIyODQ0NzM5","avatar_url":"https://avatars1.githubusercontent.com/u/22844739?v=4","gravatar_id":"","url":"https://api.github.com/users/eddychansnowflake","html_url":"https://github.com/eddychansnowflake","followers_url":"https://api.github.com/users/eddychansnowflake/followers","following_url":"https://api.github.com/users/eddychansnowflake/following{/other_user}","gists_url":"https://api.github.com/users/eddychansnowflake/gists{/gist_id}","starred_url":"https://api.github.com/users/eddychansnowflake/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/eddychansnowflake/subscriptions","organizations_url":"https://api.github.com/users/eddychansnowflake/orgs","repos_url":"https://api.github.com/users/eddychansnowflake/repos","events_url":"https://api.github.com/users/eddychansnowflake/events{/privacy}","received_events_url":"https://api.github.com/users/eddychansnowflake/received_events","type":"User","site_admin":false},"created_at":"2018-06-22T13:21:17Z","updated_at":"2018-06-22T13:21:17Z","author_association":"NONE","body":"Thanks for the quick turnaround, confirmed that this is fixed."}}
{"actor":{"display_login":"eddychansnowflake"}}