I currently have over 20,000 rows in TabMon and would like to remove some by date.
After stopping TabMon and logging into PG and tabmon and running the below command, I am getting the below error.
select count(*) from countersamples where timestamp < '2016-10-20' --- 237,177
Thanks in advance
I do not believe that this query will work through Tableau Jim. To protect custom SQL from altering data, we always wrap any custom sql command in a select * from "CUSTOM SQL" to avoid potentially altering the DB> IN order to delete data, you will likely have to use psql or pgadmin.