steampipe-postgres-fdw
steampipe-postgres-fdw copied to clipboard
turbot
The Steampipe foreign data wrapper (FDW) is a zero-ETL product that provides Postgres foreign tables which translate queries into API calls to cloud services and APIs. It's bundled with Steampipe and...
# join 2 tables (Here artifact_name is optional key quals in trivy_scan_artifact table) select artifact_name, artifact_type, metadata from trivy_scan_artifact join aws_ecr_repository on artifact_name = repository_uri After running the above query,...
**Describe the bug** Running this query ``` select jsonb_pretty(attributes) from ldap_user where object_sid = 'S-1-5-21-4049728555-799940961-2503284476-7632'; ``` Seems to return some JSON data with `\u0000`, leading to the error: ``` select...
While querying by joining two tables with multiple join conditions(more than 2 in my case), I observed that one of the conditions was being ignored hence giving incorrect results **To...
`net_http_request` table from `net` plugin fails to handle `jsonb_build_object` in `WHERE` clauses
when I use a `jsonb_object` with both keys and values as literal arrays, the request runs as expected, but when I use an `ARRAY [...]` or `jsonb_build_object` the result is...
Thought I'd try joining the `hackernews_new` table with the `net_http_request` table to try and send slack messages for new items ... fun idea, but unfortunately it doesn't work because of...
We have table `net_dns_record` where `domain` is required to perform the `LIST` operation. We have a use case where we have a CSV file (`domains.csv`) containing a list of domains,...
`select col from child_table where child_table.foreign_field in (select field from parent_table limit 2) limit 10` works fine but `select col from child_table where child_table.foreign_field in (select field from parent_table) limit...
**Describe the bug** I was listing the interfaces on my AWS instance, I compose a query that joins aws_ec2_network_interface, aws_ec2_instance,aws_vpc_subnet. when i run the following query in a simple manner...
Query tested in https://github.com/turbot/steampipe-plugin-aws/pull/1134 Case 1 : with Single in clause (query is working) ``` > explain select service_code, version from aws_pricing_product where service_code = 'AmazonEC2' and field = 'instanceType'...
Investigate why this is and fix This has been seen when running the queries ``` insert into seen_hn_top (id, title, text, url, time) -- Alert for top items on a...
