if you create a CamelCase connection you cannot (easily) get rid of its schema

[judell]

Try this in aws.spc

connection "DunderMifflin" {
  plugin    = "aws"
  access_key  = "AKI ... RNM"
  secret_key  = "0a2 ... yEi"
}

Then remove it. Then restart steampipe and .inspect. It's still there.

Then do this:

sudo -u root psql -d steampipe -h localhost -p 9193

select * from information_schema.foreign_tables where foreign_table_schema ~ 'Dunder';

                      foreign_table_name
--------------------------------------------------------------
 aws_ssm_managed_instance_compliance
 aws_sns_topic_subscription
 aws_lambda_function_metric_invocations_daily
 aws_ssm_parameter
 aws_kinesisanalyticsv2_application
 aws_securityhub_product

Then try this:

drop schema DunderMifflin cascade
ERROR:  schema "dundermifflin" does not exist

drop schema dundermifflin cascade
ERROR:  schema "dundermifflin" does not exist

Then call @johnsmyth who cleverly suggests quoting the schema name, which works:

drop schema "DunderMifflin" cascade