# Missing aws\_iam\_policy\_versions table in CloudQuery with AWS 23.1.0

**URL:** <https://community.cloudquery.io/t/missing-aws-iam-policy-versions-table-in-cloudquery-with-aws-23-1-0/359>\
**Category:** CloudQuery Plugins\
**Created:** [February 22, 2024, 5:04pm UTC](https://community.cloudquery.io/t/missing-aws-iam-policy-versions-table-in-cloudquery-with-aws-23-1-0/359 "2024-02-22T17:04:28Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![pretty-wolf](https://avatars.discourse-cdn.com/v4/letter/p/7feea3/32.png) [@pretty-wolf](https://community.cloudquery.io/u/pretty-wolf)\
**Post date:** [February 22, 2024, 5:04pm UTC](https://community.cloudquery.io/t/missing-aws-iam-policy-versions-table-in-cloudquery-with-aws-23-1-0/359/1 "2024-02-22T17:04:28Z")

</div>

I’m running into a weird one.  
I’m running AWS 23.1.0, but I don’t see an `aws_iam_policy_versions` table even though it’s listed [here](https://hub.cloudquery.io/plugins/source/cloudquery/aws/v23.1.0/tables/aws_iam_policy_versions).

However, it doesn’t show up when I run `tables`:

```bash
✗ cat config/config.yml | yq '.[] | select(.name == "aws") | .tables'
- aws_*

```

```bash
✗ docker run -v $(pwd)/config:/config ghcr.io/cloudquery/cloudquery:latest tables /config/config.yml --output-dir /config
Loading spec(s) from /config/config.yml
Downloading https://storage.googleapis.com/cq-cloud-releases/cloudquery/source/aws/v23.1.0/linux_amd64
Downloading 100% |████████████████████████████████| (61/61 MB, 18 MB/s)
Generating docs for "aws" to directory "/config/aws"
Done generating docs for "aws" to directory "/config/aws"

```

```bash
✗ cat config/aws/__tables.json | jq '.[].name' | grep aws_iam_policy_versions

```

---

<div class="post-metadata">

**Author:** ![erez](https://sea1.discourse-cdn.com/flex001/user_avatar/community.cloudquery.io/erez/32/40_2.png) [@erez](https://community.cloudquery.io/u/erez)\
**Post date:** [February 22, 2024, 5:10pm UTC](https://community.cloudquery.io/t/missing-aws-iam-policy-versions-table-in-cloudquery-with-aws-23-1-0/359/2 "2024-02-22T17:10:36Z")

</div>

Hi @pretty-wolf,

It’s a relational table, so you won’t see it using the `jq` query, as that query only looks up top-level tables in the JSON. You can use the following command to check for relations:

```auto
cat config/aws/__tables.json | jq '.[].relations' | grep aws_iam_policy_versions

```

This will show it.

---

<div class="post-metadata">

**Author:** ![pretty-wolf](https://avatars.discourse-cdn.com/v4/letter/p/7feea3/32.png) [@pretty-wolf](https://community.cloudquery.io/u/pretty-wolf)\
**Post date:** [February 22, 2024, 5:26pm UTC](https://community.cloudquery.io/t/missing-aws-iam-policy-versions-table-in-cloudquery-with-aws-23-1-0/359/3 "2024-02-22T17:26:48Z")

</div>

Heck,  
this is just more reasoning to move straight to BigQuery (which I’m doing now after multiple gotchas like this).
