Skip to content
This repository has been archived by the owner on Jul 28, 2023. It is now read-only.

The steampipecloud_workspace_snapshot table is not working properly #40

Open
bigdatasourav opened this issue Jul 11, 2023 · 0 comments
Open
Labels
bug Something isn't working

Comments

@bigdatasourav
Copy link
Contributor

Describe the bug

> select * from steampipecloud_workspace_snapshot

Error: 401 Unauthorized (SQLSTATE HV000)

+----+-------------+-----------------+---------------+--------------+------------------+-------+------------+----------------+-----------------+----------------+--------+------+------+---
| id | identity_id | identity_handle | identity_type | workspace_id | workspace_handle | state | visibility | dashboard_name | dashboard_title | schema_version | inputs | tags | data | qu
+----+-------------+-----------------+---------------+--------------+------------------+-------+------------+----------------+-----------------+----------------+--------+------+------+---
+----+-------------+-----------------+---------------+--------------+------------------+-------+------------+----------------+-----------------+----------------+--------+------+------+---



> select id, data from steampipecloud_workspace_snapshot
+------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------
| id                                                   | data                                                                                                                              
+------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------
| snap_cial7pr9rqbm1gfe1fd0_2nn4pqwhuet6t0jcuj1hfxixwl | {"end_time":"2023-06-23T08:12:22Z","inputs":{},"layout":{"children":[{"children":[{"name":"github_tracker.card.container_dashboard
|                                                      | er.container.dashboard_github_open_plugin_mod_pull_request_report_anonymous_container_0","panel_type":"container"}],"name":"github


> select * from steampipecloud_workspace_snapshot

Error: 500 Internal Server Error (SQLSTATE HV000)

+----+-------------+-----------------+---------------+--------------+------------------+-------+------------+----------------+-----------------+----------------+--------+------+------+---
| id | identity_id | identity_handle | identity_type | workspace_id | workspace_handle | state | visibility | dashboard_name | dashboard_title | schema_version | inputs | tags | data | qu
+----+-------------+-----------------+---------------+--------------+------------------+-------+------------+----------------+-----------------+----------------+--------+------+------+---
+----+-------------+-----------------+---------------+--------------+------------------+-------+------------+----------------+-----------------+----------------+--------+------+------+---



> select id, identity_handle,  data from steampipecloud_workspace_snapshot

Error: failed to populate column 'data': unexpected end of JSON input (SQLSTATE HV000)

+----+-----------------+------+
| id | identity_handle | data |
+----+-----------------+------+
+----+-----------------+------+

Steampipe version (steampipe -v)
v0.20.8

Plugin version (steampipe plugin list)
latest

To reproduce
Please run the above queries

Expected behavior
The queries should provide the output correctly

Additional context
Add any other context about the problem here.

@bigdatasourav bigdatasourav added the bug Something isn't working label Jul 11, 2023
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant