[BUG]: Cannot define KPI with tables which contain '-' in the table name.

[bhargavsk1077]

Describe the bug

Defining a KPI with 'Table' as Dataset type and selecting a table which contains a '-' in the table name results in failure.

The issue is observed in the following datasources:

• Redshift
• Snowflake
• Druid

Explain the environment

• Chaos Genius version: 0.4.1
• OS Version / Instance: Any
• Deployment type: Any

Current behavior

Select 'Table' as the Dataset type and select a table which contains '-' in the table name (Example - 'cloud-cost'). Upon clicking 'Add KPI' after selecting other relevant fields we face an error that says - syntax error at or near '-' or unexpected '-'.

Selecting 'Query' as the Dataset type and enclosing the table name in quotes in the query leads to KPI addition being successful.

Expected behavior

KPI Addition should be possible for all such tables with 'Table' as the dataset type.

Screenshots

Additional context

To test KPI Addition with Druid as Datasource use the branch 'druid-connector'.

[Samyak2]

Fixed in v0.8.0