OiO.lk Community platform!

Oio.lk is an excellent forum for developers, providing a wide range of resources, discussions, and support for those in the developer community. Join oio.lk today to connect with like-minded professionals, share insights, and stay updated on the latest trends and technologies in the development field.
  You need to log in or register to access the solved answers to this problem.
  • You have reached the maximum number of guest views allowed
  • Please register below to remove this limitation

Information_schema INVALID IDENTIFIER from snowflake when trying to access query history through a python script

  • Thread starter Thread starter panther93
  • Start date Start date
P

panther93

Guest
I am currently working with Snowflake to view the query history. However, when I attempt to execute the same command in Python, following its syntax rules, I encounter an error stating ‘INVALID IDENTIFIER’ for ‘information_schema’.

select * from table(information_schema.query_history())
<p>I am currently working with Snowflake to view the query history. However, when I attempt to execute the same command in Python, following its syntax rules, I encounter an error stating <code>‘INVALID IDENTIFIER’ for ‘information_schema’</code>.</p>
<p><code>select * from table(information_schema.query_history()) </code></p>
 

Latest posts

Top