Set Default Maximum Rows for Export

exportSecurityvertica

I am more of a Vertica database user than admin, so I'm not even sure if what I'm asking is absurd, but here goes nothing…

  1. Could I, as an admin, put default restrictions on the number of rows that can be exported per export query? I would like to make sure most users can only export a certain number of rows at a time, and that they cannot change the setting which prevents a massive export. I realize there are probably be ways around this restriction
  2. Would there also be a way to catch a user pulling small amounts of data incrementally from the same data set?

An answer to question (1) would suffice, but I would appreciate any input on question (2), as well.

Best Answer

You can create views using LIMIT and give those view names to the end users. If you're using a development tool such as DBVisualizer, you can set the number of records to limit.

As always, query labels allow for easy tracking of any requests.