[L:  1, P:  1]      |file:
[L:  1, P:  1]      |    multi_statement_segment:
[L:  1, P:  1]      |        create_procedure_statement:
[L:  1, P:  1]      |            keyword:                                          'CREATE'
[L:  1, P:  7]      |            whitespace:                                       ' '
[L:  1, P:  8]      |            keyword:                                          'OR'
[L:  1, P: 10]      |            whitespace:                                       ' '
[L:  1, P: 11]      |            keyword:                                          'REPLACE'
[L:  1, P: 18]      |            whitespace:                                       ' '
[L:  1, P: 19]      |            keyword:                                          'PROCEDURE'
[L:  1, P: 28]      |            whitespace:                                       ' '
[L:  1, P: 29]      |            procedure_name:
[L:  1, P: 29]      |                naked_identifier:                             'place_name'
[L:  1, P: 39]      |                dot:                                          '.'
[L:  1, P: 40]      |                procedure_name_identifier:                    'proc_name'
[L:  1, P: 49]      |            newline:                                          '\n'
[L:  2, P:  1]      |            procedure_parameter_list:
[L:  2, P:  1]      |                bracketed:
[L:  2, P:  1]      |                    start_bracket:                            '('
[L:  2, P:  2]      |                    [META] indent:
[L:  2, P:  2]      |                    newline:                                  '\n'
[L:  3, P:  1]      |                    whitespace:                               '    '
[L:  3, P:  5]      |                    parameter:                                '_log'
[L:  3, P:  9]      |                    whitespace:                               ' '
[L:  3, P: 10]      |                    data_type:
[L:  3, P: 10]      |                        struct_type:
[L:  3, P: 10]      |                            keyword:                          'STRUCT'
[L:  3, P: 16]      |                            struct_type_schema:
[L:  3, P: 16]      |                                start_angle_bracket:          '<'
[L:  3, P: 17]      |                                [META] indent:
[L:  3, P: 17]      |                                newline:                      '\n'
[L:  4, P:  1]      |                                whitespace:                   '        '
[L:  4, P:  9]      |                                parameter:                    'Process_ID'
[L:  4, P: 19]      |                                whitespace:                   '             '
[L:  4, P: 32]      |                                data_type:
[L:  4, P: 32]      |                                    data_type_identifier:     'STRING'
[L:  4, P: 38]      |                                newline:                      '\n'
[L:  5, P:  1]      |                                whitespace:                   '        '
[L:  5, P:  9]      |                                comma:                        ','
[L:  5, P: 10]      |                                parameter:                    'Debug'
[L:  5, P: 15]      |                                whitespace:                   '                 '
[L:  5, P: 32]      |                                data_type:
[L:  5, P: 32]      |                                    data_type_identifier:     'INT64'
[L:  5, P: 37]      |                                newline:                      '\n'
[L:  6, P:  1]      |                                whitespace:                   '        '
[L:  6, P:  9]      |                                [META] dedent:
[L:  6, P:  9]      |                                end_angle_bracket:            '>'
[L:  6, P: 10]      |                    newline:                                  '\n'
[L:  7, P:  1]      |                    [META] dedent:
[L:  7, P:  1]      |                    end_bracket:                              ')'
[L:  7, P:  2]      |            newline:                                          '\n'
[L:  8, P:  1]      |            newline:                                          '\n'
[L:  9, P:  1]      |            keyword:                                          'BEGIN'
[L:  9, P:  6]      |            [META] indent:
[L:  9, P:  6]      |            newline:                                          '\n'
[L: 10, P:  1]      |            newline:                                          '\n'
[L: 11, P:  1]      |            inline_comment:                                   '-- Declaration'
[L: 11, P: 15]      |            newline:                                          '\n'
[L: 12, P:  1]      |            newline:                                          '\n'
[L: 13, P:  1]      |            procedure_statements:
[L: 13, P:  1]      |                statement:
[L: 13, P:  1]      |                    declare_segment:
[L: 13, P:  1]      |                        keyword:                              'DECLARE'
[L: 13, P:  8]      |                        whitespace:                           ' '
[L: 13, P:  9]      |                        naked_identifier:                     '_Source_Table'
[L: 13, P: 22]      |                        whitespace:                           '       '
[L: 13, P: 29]      |                        data_type:
[L: 13, P: 29]      |                            data_type_identifier:             'STRING'
[L: 13, P: 35]      |                statement_terminator:                         ';'
[L: 13, P: 36]      |                newline:                                      '\n'
[L: 14, P:  1]      |                newline:                                      '\n'
[L: 15, P:  1]      |                statement:
[L: 15, P:  1]      |                    create_table_statement:
[L: 15, P:  1]      |                        keyword:                              'CREATE'
[L: 15, P:  7]      |                        whitespace:                           ' '
[L: 15, P:  8]      |                        keyword:                              'OR'
[L: 15, P: 10]      |                        whitespace:                           ' '
[L: 15, P: 11]      |                        keyword:                              'REPLACE'
[L: 15, P: 18]      |                        whitespace:                           ' '
[L: 15, P: 19]      |                        keyword:                              'TEMP'
[L: 15, P: 23]      |                        whitespace:                           ' '
[L: 15, P: 24]      |                        keyword:                              'TABLE'
[L: 15, P: 29]      |                        whitespace:                           ' '
[L: 15, P: 30]      |                        table_reference:
[L: 15, P: 30]      |                            naked_identifier:                 '_SESSION'
[L: 15, P: 38]      |                            dot:                              '.'
[L: 15, P: 39]      |                            naked_identifier:                 '__Calendar_Target_Buffer'
[L: 15, P: 63]      |                        newline:                              '\n'
[L: 16, P:  1]      |                        bracketed:
[L: 16, P:  1]      |                            start_bracket:                    '('
[L: 16, P:  2]      |                            [META] indent:
[L: 16, P:  2]      |                            whitespace:                       ' '
[L: 16, P:  3]      |                            newline:                          '\n'
[L: 17, P:  1]      |                            whitespace:                       '    '
[L: 17, P:  5]      |                            column_definition:
[L: 17, P:  5]      |                                naked_identifier:             'some_id'
[L: 17, P: 12]      |                                whitespace:                   ' '
[L: 17, P: 13]      |                                data_type:
[L: 17, P: 13]      |                                    data_type_identifier:     'int64'
[L: 17, P: 18]      |                            newline:                          '\n'
[L: 18, P:  1]      |                            [META] dedent:
[L: 18, P:  1]      |                            end_bracket:                      ')'
[L: 18, P:  2]      |                statement_terminator:                         ';'
[L: 18, P:  3]      |                newline:                                      '\n'
[L: 19, P:  1]      |                newline:                                      '\n'
[L: 20, P:  1]      |                statement:
[L: 20, P:  1]      |                    set_segment:
[L: 20, P:  1]      |                        keyword:                              'SET'
[L: 20, P:  4]      |                        whitespace:                           ' '
[L: 20, P:  5]      |                        naked_identifier:                     '_Metric_ID'
[L: 20, P: 15]      |                        whitespace:                           ' '
[L: 20, P: 16]      |                        comparison_operator:
[L: 20, P: 16]      |                            raw_comparison_operator:          '='
[L: 20, P: 17]      |                        whitespace:                           ' '
[L: 20, P: 18]      |                        numeric_literal:                      '1001'
[L: 20, P: 22]      |                statement_terminator:                         ';'
[L: 20, P: 23]      |                newline:                                      '\n'
[L: 21, P:  1]      |                newline:                                      '\n'
[L: 22, P:  1]      |                inline_comment:                               '-- define metric details'
[L: 22, P: 25]      |                newline:                                      '\n'
[L: 23, P:  1]      |                statement:
[L: 23, P:  1]      |                    call_statement:
[L: 23, P:  1]      |                        keyword:                              'CALL'
[L: 23, P:  5]      |                        whitespace:                           ' '
[L: 23, P:  6]      |                        procedure_name:
[L: 23, P:  6]      |                            naked_identifier:                 'some_place'
[L: 23, P: 16]      |                            dot:                              '.'
[L: 23, P: 17]      |                            procedure_name_identifier:        'some_name1'
[L: 23, P: 27]      |                        whitespace:                           ' '
[L: 23, P: 28]      |                        bracketed:
[L: 23, P: 28]      |                            start_bracket:                    '('
[L: 23, P: 29]      |                            [META] indent:
[L: 23, P: 29]      |                            newline:                          '\n'
[L: 24, P:  1]      |                            whitespace:                       '    '
[L: 24, P:  5]      |                            expression:
[L: 24, P:  5]      |                                column_reference:
[L: 24, P:  5]      |                                    naked_identifier:         '_Some_ID'
[L: 24, P: 13]      |                            [META] dedent:
[L: 24, P: 13]      |                            end_bracket:                      ')'
[L: 24, P: 14]      |                statement_terminator:                         ';'
[L: 24, P: 15]      |                newline:                                      '\n'
[L: 25, P:  1]      |                newline:                                      '\n'
[L: 26, P:  1]      |                inline_comment:                               '-- Loop through the list of metrics to run them'
[L: 26, P: 48]      |                newline:                                      '\n'
[L: 27, P:  1]      |                unparsable:                                   !! Expected: "Nothing else before '\\n'"
                    Comments:
[L: 29, P:  5]      |                        inline_comment:                       '--run metric'
                    Code:
[L: 27, P:  1]      |                        word:                                 'WHILE'
[L: 27, P:  6]      |                        whitespace:                           ' '
[L: 27, P:  7]      |                        word:                                 '_indx'
[L: 27, P: 12]      |                        whitespace:                           ' '
[L: 27, P: 13]      |                        less_than:                            '<'
[L: 27, P: 14]      |                        whitespace:                           ' '
[L: 27, P: 15]      |                        word:                                 'ARRAY_LENGTH'
[L: 27, P: 27]      |                        start_bracket:                        '('
[L: 27, P: 28]      |                        word:                                 '_Metrics'
[L: 27, P: 36]      |                        end_bracket:                          ')'
[L: 27, P: 37]      |                        whitespace:                           ' '
[L: 27, P: 38]      |                        word:                                 'DO'
[L: 27, P: 40]      |                        newline:                              '\n'
[L: 28, P:  1]      |                        newline:                              '\n'
[L: 29, P:  1]      |                        whitespace:                           '    '
[L: 29, P: 17]      |                        newline:                              '\n'
[L: 30, P:  1]      |                        whitespace:                           '    '
[L: 30, P:  5]      |                        word:                                 'CALL'
[L: 30, P:  9]      |                        whitespace:                           ' '
[L: 30, P: 10]      |                        back_quote:                           '`place_name.proc_name1`'
[L: 30, P: 33]      |                        start_bracket:                        '('
[L: 30, P: 34]      |                        newline:                              '\n'
[L: 31, P:  1]      |                        whitespace:                           '        '
[L: 31, P:  9]      |                        word:                                 '_Metrics'
[L: 31, P: 17]      |                        start_square_bracket:                 '['
[L: 31, P: 18]      |                        word:                                 '_indx'
[L: 31, P: 23]      |                        end_square_bracket:                   ']'
[L: 31, P: 24]      |                        newline:                              '\n'
[L: 32, P:  1]      |                        whitespace:                           '        '
[L: 32, P:  9]      |                        comma:                                ','
[L: 32, P: 10]      |                        word:                                 '_log'
[L: 32, P: 14]      |                        newline:                              '\n'
[L: 33, P:  1]      |                        whitespace:                           '        '
[L: 33, P:  9]      |                        comma:                                ','
[L: 33, P: 10]      |                        word:                                 '_Thread_Num'
[L: 33, P: 21]      |                        newline:                              '\n'
[L: 34, P:  1]      |                        whitespace:                           '        '
[L: 34, P:  9]      |                        end_bracket:                          ')'
[L: 34, P: 10]      |                        semicolon:                            ';'
[L: 34, P: 11]      |                        newline:                              '\n'
[L: 35, P:  1]      |                        newline:                              '\n'
[L: 36, P:  1]      |                        word:                                 'SET'
[L: 36, P:  4]      |                        whitespace:                           ' '
[L: 36, P:  5]      |                        word:                                 '_indx'
[L: 36, P: 10]      |                        whitespace:                           ' '
[L: 36, P: 11]      |                        equals:                               '='
[L: 36, P: 12]      |                        whitespace:                           ' '
[L: 36, P: 13]      |                        word:                                 '_indx'
[L: 36, P: 18]      |                        whitespace:                           ' '
[L: 36, P: 19]      |                        plus:                                 '+'
[L: 36, P: 20]      |                        whitespace:                           ' '
[L: 36, P: 21]      |                        numeric_literal:                      '1'
[L: 36, P: 22]      |                        semicolon:                            ';'
[L: 36, P: 23]      |            newline:                                          '\n'
[L: 37, P:  1]      |            [META] dedent:
[L: 37, P:  1]      |            keyword:                                          'END'
[L: 37, P:  4]      |    whitespace:                                               ' '
[L: 37, P:  5]      |    unparsable:                                               !! Expected: 'Nothing else in FileSegment.'
        Comments:
[L: 39, P:  1]      |            inline_comment:                                   '--end try'
        Code:
[L: 37, P:  5]      |            word:                                             'WHILE'
[L: 37, P: 10]      |            semicolon:                                        ';'
[L: 37, P: 11]      |            newline:                                          '\n'
[L: 38, P:  1]      |            newline:                                          '\n'
[L: 39, P: 10]      |            newline:                                          '\n'
[L: 40, P:  1]      |            word:                                             'END'
[L: 40, P:  4]      |            semicolon:                                        ';'
[L: 40, P:  5]      |    [META] end_of_file:

==== parsing violations ====
L:  27 | P:   1 |  PRS | Line 27, Position 1: Found unparsable section: 'WHILE _indx <
                       | ARRAY_LENGTH(_Metrics) DO\n...'
L:  37 | P:   5 |  PRS | Line 37, Position 5: Found unparsable section: 'WHILE;\n\n--end
                       | try\nEND;'
WARNING: Parsing errors found and dialect is set to 'bigquery'. Have you configured your dialect correctly?