datapool_reader InsufficientPrivilege on sdwh4
Hi Uwe,
did you work on sdwh4? The datapool_reader priv. have changed:
InsufficientPrivilege Traceback (most recent call last)
Cell In[9], line 1
----> 1 dp.signal.newest(2)
File ~/main_venv/lib/python3.10/site-packages/datapool_client/core/abstractions.py:1333, in Signal.newest(self, n, to_dataframe, show_query)
1276 """
1277 Parameters
1278 ----------
(...)
1290 dp.signal.newest(4)
1291 """
1293 query_str = dedent(
1294 f"""
1295 SELECT timestamp,
(...)
1330 """
1331 )
-> 1333 return self._query(
1334 query_str,
1335 None,
1336 to_dataframe,
1337 show_query,
1338 False,
1339 COLUMN_MAP["signal_newest"],
1340 )
File ~/main_venv/lib/python3.10/site-packages/datapool_client/core/abstractions.py:110, in Connector._query(self, query_str, vrs, to_dataframe, show_query, allow_modifications, columns)
107 print(query_str)
109 if to_dataframe:
--> 110 result = self.__query_dataframe(query_str[:-1])
111 if columns:
112 result.columns = columns
File ~/main_venv/lib/python3.10/site-packages/datapool_client/core/abstractions.py:132, in Connector.__query_dataframe(self, query)
130 self._conn.rollback()
131 self._close()
--> 132 raise e
File ~/main_venv/lib/python3.10/site-packages/datapool_client/core/abstractions.py:126, in Connector.__query_dataframe(self, query)
122 with _TemporaryFile() as tmpfile:
123 copy_sql = "COPY ({query}) TO STDOUT WITH CSV {head}".format(
124 query=query, head="HEADER"
125 )
--> 126 self._cur.copy_expert(copy_sql, tmpfile)
127 tmpfile.seek(0)
128 return _read_csv(tmpfile, parse_dates=True)
InsufficientPrivilege: permission denied for table signal
I fixed it. Any idea how this happened.
Ps: Also sdwh4 still has the table_schema backup
. That would also take some space, in case that's still present in the uwo datapool/ whdp.