Setting Session Authorization to Troubleshoot
Sruthi Anumula, Senior Database Support Engineer
September 29, 2023
There are possible scenarios in which a dbadmin would want to run queries as another user to troubleshoot or test. You can use SET SESSION AUTHORIZATION to impersonate another user and run queries. Let's understand this with an example. Here we create a user named test, resource pool named userpool, and make this a default...
Checklist for Inconsistent Execution Time of Same Query in Eon Mode
Sruthi Anumula, Senior Database Support Engineer
September 6, 2023
In Eon Mode, when a query is executed and if the ROS containers associated to the tables in the query are not present in depot, it will fetch results from the communal storage bucket. In the next immediate run, the query should provide results to the user from the files present in the depot. However,...
Using Fall Through Authentication
Sruthi Anumula, Senior Database Support Engineer
July 21, 2023
If a user tries to login using their credentials and the authentication fails, the user cannot login using other authentication methods. A simple example could be a user who was configured with hash authentication. Later, TLS authentication was introduced and granted to all users or in other words granted to the PUBLIC with higher priority....
Creating Iceberg External Tables in Vertica
Sruthi Anumula, Senior Database Support Engineer
June 1, 2023
From Vertica 12.0.4 onwards, we support creating external tables with parquet files in Apache Iceberg Table format. Iceberg is a high-performance table format which uses advanced filtering techniques and provides better performance by avoiding file listing. The striking feature of the external Iceberg tables is that there is no need to specify columns when defining...