Blank aggregator connections are not created

[binaek]

If an aggregator connection does not have any underlying connection at the outset, it is not created - even after connections are added which satisfy the aggregator search pattern

[sidr0cker]

Configured my aggregator file to target all aws connections prior to configuring any connections.

[sidr0cker]

Even though I have a single aws connection configured, I cannot query my aggregator.

[binaek]

Because the aggregator.spc file is created before the connections.spc file, during the time of creation, the search pattern in the aggregators is not resolving to any connections - therefore, the schema for the aggregator connection is not created in the service.

[pskrbasu]

Steps to reproduce(in a fresh steampipe install):

• install was plugin
• steampipe service start(keep running)
• add an aggregator connection in a file aws_agg.spc

connection "all_aws" {
  type        = "aggregator"
  plugin      = "aws"
  connections = ["*"]
}

• do not add any other connections
• steampipe query
• will show a warning that connections = ["*"] isn't met as there are no other aws connections.
• select * from all_aws.aws_account - should return empty
• throws error: relation all_aws not found

Now,

• add a connection in a file aws.spc

connection "aws" {
  plugin    = "aws"
  regions   = ["*"]
  profile   = "whatever"
}

• now the aggregator connection(all_aws) should have a connection to aggregate
• no more warnings
• select * from all_aws.aws_account - should return values
• throws error: relation all_aws not found

This is because the schema for the aggregator connection is not created in the service.

Creating an aws connection first does not cause this issue.