bug: Azure Compliance pack - Issue with Model / View in Snowflake about cloudquery

[k-rheinheimer]

Thank you for this info! I will look into this and get back to you.

[KarthikVenkatraman]

Hi @k-rheinheimer

Please find my azure (source) config below

spec:
  name: "azure"
  path: "cloudquery/azure"

  version: "v13.1.0"
  tables: [
    "*"
    ]
  destinations: ["snowflake"]
  spec:
    subscriptions: ["xxxx-xxxx-xxxx-xxxx-xxxx"]

The destination (snowflake) config is as below:

kind: destination
spec:
  name: snowflake
  path: cloudquery/snowflake
  version: "v3.4.2"
  write_mode: "overwrite-delete-stale"
  # batch_size: 10000 # optional
  # batch_size_bytes: 5242880 # optional
  spec:
    connection_string: XXXX:[email protected]/XXXX/XXXX?role=XXXX&warehouse=XXXXX

On the Azure plugin version I pointed to the latest version (13.1.0) of the Azure source plugin itself and also the latest version of the Azure Compliance pack (cloudquery_transformation_azure-compliance-premium_v0.8.2) just today and still getting the same issue only.

[k-rheinheimer]

hey @KarthikVenkatraman - I am having some trouble reproducing this, can you provide the queries you were trying to run? Also, if possible, can you send the column types of the view(s) that were created?

[KarthikVenkatraman]

Hi @k-rheinheimer

I was just trying to view the data in the following views:

select * from "AZURE_COMPLIANCE__CIS_V2_0_0"
select * from "AZURE_COMPLIANCE__CIS_V2_1_0"
select * from "AZURE_COMPLIANCE__CIS_V1_3_0"

However this does not work successfully.

I keep getting an error like
Boolean value 'fail' is not recognized or Boolean value 'pass' is not recognized

Please find the column types for the respective views:
"AZURE_COMPLIANCE__CIS_V2_0_0" :

"AZURE_COMPLIANCE__CIS_V2_1_0" :

"AZURE_COMPLIANCE__CIS_V1_3_0" :

Please let me know If you require any further info.

[k-rheinheimer]

Hey @KarthikVenkatraman while I am looking into this, would you mind sharing the redacted azure source config you are using? If you are unable to provide that, can you let me know which version of the azure plugin you are using?

If you could also share a redacted version of the snowflake destination config, I can try to replicate as closely as possible.