cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

Persisting query history data

WWoman
New Contributor III

Hello,

I am looking for a way to persist query history data. I have not have direct access to the system tables. I do have access to a query_history view created by selecting from the system.query.history and system.access.audit system tables. I want to create a simple process that will incrementally load the data that I access through the view into a table..

What is the simplest way to achieve this?

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions

yuriy
New Contributor III
New Contributor III

Hi @WWoman you can set up a simple append only DLT pipeline or just schedule a job that will run merge statement insert * only. In both cases you will get a table that will accumulate history of additions in your view over time and in both cases it will be incremental

View solution in original post

2 REPLIES 2

yuriy
New Contributor III
New Contributor III

Hi @WWoman you can set up a simple append only DLT pipeline or just schedule a job that will run merge statement insert * only. In both cases you will get a table that will accumulate history of additions in your view over time and in both cases it will be incremental

syed_sr7
New Contributor II

Is any system table there for query history?

Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!