While executing the antipattern analysis, I am seeing the following behaviour:
when using input as information schema and output as a bq table, the output is not loaded to the table. I do see in the console log that it recognizes a few queries with anti-patterns, however, nothing is logged in the output table.
When I try using --output_file_path instead of --output_table, the analysis itself changes and no output file is created.
In the above two cases, only the output mode was changed. None of the options produced the output.
Also, option 1 recognized 2 queries with anti-patterns whereas option 2 did not.
Trying to understand what could be the issue here.
Any help is much appreciated.
franklinWhaite
commented
1 year ago
While executing the antipattern analysis, I am seeing the following behaviour:
when using input as information schema and output as a bq table, the output is not loaded to the table. I do see in the console log that it recognizes a few queries with anti-patterns, however, nothing is logged in the output table.
When I try using --output_file_path instead of --output_table, the analysis itself changes and no output file is created.
In the above two cases, only the output mode was changed. None of the options produced the output. Also, option 1 recognized 2 queries with anti-patterns whereas option 2 did not.
Trying to understand what could be the issue here. Any help is much appreciated.