Skip to content

fix(aws): Migrate Grafana dashboards#2621

Merged
kodiakhq[bot] merged 6 commits intocloudquery:mainfrom
disq:fix/aws_dashboards
Oct 11, 2022
Merged

fix(aws): Migrate Grafana dashboards#2621
kodiakhq[bot] merged 6 commits intocloudquery:mainfrom
disq:fix/aws_dashboards

Conversation

@disq
Copy link
Copy Markdown
Member

@disq disq commented Oct 11, 2022

closes #2183

All cq_table references were renamed to _cq_table because we don't want the user to get confused about when to use the _cq (id, sync time...) and when it's cq_ etc.

I couldn't get the route_assoc variable to work, but I don't think it was being used for anything meaningful except for the route table query. 0c01533 (#2621) fixes it by removing route_assoc and route_table variables and using the subnet id directly.

In my test env, aws_ec2_route_tables.associations[].SubnetId is null for some reason... could be a different issue or might need more testing.

CASE WHEN EXISTS (SELECT 1 FROM information_schema.columns WHERE column_name='region' AND table_name=tbl) THEN 'region' ELSE E'\'unavailable\'' END,
CASE WHEN EXISTS (SELECT 1 FROM information_schema.columns WHERE column_name='tags' AND table_name=tbl) THEN 'tags' ELSE '''{}''::jsonb' END,
CASE WHEN EXISTS (SELECT 1 FROM information_schema.columns WHERE column_name='fetch_date' AND table_name=tbl) THEN 'fetch_date' ELSE 'NULL::timestamp' END,
CASE WHEN EXISTS (SELECT 1 FROM information_schema.columns WHERE column_name IN ('tags','tag_list','tag_set') AND table_name=tbl) THEN (SELECT column_name FROM information_schema.columns WHERE column_name IN ('tags','tag_list','tag_set') AND table_name=tbl LIMIT 1) ELSE '''{}''::jsonb' END,
Copy link
Copy Markdown
Member Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Here new functionality was added to mitigate the issue with #2026

@disq disq changed the title fix(aws): Migrate grafana dashboards fix(aws): Migrate Grafana dashboards Oct 11, 2022
kodiakhq bot pushed a commit that referenced this pull request Oct 11, 2022
@disq disq added the automerge Automatically merge once required checks pass label Oct 11, 2022
@kodiakhq kodiakhq bot merged commit 438e439 into cloudquery:main Oct 11, 2022
@disq disq deleted the fix/aws_dashboards branch October 11, 2022 16:14
kodiakhq bot pushed a commit that referenced this pull request Oct 12, 2022
🤖 I have created a release *beep* *boop*
---


## [2.2.0](plugins-source-aws-v2.1.0...plugins-source-aws-v2.2.0) (2022-10-12)


### Features

* Add support for EC2 reserved instances ([#1912](#1912)) ([42120a2](42120a2))
* Add Support for HSMv2 Clusters and Backups ([#2530](#2530)) ([b448bc6](b448bc6))
* Add Support For KMS Aliases ([#2528](#2528)) ([2e422dc](2e422dc))


### Bug Fixes

* **aws:** Migrate Grafana dashboards ([#2621](#2621)) ([438e439](438e439))
* **docs:** Add more info on adding Resource ([#2603](#2603)) ([9a29bbd](9a29bbd))
* Update AWS plugin to SDK v0.13.5 ([#2661](#2661)) ([a835034](a835034))

---
This PR was generated with [Release Please](https://github.com/googleapis/release-please). See [documentation](https://github.com/googleapis/release-please#release-please).
kodiakhq bot pushed a commit that referenced this pull request Oct 30, 2022
Just like #2634, #2621 and #2628 but this time completely untested.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

automerge Automatically merge once required checks pass

Projects

None yet

Development

Successfully merging this pull request may close these issues.

Imported Grafana AWS Inventory Dashboard Doesn't Work

3 participants