{"action":"created","issue":{"url":"https://api.github.com/repos/snowflakedb/snowflake-connector-net/issues/92","repository_url":"https://api.github.com/repos/snowflakedb/snowflake-connector-net","labels_url":"https://api.github.com/repos/snowflakedb/snowflake-connector-net/issues/92/labels{/name}","comments_url":"https://api.github.com/repos/snowflakedb/snowflake-connector-net/issues/92/comments","events_url":"https://api.github.com/repos/snowflakedb/snowflake-connector-net/issues/92/events","html_url":"https://github.com/snowflakedb/snowflake-connector-net/issues/92","id":381555013,"node_id":"MDU6SXNzdWUzODE1NTUwMTM=","number":92,"title":"Time travel data is not available for table X","user":{"login":"denyss-digiterre","id":29480181,"node_id":"MDQ6VXNlcjI5NDgwMTgx","avatar_url":"https://avatars1.githubusercontent.com/u/29480181?v=4","gravatar_id":"","url":"https://api.github.com/users/denyss-digiterre","html_url":"https://github.com/denyss-digiterre","followers_url":"https://api.github.com/users/denyss-digiterre/followers","following_url":"https://api.github.com/users/denyss-digiterre/following{/other_user}","gists_url":"https://api.github.com/users/denyss-digiterre/gists{/gist_id}","starred_url":"https://api.github.com/users/denyss-digiterre/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/denyss-digiterre/subscriptions","organizations_url":"https://api.github.com/users/denyss-digiterre/orgs","repos_url":"https://api.github.com/users/denyss-digiterre/repos","events_url":"https://api.github.com/users/denyss-digiterre/events{/privacy}","received_events_url":"https://api.github.com/users/denyss-digiterre/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2018-11-16T11:11:13Z","updated_at":"2018-11-29T21:23:34Z","closed_at":null,"author_association":"NONE","body":"Hi! I am trying to get the auto-generated ```IDENTITY``` key which is a basic piece of typical ```INSERT``` scenarios.\r\n\r\n```sql\r\nCREATE TABLE IF NOT EXISTS MyTable(\r\n    Id INT IDENTITY(1, 1) NOT NULL,\r\n    DoesNotMatter INT NULL);\r\n\r\nINSERT INTO MyTable (999);\r\nSELECT MAX(Id) FROM MyTable AT (STATEMENT => LAST_QUERY_ID());\r\n```\r\nError:\r\n```\r\n'Time travel data is not available for table MyTable.'\r\n```\r\nThe above works through the Snowflake query HTML page.\r\n\r\nI suspect that the driver injects an extra statement/query between ```INSERT``` and ```SELECT``` or maybe affects session otherwise? And also the driver does not support running more than two commands/queries per command execution. As the result there is nothing usable that would give ```@@IDENTITY``` functionality crucial for ```INSERT```. Please let me know if it's a bug or I am doing something wrong.\r\n\r\nAnd of course documentation around the error above is very-very-very-very-*very* lacking. Google search gives just one exact match. It would be great to list more reasons than **1** as it seems that time travel is one of more advertised features of the product. Thank you and looking forward to some direction/solution."},"comment":{"url":"https://api.github.com/repos/snowflakedb/snowflake-connector-net/issues/comments/442998177","html_url":"https://github.com/snowflakedb/snowflake-connector-net/issues/92#issuecomment-442998177","issue_url":"https://api.github.com/repos/snowflakedb/snowflake-connector-net/issues/92","id":442998177,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0Mjk5ODE3Nw==","user":{"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},"created_at":"2018-11-29T21:23:34Z","updated_at":"2018-11-29T21:23:34Z","author_association":"CONTRIBUTOR","body":"@denyss-digiterre Any more update? If not, I will close the issue."}}
{"actor":{"display_login":"howryu"}}